Opening xlsx file on the server

Opening xlsx file on the server

Posted by: cto on 15 January 2018, 10:05 pm EST

• 

  cto

  • Post Options:
  • Link
    Copy

  Posted 15 January 2018, 10:05 pm EST

  Hi,

  I have two questions.

  1. Can I open xlsx file on the server? We don’t want the user to open themselves.

  http://demos.wijmo.com/5/Angular2/FlexSheetExplorer/FlexSheetExplorer/#/excelIO

  2. Can I get the data from the specific column and set to another column after counting words? Please find the copy of the file to understand our requirements.

  We used handsontable before but it doesn’t support multiple sheets. So trying to find another solution.

  Please advise. Thanks.

• 

  cto

  • Post Options:
  • Link
    Copy

  Posted 15 January 2018, 10:06 pm EST

  Please find the copy of the file to understand our requirements.

  Workbook1.xlsx.zip

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2018, 1:11 am EST

  Hi,
  
  You may open load excel file if you provide arraybuffer for excel file. Please refer to the following documentation;
  
  http://demos.wijmo.com/5/Angular/WijmoHelp/WijmoHelp/topic/wijmo.grid.sheet.FlexSheet.Class.html#load

  Currently, Wijmo FlexSheet do not support vlookup function. We have logged an enhancement request to the team for further investigation with internal tracking id 236392.

  This may be added in the future releases.

  For you we have an another product names SpreadSheet which may be replace handsontable.

  Spread provide quite similar functionality as Excel. Please have a look for the following demo and blog for your requirement.
  
  Load Excel from Server :https://www.grapecity.com/en/blogs/how-to-import-xlsx-from-a-url-with-pure-js-logic

  Demo Samples : https://www.grapecity.com/en/demos#Spread-Sheets
  
  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  Hope it helps!

  ~Manish