I use Lazarus IDE 1.2.4 and would like to be able to access cells in specific Open Office SpreadSheets.
My first aim is to read and identify tabs, colors, bold/italic/normal, font, size and the actual text of course, where the text is most important. The color of the cell is second important. The actual formatting of the text is useful but not that important.
My second goal is to update /change or rewrite certain cells with new or changed information.
Are there any easy methods for doing this?
like:
VAR
MaxTab : BYTE;
MyString : Ansistring;
BEGIN
MaxTab := OOSheetsMax; // To get the count of the sheets in the active document.
OOSheetActive := 1; // To set the first sheet active
MyString := OOCell[1,1]; // To read the text only in this cell.
OOCell[2,1].AsAnsiString := IntToStr(Length(MyString)); // Just to add information to the sheet as text.
OOCell[3,1].AsInteger := Length(MyString); // Just to add information as a number.
...