[Lazarus] Using Microsoft Excel workbooks with Lazarus

[Michael Thompson]

G'day,

>>> I am writing an application that requires extensive use of Microsoft
Excel .xlsx worksheets.
>>> I have no success using OCDB connections. Does anyone use
TODBCConnection with excel?

>> Why not use the fpspreadsheet that comes with lazarus ?

> I am using the fpspreadsheet , but being able to write data directly to
> the worksheet would save me a lot of time

Sorry for stepping in on a tool I know little about.  I'm sure though I've
previously successfully used fpspreadsheet for write.

In https://wiki.freepascal.org/FPSpreadsheet, have a look at:
https://wiki.freepascal.org/FPSpreadsheet#How_to_add_and_read_data_to.2Ffrom_a_cell

Once you've made your changes.
procedure WriteToFile(const AFileName: string; const AFormat:
TsSpreadsheetFormat; const AOverwriteExisting: Boolean = False):

Back to lurking...

Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240222/a06c7deb/attachment.htm>