Upgrading from Spread7.com to Spread8.com

Upgrading from Spread7.com to Spread8.com

Posted by: bkh_vb on 11 February 2018, 4:47 am EST

• 

  bkh_vb

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 February 2018, 4:47 am EST

  Long-time user of Spread7.com and recently downloaded the trial version of Spread8.com. My application is developed in Windows XP Mode under the Windows Virtual PC on a Windows 7 Pro OS. Simple question, do I have to uninstall Spread7.com before installing the trial version of Spread8.com?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 February 2018, 5:19 pm EST

  Hello,

  No, you can install Spread 8 COM on the machine where Spread 7 installed. It should work without conflicting with the older version.

  Thanks,
  
  Deepak Sharma

• 

  bkh_vb

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 10:39 am EST

  Next question, the documentation states that Spread8.com will export in Excel 2007 format (.xlxs) but I can’t find in the documentation that it will also import in Excel 2007 format – I am sure that it does, but just want to confirm.

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 8:30 pm EST

  Hello,

  Yes, Spread 8 can import an Excel 2007 file too. You can use the ‘OpenExcel2007File’ method to import an excel 2007 file.

  Thanks,
  
  Deepak Sharma

• 

  bkh_vb

  • Post Options:
  • Link
    Copy

  Posted 18 February 2018, 4:56 am EST

  I am testing the trial version of Spread8 and trying to import an .xlsx file with no success.

  Under Spread7, I first tested the file to see if it is a valid Excel file using the following code…

  ExcelTest = Spread1.IsExcelFile(.FileName)

  where .filename is the name of the file captured from a dialog box and ExcelTest is defined as an integer. This code worked.

  However, when I try the test using the following…

  ExcelTest = Spread1.IsExcel2007File(.filename)

  the line compiled and seemed to work but the test failed when the file is definitely an .xlsx file.

  The documentation indicates that the test statement should actually be…

  ExcelTest = Spread1.IsExcel2007File(.filename) as IsExcel2007FileConstants

  but when I add the “as IsExcel2007FileConstants” statement at the end of the line by selecting it from the dropdown box then pressing enter, I receive the following error…

  Compile error: Expected end of statement

  Skipping the Excel test, I tried to open the file using the following statement

  First I saved the name of the .xlsx file in the following variable using

  XLFile = .FileName

  Under Spread7 the code was…

  F = Spread1.ImportExcelBook(XLFile,“”)

  where F is dimensioned as Boolean

  However, under Spread8, the statement I use is

  F = Spread1.OpenExcel2007File(XLFile, “”, -1, “”, “”)

  but when I execute the code I get the following error

  Runtime error 13: Type Mismatch

  even though it had been defined as Boolean

  What am I doing wrong?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 19 February 2018, 1:35 am EST

  Hello,

  The code to open an Excel 2007 file is :

  fpSpread1.OpenExcel2007File “C:\Myxls.xlsx”, “”, -1, -1, App.Path & “\ImportExport\log.txt”

  Please test the attached sample application with Spread 8 and let me know if your still face the issue.

  Thanks,
  
  Deepak SharmaSpreadCOM_ImportExport.zip