Import Excel and map columns in Wijmo Flexsheet

Import Excel and map columns in Wijmo Flexsheet

Posted by: reeshabh.choudhary on 23 April 2019, 4:59 am EST

• 

  reeshabh.choudhary

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 April 2019, 4:59 am EST

  How can we import local excel in wijmo flexsheet and map columns and field values?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 24 April 2019, 4:13 am EST

  Hi

  We could use the load/loadAsync method of FlexSheet class to load an excel file into the flex sheet instance.
  
  Please refer to the sample below:
  
  https://stackblitz.com/edit/angular-fr7bew?file=src/app/app.component.html

  Further could you please let us know what you mean by map columns and field values?

  API Reference:
  
  loadAsync: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#loadasync
  
  load: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#load

  Regards