How to export a XLS cell with string format on GridExcelIO?

[Romero_Parra_Alejandro]

Hello again

On the next picture I load some SQLite DB to a FNCGrid, after I export to an XLS file but on the red mark my data is string value and after export you change it to integer removing the first zero.... why?

[Pieter]

Set Options.ExportCellFormats to False, or use the OnExportColumnFormat event.

[Romero_Parra_Alejandro]

Thanks

I used your second recomendation and now it works, can you just take a look at the code below and tell me if that it is okey?

The image of my first post I want the entire column "ClaveSAT" be string value, does my code below is more than enough?

procedure TExportarCatalogoProductosF.ExportadorExcelExportColumnFormat(
Sender: TObject; GridCol, GridRow, XlsCol, XlsRow: Integer;
const Value: WideString; var ExportCellAsString: Boolean);
begin
// Validamos que la columna SAT sea STRING
If GridCol = 4 then ExportCellAsString := True;
end;

If so to mark this as problem solved

[Pieter]

looks good