Jump to content

Export to Excel - Apache


Neeruu
 Share

Recommended Posts

Hello everyone ... 
 
I have an app that exports a table to excel ... when I run in vcl mode works perfectly ... but when I export as apache module does not export .... 
 
I'm using the export component TscExcelExport,
 
Someone could help me ... 
 
Thank you.

 

Link to comment
Share on other sites

I confirm that TscExcelExport requires Excel to be installed :

"Microsoft Excel dient dan ook op de PC geïnstalleerd te zijn" ("Microsoft Excel needs also to be installed on the PC")

see : http://www.scip.be/index.php?Page=ComponentsExcelExport.

 

If you don't want to install Excel on your server, I recommand TMS Flexcel.

 

Best regards.

 

+1 for FlexCel. No need for Excel installation, works great with xlsx and xls.

Link to comment
Share on other sites

     try
        scExcelExport1.LoadDefaultProperties;        
        scExcelExport1.ExcelVisible       := False;
        scExcelExport1.ConnectTo          := ctNewExcel;
        scExcelExport1.StyleColumnWidth   := cwAutoFit; //cwFieldDisplayWidth;
        scExcelExport1.WorksheetName      := 'NameSheet';
        scExcelExport1.DataPipe           := dpDataSet;
        scExcelExport1.Dataset            := UniDataMain.UniQry;
        scExcelExport1.SummarySelection   := ssGiven;
        scExcelExport1.SummaryFields.Clear;
        scExcelExport1.SummaryCalculation := scSUM;
        scExcelExport1.ExportDataset;

        scExcelExport1.SaveAs(UniServerModule.LocalCacheURL+'MyExcel.xls',ffXLS);

      finally
        scExcelExport1.Disconnect(True);
        UniSession.SendFile(UniServerModule.LocalCacheURL+'MyExcel.xls');       
      end; 
 

Code I use to export to excel ... 

 

Mode vcl = export 

Apache Module Isapi = No Export

 

Please Help....

Link to comment
Share on other sites

  • Administrators
     try
        scExcelExport1.LoadDefaultProperties;        
        scExcelExport1.ExcelVisible       := False;
        scExcelExport1.ConnectTo          := ctNewExcel;
        scExcelExport1.StyleColumnWidth   := cwAutoFit; //cwFieldDisplayWidth;
        scExcelExport1.WorksheetName      := 'NameSheet';
        scExcelExport1.DataPipe           := dpDataSet;
        scExcelExport1.Dataset            := UniDataMain.UniQry;
        scExcelExport1.SummarySelection   := ssGiven;
        scExcelExport1.SummaryFields.Clear;
        scExcelExport1.SummaryCalculation := scSUM;
        scExcelExport1.ExportDataset;

        scExcelExport1.SaveAs(UniServerModule.LocalCacheURL+'MyExcel.xls',ffXLS);

      finally
        scExcelExport1.Disconnect(True);
        UniSession.SendFile(UniServerModule.LocalCacheURL+'MyExcel.xls');       
      end; 
 

Code I use to export to excel ... 

 

Mode vcl = export 

Apache Module Isapi = No Export

 

Please Help....

 

 

Do you have excel installed on same PC?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...