Importing Legacy (COM) Spreadsheet Files

Importing Legacy (COM) Spreadsheet Files

Posted by: karl on 19 November 2019, 1:59 pm EST

• 

  karl

  • Post Options:
  • Link
    Copy

  Posted 19 November 2019, 1:59 pm EST

  I have been tasked with updating an antique (VB6) program that used the “Spread ADO 7.0.05 (OLEDB)” component. The legacy program saved the FpSread 7 data using FarPoint’s native (I think) file format. The code used is:

  Me.sprData(x).SaveToFile TempFile, False
  

  I now need to read and display this data in a .Net desktop application (Spread/Winforms), but do not see anything in any of the WinForms grids that allow me to do this. The only method I saw was “ReadXml” but this won’t work as the legacy files are some sort of proprietary (not xml, BIFF8, XLS, or XLSX) format.

  Any ideas?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 12:36 am EST

  Hello Karl,

  Please use the OpenExcel and SaveExcel method to load and save the excel files.

  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~SaveExcel.html
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~OpenExcel.html

  Thanks,
  
  Mohit

• 

  karl

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 8:17 am EST

  Mohit,

  Thanks for your reply but that will not work. First, I do not have the FarPoint components installed on the computer I am currently using for my Visual Studio 2019 development. This computer has the Component One suite installed and licensed.

  Second, the files created by the Farpoint v7 COM object are proprietary to Farpoint. They are not Excel files. According to the Farpont Spread v7 documentation, “Binary files are in a proprietary format that only the fpSpread control or the Spread Designer can read.”

  What else do you have?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 November 2019, 2:30 am EST

  Hello,

  Could you please install the Spread on your system from the following link:
  
  https://www.grapecity.com/download/spreadnet
  
  It is not a part of the Component One suite. You have to install it explicitly. Spread has a different license so you have to purchase it.

  In my understanding, you mean “.ss7” file which created by spread 7 com. You can use the “OpenSpreadFile” method to open the .ss7 file in the latest version of spread for winform.
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~OpenSpreadFile.html
  
  https://help.grapecity.com/spread/SpreadNet12/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.SheetView~OpenSpreadFile.html

  Hope it helps.

  Thanks,
  
  Mohit

• 

  karl

  • Post Options:
  • Link
    Copy

  Posted 21 November 2019, 9:04 am EST

  So you’re saying that after spending $2,000.00 on the C1 Winforms Ultimate software, to get spreadsheet functionality I need to spend another $1,500.00? Awesome.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2019, 4:40 am EST

  Hello Karl,

  Actually, ComponentOne Ultimate and Spread are different product suites. You have purchased ComponentOne Ultimate which includes the following Editions:

  1: WinForms Edition
  
  2: WPF Edition
  
  3: ASP.Net MVC Edition
  
  4: ActiveX Edition
  
  5: ASP.Net WebForms Edition
  
  6: LightSwitch Edition
  
  7: Silverlight Edition
  
  8: UWP Edition
  
  9: Studio for Xamarin
  
  10: Xamarin.IOS Edition
  
  11: Xamarin.Android Edition
  
  12: Wijmo Enterprise

  You can refer to the following link for more information:
  
  https://www.grapecity.com/compare/componentone-ultimate

  Also, you can refer to following page for pricing of each studio:
  
  https://www.grapecity.com/pricing

  Hope it clarifies.

  Thanks,
  
  Mohit