Hi guys,
I am using FPSpreadsheet to write data from database to xlsx file.
After file written, file is opened via code.
The codes is something like this
procedure TFrm.btnExcelClick(Sender: TObject);
var
WB: TsWorkbook;
WS: TsWorksheet;
begin
try
WB := TsWorkbook.Create;
WS := WB.AddWorksheet('Sheet');
// do some processing
WB.WriteToFile('fl.xlsx',true);
OpenDocument('fl.xlsx');
finally
WB := free;
end;
end;
I am concern when WriteToFile command take sometime to finished written to file on a large database.
Is OpenDocument command will execute after file written finished or not?