[Lazarus] ODBC configurations for Excel on Lazarus

[Michael Van Canneyt]

On Fri, 11 Mar 2022, Werner Pamler via lazarus wrote:

> Am 11.03.2022 um 23:03 schrieb Michael Van Canneyt via lazarus:
>> Would it not be easier to use fpspreadsheet ?
>> 
>> Accessing excel through odbc seems a rather roundabout way.
>
> Yes, definitely (https://wiki.lazarus.freepascal.org/FPSpreadsheet). In the 
> most recent release there is even a TsWorksheetDataset which allows to access 
> the spreadsheet in a database way.

Cool, I didn't know that one yet ! :-)

Is there an example for it's use ? 
Given the way companies often rape excel sheets, 
this component will make life a lot easier for many things :-)

Michael.