Page 1 of 1

Drawing frame borders white color

Posted: Tue Mar 10, 2020 7:19 am
by ykarapinar
Hello
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;