Import from .ots (OpenOffice, LibreOffice) files

[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

[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;

[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.

[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

[larsa]

Hello

Sorry, formatting is not supported in ODS files.

[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