Page 1 of 1
Import from .ots (OpenOffice, LibreOffice) files
Posted: Wed Nov 08, 2017 3:16 pm
by mpuppe_jam
Hi,
The product page for XLSReadWriteII (
http://www.axolot.com/xls.htm) says that data can be imported from "Open Office Calc documents". However, I cannot find any documentation on this feature. How can I import data from such files?
Thanks,
Martin Puppe, JAM Software
Re: Import from .ots (OpenOffice, LibreOffice) files
Posted: Mon Nov 13, 2017 7:48 am
by larsa
Hello
This seems to have disappeared fore some time ago, but it's back now. Download the latest update.
Here is a sample:
Code: Select all
uses XLSImportOOCalc5;
var
OOC: TXLSImportOOC;
begin
OOC := TXLSImportOOC.Create(XLS);
try
OOC.LoadFromFile('Test.ods');
finally
OOC.Free;
end;
end;
Re: Import from .ots (OpenOffice, LibreOffice) files
Posted: Tue Nov 14, 2017 2:39 pm
by mpuppe_jam
Thanks for your reply. I cannot update to the newest version right now. But I will test it as soon as we are updating.
Re: Import from .ots (OpenOffice, LibreOffice) files
Posted: Fri Nov 30, 2018 6:36 pm
by Mick.pl
Hi,
I can read Open Office Calc documents using the above example - thanks a lot.
Then I do XLSGrid.Refresh (or Repaint) and then XLS grid shows spreadsheet contents.
But no formatting is done - columns size, font - all of that is ignored.
Is it possible to solve my problem with that formatting?
Michal
Re: Import from .ots (OpenOffice, LibreOffice) files
Posted: Mon Dec 03, 2018 8:29 am
by larsa
Hello
Sorry, formatting is not supported in ODS files.
Re: Import from .ots (OpenOffice, LibreOffice) files
Posted: Tue Dec 04, 2018 9:27 am
by Mick.pl
Thank you for the reply.
You do not write about this functionality in the future updates, so does it mean you don't plan such a progress of your product?
Michal