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
-- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
