Neeruu Posted April 27, 2014 Share Posted April 27, 2014 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 More sharing options...
Administrators Farshad Mohajeri Posted April 27, 2014 Administrators Share Posted April 27, 2014 If your component requires Excel to be installed in same machine it can be the problem. Link to comment Share on other sites More sharing options...
ZigZig Posted April 27, 2014 Share Posted April 27, 2014 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. Link to comment Share on other sites More sharing options...
Neeruu Posted April 27, 2014 Author Share Posted April 27, 2014 I have excel 2007 installed on the server ... In the same machine and isapi module vcl I test mode - apache Link to comment Share on other sites More sharing options...
Neeruu Posted April 27, 2014 Author Share Posted April 27, 2014 Could attach an example of export to excel enb apache. thanks Link to comment Share on other sites More sharing options...
FastCards Posted April 28, 2014 Share Posted April 28, 2014 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 More sharing options...
Neeruu Posted April 28, 2014 Author Share Posted April 28, 2014 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 More sharing options...
Administrators Farshad Mohajeri Posted April 29, 2014 Administrators Share Posted April 29, 2014 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 More sharing options...
Neeruu Posted April 30, 2014 Author Share Posted April 30, 2014 If I have excel 2007 installed on PC Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now