Validation for Import/Export Excel

Validation for Import/Export Excel

Posted by: srinivasan.lakshmanan on 23 July 2018, 2:00 am EST

• 

  srinivasan.lakshmanan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 23 July 2018, 2:00 am EST

  Hi,
  
  Help me in doing validations for Importing and Exporting Excel.Is there any way to set validations for the Excel to be Imported or Exported?

  Thank you in advance.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 23 July 2018, 7:35 am EST

  Hello Srinivasan,

  May I know based on what condition you want to Import/Export Excel? SpreadJS already only imports/exports xlsx files.

  Thanks,
  
  Deepak Sharma

• 

  srinivasan.lakshmanan

  • Post Options:
  • Link
    Copy

  Posted 23 July 2018, 9:23 am EST

  Deepak,

  As per the requirement, user must download the sample template and edit the sheet and then upload the same template.

  Any files other than this format should not get imported. If so, it must throw an error.

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 July 2018, 12:34 am EST

  Hi Srinivasan,

  If you have written the code for importing and exporting Excel files only from Spread.Sheets then the user will not be able to import/export any other format.

  For example in the online demo here you can only export and import to Excel format:
  
  https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/ExcelIO

  Thanks,
  
  Deepak Sharma

• 

  srinivasan.lakshmanan

  • Post Options:
  • Link
    Copy

  Posted 24 July 2018, 3:11 am EST

  Hi Deepak,

  We are able to restrict the format to xlsx .But our requirement is in xlsx we should allow only xlsx file with our download template.

  thank you

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 July 2018, 8:05 am EST

  Hello,

  The only way to validate the file is either by name or extension.

  Thanks,
  
  Deepak Sharma