<< Click to Display Table of Contents >> Navigation:  Forum > Intraweb with Flexcel

Forum link

 

 

 

---

 

12-20-2023, 11:54 AM:

 

Use TMS Software for export data to Excel!

 

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

 

I check here!

 

 

 

---

 

12-21-2023, 06:47 PM:

 

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?

 

 

 

---

 

12-22-2023, 02:23 PM:

 

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;