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. Quote 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. Quote 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. Quote 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 Quote 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 Quote 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. Quote 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.... Quote 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? Quote 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.