Jump to content

Export to Excel - Apache


Neeruu

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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...