We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exporting a grid to excel

Thread ID:

Created:

Updated:

Platform:

Replies:

42776 Apr 5,2006 06:58 PM UTC Jul 6,2006 06:27 PM UTC WinForms 6
loading
Tags: XlsIO
Pierre-Luc Boulet
Asked On April 5, 2006 06:58 PM UTC

hello! I would like to know if there is, somewhere in the ExcelRW library, a method that exports a grid to excel in the format that it is in the VB.NET program. The sample I have from you uses loops to affect the text value of the different cells, is there a way to affect the cells'' style as well? or do I have to code the affectation of the width, height, color, backcolor, etc.. Thanks for your help Pierre-Luc

Administrator [Syncfusion]
Replied On April 6, 2006 01:07 AM UTC

Hi Pierre, Please upgrade to the latest version which has a built in grid exporter ftp://syncpatch.syncfusion.com/EssentialStudio/4.1.0.63/syncfusionessentialstudiosetup.exe Sample : http://www.syncfusion.com/Support/user/uploads/ExportToExcelGC_5edd99e7.zip Please let me know if you have any questions. Best regards, Stephen. >hello! > >I would like to know if there is, somewhere in the ExcelRW library, a method that exports a grid to excel in the format that it is in the VB.NET program. > >The sample I have from you uses loops to affect the text value of the different cells, is there a way to affect the cells'' style as well? or do I have to code the affectation of the width, height, color, backcolor, etc.. > >Thanks for your help > >Pierre-Luc

Pierre-Luc Boulet
Replied On April 6, 2006 02:10 PM UTC

Hello ! That''s great news ! is there a compiled version of the sample? so I could show it to my boss, so he could decide to upgrade or not. Thanks Pierre-Luc

Administrator [Syncfusion]
Replied On April 6, 2006 08:57 PM UTC

Hi Pierre, Here is the compiled sample (Version 4.1.0.63) http://www.syncfusion.com/Support/user/uploads/ExportToExcelGC_d317f5cb.zip We are also making a lot of enhancements to the converter control for the upcoming 4.2 release. If you find any issues in the converter control(version 4.1.0.63), we will try our best to fix it before the 4.2 release. Best regards, Stephen. >Hello ! > >That''s great news ! > >is there a compiled version of the sample? so I could show it to my boss, so he could decide to upgrade or not. > >Thanks > >Pierre-Luc

ralph_lachance
Replied On June 28, 2006 10:17 PM UTC

Stephen, I''m having a little trouble understanding what is part of the future and what is part of the past in this terrain. For example, in the 4.1.0.62 help, there is this comment about ExelUtils. ExcelUtils is a helper class that is used for easy usage of direct XlsIO API in performing repetitive tasks.[The usage of this class is not recommended, Please refer to the documentation for updated sample code.] And I can''t find anything about GridExcelConverter Yet, it turns out I''m using both GEC and EUtils in the same hunk of code right now. (it exports multiple grids to a single xls.) Can you give us a roadmap on where things are going and what techniques we should and should not use? (Or should this go to the grid forum?)

Administrator [Syncfusion]
Replied On June 29, 2006 06:46 PM UTC

Hi Ralph, Our latest version 4.2.0.37 sample browser has some samples and information regarding Grid to Excel Converter.In 4.1.0.62.,there is only limited information available regarding this feature. The GridToExcel method should be used to export the grid to an excel sheet.Here is the code snippet using Grid to excel converter. Syncfusion.GridExcelConverter.GridExcelConverterControl gecc = new Syncfusion.GridExcelConverter.GridExcelConverterControl(); converter.GridToExcel(this.gridControl1.Model, saveFileDialog.FileName,GridExcelConverter.ConverterOptions.Default); And regarding the usage of ExcelUtils class,you can use this while you were using Grid to Excel Converter. Also please consider upgrading to our latest version 4.2.0.37 which has some features added. Please download our latest version through the following link. DownloadLink:http://www2.syncfusion.com/Installs/v4.2.0.37/SyncfusionEssentialStudioSetup.exe Note:This version requires a separate key to install. Please contact sales if you have not received a key. Please let me know if you any other queries. Thanks, Bharath.

Administrator [Syncfusion]
Replied On July 6, 2006 06:27 PM UTC

Hi Ralph, Sorry for the confusion regarding the usage of ExcelUtils class in our previous update. The ExcelUtils class was initially created as a wrapper class to simplify the API usage but we have faced some performance issues regarding its usage, hence the ExcelUtils class will be marked as obsolete soon.Please use the ExcelEngine class in your project. Thanks, Bharath.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;