Hi Pieter,
GridStartCol and GridStartRow work fine
(I didn't read the documentation good enough)
Here's my example about not exporting the hidden columns.
I just dropped a TTMSFMXGrid and TTMSFMXGridExcelIO on the form.
procedure TForm1.FormCreate(Sender: TObject);
var
c, r: Integer;
begin
TMSFMXGrid1.RowCount := 10;
TMSFMXGrid1.ColumnCount := 10;
TMSFMXGrid1.FixedColumns := 0;
for r := 0 to TMSFMXGrid1.RowCount - 1 do
begin
for c := 0 to TMSFMXGrid1.ColumnCount - 1 do
begin
TMSFMXGrid1.Cells[c, r] := Format('R%dC%d', [r, c]);
TMSFMXGrid1.Comments[c, r] := Format('Comment R%dC%d', [r, c]);
end;
end;
TMSFMXGrid1.HideColumn(8);
TMSFMXGrid1.HideColumn(6);
TMSFMXGrid1.HideColumn(4);
TMSFMXGrid1.HideColumn(2);
TMSFMXGridExcelIO1.GridStartRow := 0;
TMSFMXGridExcelIO1.GridStartCol := 0;
TMSFMXGridExcelIO1.Grid := TMSFMXGrid1;
TMSFMXGridExcelIO1.Options.ExportHiddenColumns := True;
TMSFMXGridExcelIO1.XLSExport('c:\temp\test.xls');
end;