+- Atozed Forums (https://www.atozed.com/forums)
+-- Forum: Atozed Software (https://www.atozed.com/forums/forum-1.html)
+--- Forum: IntraWeb (https://www.atozed.com/forums/forum-3.html)
+---- Forum: English (https://www.atozed.com/forums/forum-16.html)
+----- Forum: IntraWeb General Discussion (https://www.atozed.com/forums/forum-4.html)
+----- Thread: Intraweb with Flexcel (/thread-3722.html)
Intraweb with Flexcel - matija - 12-20-2023
Use TMS Software for export data to Excel!
In Intraweb 15.5.2. work export in 15.5.3. not work?
I check here!
RE: Intraweb with Flexcel - Alexandre Machado - 12-21-2023
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?
RE: Intraweb with Flexcel - joelcc - 12-22-2023
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;