Lazarus

Programming => Packages and Libraries => FPSpreadsheet => Topic started by: bmusshca on May 18, 2021, 11:46:58 am

Title: Alternative to use FPSpreadsheet with Excel 2019 (office 360)
Post by: bmusshca on May 18, 2021, 11:46:58 am

I am working on a GUI project where I use the library FPSpreadsheet. The GUI works very well with excel 2003 (I notice that FPSpreadsheet is compatible with it: https://wiki.freepascal.org/FPSpreadsheet#Support_and_Bug_Reporting). Using excel 2019 (office 360) is reporting so many bugs, charts, and many information is not reported.

I would like to know if there are alternatives to use this library with the current version of excel. I have tried with Tkinter but no success.

Thank you.

Title: Re: Alternative to use FPSpreadsheet with Excel 2019 (office 360)
Post by: wp on May 18, 2021, 01:25:52 pm

These are some libs which I came across, but never used:

* http://www.kluug.net/xlsx-ods-delphi.php (commercial)
* http://avemey.com/, https://github.com/Avemey/zexmlss: (free)

There are more commercial Delphi components by the big players, TMS etc., I don't know if they work with Lazarus.

Title: Re: Alternative to use FPSpreadsheet with Excel 2019 (office 360)
Post by: Jurassic Pork on May 18, 2021, 04:39:03 pm

hello,
you can try to use office automation (https://wiki.lazarus.freepascal.org/Office_Automation)
Friendly, J.P