Finding that the xlsreadwriteII 4 suite basically works well
using Delphi 2007
but I do have some issues
1 - the samples all refer to the xlsreadwriteII2 components
and don't run out of the box
2 - using the sample code
// Make sure that there are row objects at the desired positions
XLS.Sheet[0].Rows.AddIfNone(6,4);
// Set the height of a row in points (14pt, 1/20th of a point).
XLS.Sheet[0].Rows[6].Height := 280;
// Set the height of a row in pixels
XLS.Sheet[0].Rows[7].PixelHeight := 20;
// Format cell color of all cells in the row
XLS.Sheet[0].Rows[8].FillPatternForeColor := xcRed;
// Format font style of all cells in the row
XLS.Sheet[0].Rows[9].FontStyle := [xfsBold];
results in an xls that can't be read
using excel 2003 viewer and excel 2003 full product both say
"unable to read file"
3 - any attempt to manipulate a row height or pixelheight,
again using code straight out of the help file throws
exceptions on execution
any ideas? Thank-you