There is a problem in column insert operation of Excel files

[ykarapinar]

When you want to insert 1 column, it creates 2 columns instead in an Excel file;
Inserted column's contents are inserted up to line 256, all input stays remained after line number 256.

Code: Select all

var
  col, row: Integer;
begin
  XLSReadWriteII51.FileName:='C:\XLSRW.xlsx';
  for col:=0 to 10 do
    for row:=0 to 300 do
      XLSReadWriteII51.Sheets[0].AsString[col, row]:='[' + IntToStr(col) + ':' + IntToStr(row) + ']';

  XLSReadWriteII51[0].InsertColumns(4, 1);
  XLSReadWriteII51.Write;
end;

[ykarapinar]

Hello Larsa,
I didn't get any reply to the post I've made.
Is it possible that you take a look, this issue is holding us back.
Thank you.