Importing excel files

Importing excel files

Posted by: yianeco on 12 September 2017, 12:14 am EST

• 

  yianeco

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 September 2017, 12:14 am EST

  I am having problems importing excel files with .xlsx or even .xls sometimes extension (Spread 8 COM).
  
  The process hangs and the form becomes unusable.
  
  I am attaching an excel file that creates such a problem.
  
  I am using ImportExcelBook.

  Please advise

  Regards

  Yiannis

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 12 September 2017, 11:31 am EST

  Hi Yiannis,

  It seems that because the technical issues in website currently, your attachments did not get through. You may again try to attach the sample application or create a ticket for your issue here:
  
  https://www.grapecity.com/en/support/new-ticket?product=spread

  Sorry for the inconvenience.

  Thanks,
  
  Deepak Sharma

• 

  yianeco

  • Post Options:
  • Link
    Copy

  Posted 20 September 2017, 2:25 am EST

  Hi,

  I am attaching the excel file again.

  Thanks

  YiannisTestExcel.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 25 September 2017, 3:18 am EST

  Hi Yiannis,

  Sorry for the long delay in getting back to you. I am able to open the Excel file provided by you with Spread 8 COM.
  
  I used the unicode version of Spread 8 COM to open your Excel file because it is not in English using the code as follows:
  
  fpSpread1.OpenExcel2007File “C:\QS-LIS DOMOPLUS 2ïêëä.xlsx”, “”, -1, -1, “”

  Please test the same with unicode version and let me know. I have also attached an image for your reference.

  Thanks,
  
  Deepak Sharma
  
  

• 

  yianeco

  • Post Options:
  • Link
    Copy

  Posted 25 September 2017, 10:46 pm EST

  Hi Deepak,

  Thanks for the feedback.
  
  What is the difference of OpenExcel2007File and ImportExcelWorkbook methods?.
  
  When do you suggest to use each one ?

  Yiannis

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 September 2017, 4:25 am EST

  Hi Yiannis,

  OpenExcel2007File is a new method which was introduced with Spread 8. It is specifically used to import .xlsx files.
  
  Whereas ImportExcelWorkbook is the old supported method to import Excel(xls) files.

  In case you are working with the xlsx files, you should use OpenExcel2007File() method.

  Thanks,
  
  Deepak Sharma

• 

  yianeco

  • Post Options:
  • Link
    Copy

  Posted 26 September 2017, 5:08 am EST

  Thanks,

  Some more questions please,

  1. Can I use OpenExcel2007File to open .xls files ?
  2. What is the next log text mean ? (what is 120?)

  ===== FarPoint Technologies, Inc =====
  
  ===== Begin of Excel Workbook General Load =====
  
  26-09-17 12:04:25 PM

  Col Row Information

  ---

  	120:Import Excel File: F:\Temp\QS-LIS DOMOPLUS 2ΜΙΚΕ.xlsx
  

  ===== End of Excel Workbook General Load =====

  Regards

  Yiannis

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 3:15 am EST

  Hi Yiannis,

  OpenExcel2007File method can be used only to open xlsx format Excel files.
  
  The log file contains the information about the conversion of the Excel-formatted file which is imported to Spread. ‘120’ is the message number for the successful message in the log file.
  
  It uses many other message numbers to display information about imported data.

  In case you do not wish to create a log file , do not provide the log file name and set it to “”.

  for example:
  
  fpSpread1.OpenExcel2007File “C:\QS-LIS DOMOPLUS 2ïêëä.xlsx”, “”, -1, -1, “”

  Thanks,
  
  Deepak Sharma

• 

  yianeco

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 10:24 pm EST

  Thanks, I have located the codes in the reference manual regarding importing/exporting excel files but I could not find number 120.

  Regards

  Yiannis

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 28 September 2017, 6:09 am EST

  Hi Yiannis,

  In log file ‘120’ is the message number kept for internal use. There are several other messages numbers(codes) that give information about the success or failure of the import/export.

  Thanks,
  
  Deepak Sharma