Maximum limit on number of columns in importing an excel using excelIO.open

Maximum limit on number of columns in importing an excel using excelIO.open

Posted by: Ramya.Mayilsamy on 27 March 2019, 11:00 am EST

• 

  Ramya.Mayilsamy

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 March 2019, 11:00 am EST

  Hi I’m trying to open a excel file using excelIO.open which has lot many columns (starting with A to WVZ) using grapecity Spread JS. The page becomes unresponsive after this.
  
  But if I copy the same content leaving the empty columns at the last (so that I can reduce it), and pasted in other file, and trying to import it, it works fine.
  
  So is there any restrictions on the number of columns that excel should hold ?
  
  I/m using json format to open this.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 28 March 2019, 7:27 am EST

  Hello Ramya,

  There isn’t any specified limit for number of columns to be imported in SpreadJS from Excel.

  Hence, could you please share your Excel file which you are trying to load wherein you are getting unresponsive script error. We will test the same at our end.

  You can send your excel file at SupportOne by creating a new case with same subject as that of this forum:-
  
  https://supportone.componentone.com/newcase

  Please provide us with the same. We will look into this issue thereon.

  Thanks,
  
  Reeva