In an existing Excel file, it draw the frame borders white color.
Code: Select all
XLSReadWriteII51.FileName:='C:\XLSRWII.xlsx';
XLSReadWriteII51.Read;
XLSReadWriteII51.CmdFormat.BeginEdit(XLSReadWriteII51[1]);
XLSReadWriteII51.CmdFormat.Border.Style := cbsThin;
XLSReadWriteII51.CmdFormat.Border.Preset(cbspOutlineAndInside);
XLSReadWriteII51.CmdFormat.Apply(1, 1, 10, 10);
XLSReadWriteII51.Write;