Search the Community
Showing results for tags 'excel'.
Found 11 results
-
Hi, As the title says, I converted a library that Mike Heydon made to export a DataSet to old format Excel file (xls) without OLE or Excel installed. This library now converts an UniDBGrid to Excel. Sample of usage. // Add uses UExportExcel procedure TMainForm.UniButton1Click(Sender: TObject); var url, filename, reportname : String; exportExcel: TDataSetToExcel; i: integer; begin reportname := 'ExcelReport'; url := UniServerModule.LocalCacheURL+name+'.xls'; filename := UniServerModule.NewCacheFileUrl(false, 'xls', reportname, '', url); exportExcel := TDataSetToExcel. -
Hello, I have a question within my application that needs at some point I need to import information from an excel spreadsheet into the application. In desktop applications I use options that use COMobj and use the following code: Procedure ... Var excelSheet, Excel: Variant; Begin Excel: = CreateOleObject ('Excel.Application'); Excel.Visible: = false; Excel.WorkBooks.Open (FileSource.Text); ExcelSheet: = excel.Workbooks [1] .WorkSheets [1]; DData: = Excel.WorkBooks [1] .Sheets [1] .Cells [1,1]; End; When I use this function in uniGui it's messa
-
why i cant create excel file, this is the error i use fast report, here is my code procedure TRptModule.MyFrxexcel(frxReport: TfrxReport); begin frxReport.ShowProgress:=False; frxReport.PrintOptions.ShowDialog:=False; frxReport.EngineOptions.SilentMode:=True; frxXLSXExport1.SlaveExport:=False; frxXLSXExport1.SuppressPageHeadersFooters:=False; frxXLSXExport1.Wysiwyg:=True; frxXLSXExport1.FileName := UniServerModule.LocalCachePath +RptName; frxXLSXExport1.DefaultPath := ''; frxReport.PrepareReport(); frxReport.Export(frxXLSXExport1); // Export Report UniSession.SendFil
-
uses JvDBGridExport, DBGrids; // Activex; for Word/Excel var mygrid : TDBGrid; myexport : TJvDBGridCSVExport; // myexport : TJvDBGridExcelExport; // myexport : TJvDBGridWordExport; // myexport : TJvDBGridHTMLExport; begin mygrid := TDBGrid.Create(nil); mygrid.DataSource := unimainmodule.myexportdatasource; // CoInitialize(nil); // call only if export to Word/Excel myexport := TJvDBGridCSVExport.Create(nil); // myexport := TJvDBGridExcelExport.Create(nil); // myexport := TJvDBGridWordExport.Create(nil); // my
-
Hello friends I would like information if there is any way to export information in a query, grid or dataset to excel in unigui. I have a report generation screen that is viewed in Fast Report and the client wants to export to excel, but the native delphi options that work with error unit COMobj. If someone has an example I thank you very much Hello friends I would like information if there is any way to export information in a query, grid or dataset to excel in unigui. I have a report generation screen that is viewed in Fast Report and the client wants to export to excel, but the native delp
-
Hi Farshad! Can you include "SpreadSheet" in the framework??! http://www.extjs4spreadsheet.com/spread/10/examples/spread-full http://www.extjs4spreadsheet.com/en/introduction Thank you! Sincerely.
- 9 replies
-
- 1
-
-
- SpreadSheet
- DBGrid
- (and 1 more)
-
To all tortured soles that have to fulfill the Excel dependent customer demands, I found this on the net. To my amazement , it works ! http://blog.runbits.com/post/Native-Export-XLS-without-excel-Delphi.aspx Have fun !
-
Hi, I am using the following code to export data to excel. But this code is working in vcl and standalone server mode, does not work in isapi mode. I need the code to work in ISAPI mode. Do you have any idea for help me ? var Excel, wSheet: Variant; i,j:integer; s,Fl:string; Begin If Myq_Report.RecordCount>0 Then Begin try Excel:= CreateOleObject('Excel.Application'); except Exit; end; Excel.Visible := False; Excel.Workbooks.Add; wSheet:= Excel.WorkBooks[1].WorkSheets[1]; wSheet.Cells[2,1] := 'Company'; wSheet.Cells[
-
Hi, I am using the following code to export data to excel. But this code is working in vcl and standalone server mode, does not work in isapi mode. I need the code to work in ISAPI mode. Do you have any idea for help me ? var Excel, wSheet: Variant; i,j:integer; s,Fl:string; Begin If Myq_Report.RecordCount>0 Then Begin try Excel:= CreateOleObject('Excel.Application'); except Exit; end; Excel.Visible := False; Excel.Workbooks.Add; wSheet:= Excel.WorkBooks[1].WorkSheets[1]; wSheet.Cells[2,1] := 'Company'; wSheet.Cells[
-
Please Farshad! Give the solution ... Thank you!
-
Hi; I was successfully to export and download a datasource content using ZEXMLSS Download XML file and open with excel it works very nice for me. Used Component : ZEXMLSS and ZColorStringGrid from http://avemey.com/index.php?lang=en Turbo power tpabbrevia from http://sourceforge.net/projects/tpabbrevia/?source=dlp You must install a zip component and zcolorstring for exporting. I need some modification ZEXMLSS compatiblity for tpabbrevia manually during installation. Here is sample code which was tested via XE2 PS : sorry for big capital. I am always using big capital
