Intraweb with Flexcel

[matija]

Use TMS Software for export data to Excel!

In Intraweb 15.5.2. work export in 15.5.3. not work?

I check here!

[Alexandre Machado]

I never used Flexcel myself.

"not working" is not enough to say what's happening. How you export it? What does it happen?

Can you create a simple test case showing how you do it and what happens?

[joelcc]

I have not tried this in the latest version of IW but here is the flexcell routine that works for us.


procedure fxExportToExcel(ADataSet: TDataSet; const AFileName, ABreakFieldName: string;
AOpenFileInExcel: Boolean = True);
var
lXls: TXlsFile;
begin
//this must be called to run Flexcel in a dll
FlexCelDllInit;
lXls := TXlsFile.Create(True);
try
fxPrepareExcelData( ADataSet, lXls, ABreakFieldName );

// Save to File
lXls.Save( AFileName );

{ Open File in Excel }
if AOpenFileInExcel then
ShellExecute(0, 'open', PCHAR(AFileName), nil, nil, SW_SHOWNORMAL);

ADataSet.First;

finally
lXls.Free;
//this must be called to run Flexcel in a dll
FlexCelDllShutdown;
ADataSet.EnableControls;
end;
end;