Export to Excel - Apache

[Neeruu]

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.

 

[Farshad Mohajeri]

If your component requires Excel to be installed in same machine it can be the problem.

[ZigZig]

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.

[Neeruu]

I have excel 2007 installed on the server ... 

In the same machine and isapi module vcl I test mode - apache

[Neeruu]

Could attach an example of export to excel enb apache. 

 

thanks

[FastCards]

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.

[Neeruu]

     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....

[Farshad Mohajeri]

     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?

[Neeruu]

If I have excel 2007 installed on PC