Code: Select all
XLS := TXLSReadWriteII5.Create(nil);
XLS.Sheets[0].Cell[0, 0].FillPatternForeColorRGB := 0;
Now, these are not writeable any more.
What is now the preferred method of creating an empty cell so that for example the cell color can be set?
I could not find any sample that created a blank cell.
Is it to write an empty string?
XLS.Sheets[0].AsBlank[0, 0] := True; // doesn't work either