Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2024-02

Using Microsoft Excel workbooks with Lazarus

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Larry Dalton

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? Sent from my iPhone

Reply by email

Michael Van Canneyt
to Larry Dalton
Larry Dalton wrote
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?

There are reports that it works.

Why not use the fpspreadsheet that comes with lazarus ? It has always proved sufficient for me.

Michael.

Reply by email

Larry Dalton
to Michael Van Canneyt

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

Show quoted text 19 lines
On Feb 20, 2024, at 12:20, Michael Van Canneyt via lazarus wrote: ? > On Tue, 20 Feb 2024, Larry Dalton via lazarus wrote: > > 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? There are reports that it works. Why not use the fpspreadsheet that comes with lazarus ? It has always proved sufficient for me. Michael. -- _______________________________________________ lazarus mailing list https://lists.lazarus-ide.org/listinfo/lazarus

Reply by email

Michael Thompson
to Larry Dalton

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>

Reply by email