Which import to use?

Which import to use?

Posted by: pedro.moraes on 6 April 2023, 9:23 am EST

• 

  pedro.moraes

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 April 2023, 9:23 am EST

  What is the correct way to import an excel?

  I’m using v16.0.3

  When v16 was released they added workbook.import to be used instead of excelIO.open but I couldn’t find documentation explaining how to use it. Is excelIo still being recommended?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2023, 1:45 pm EST

  Hi Pedro,

  Currently, you could import the Excel file using both the ExcelIO and also using the Spread-IO that is released with the SpreadJS V16.

  SpreadIO provided new features like opening and saving sjs file formats, lazy loading etc. Currently SpreadIO supports almost every functionality that was previously present in ExcelIO. However, opening and saving the password protected files in currently not supported with SpreadIO. It might be supported with the newer release.

  So, if you don’t use the password protected excel files, it is recommended to use the SpreadIO for better performance and newer features.

  You could refer to the following demo on SpreadIO: https://www.grapecity.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs

  SpreadJS File Format: https://www.grapecity.com/spreadjs/docs/features/spreadjs-file-format

  Please let us know if you face any problems.

  Regards,

  Ankit

• 

  pedro.moraes

  • Post Options:
  • Link
    Copy

  Posted 17 April 2023, 9:46 am EST - Updated 17 April 2023, 9:51 am EST

  I got it,

  Could you send me the model you use at https://www.grapecity.com/spreadjs/designer/index.html for import, with all fields and options.

  

  607×604 23.4 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 April 2023, 8:49 am EST

  Hello,

  As I can understand, you want to know the import and export options that are used in SpreadJS Designer at https://www.grapecity.com/spreadjs/designer/index.html
  
  The excel files are imported and exported with Spread IO module. In Spread IO module, spread.import() and spread.export() methods are used to import and export excel files respectively. You can specify import options in spread.import() method and export options in spread.export() method.

  Spread IO module also provides spread.open() and spread.save() methods to save and open SJS format files. You can specify import and export options in these methods as well.

  Please refer to the code snippet and attached sample.

      spread.export((blob) => {
          saveAs(blob, 'excel_file');
      }, console.log, 
      {
          fileType: 0,
          includeBindingSource: false, 
          includeStyles: true,
          includeFormulas: true,
          saveAsView: false,
          rowHeadersAsFrozenColumns: false,
          columnHeadersAsFrozenRows: false, 
          includeAutoMergedCells: false,
          includeCalcModelCache: false,
          includeUnusedNames: true,
          includeEmptyRegionCells: true,
      });
  

  Similarly, you can use import/export options in spread.import() method, spread.open() and spread.save() methods as well.

  Sample: https://jscodemine.grapecity.com/share/HEqZ5g_XhEeLkyq_NyxyXQ/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you still face any difficulties.

  Doc references:

  spread.import():https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Workbook#import

  spread.export():https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Workbook#export

  ExportXlsxOptions: https://www.grapecity.com/spreadjs/api/v16/modules/GC.Spread.Sheets#exportxlsxoptions

  ImportXlsxOptions: https://www.grapecity.com/spreadjs/api/v16/modules/GC.Spread.Sheets#importxlsxoptions

  Regards,

  Ankit