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

export to excel - empty IRange.Text

Thread ID:





96497 Sep 16,2010 02:44 PM UTC Sep 28,2010 12:28 PM UTC WinForms 4
Tags: GridControl
Asked On September 16, 2010 02:44 PM UTC

i am trying to export a grid to excel using XlsIo

Everything works fine but i have a problem.

If IRange.Text is empty, no formatting is set, and the range appears at the first column/first row of the worksheet, then it is not exported.

so for example, if the workspace that i am exporting is set like this:

| | aaa | bbb |
| | ccc | ddd |

then it is exported as follows (the first column is not exported)

| aaa | bbb |
| ccc | ddd |

I think this is related to the flag

However, i am using SF version and this flag is not available.
Is there a way to export empty cells?

Nirmal Raja [Syncfusion]
Replied On September 20, 2010 12:02 PM UTC


Thank you for your interest in Syncfusion products.

I am unable to reproduce the mentioned issue on the GridControl which I deleted the first column cell values. You can use the default exporting method instead creating your own work sheet, where we have not made use of UsedRangeIncludesFormatting property with in our converter.

Please try the issue in the sample from our sample browser on following location:
{Installed Drive}:\Syncfusion\EssentialStudio\{Version Number}\Windows\Grid.Windows\Samples\2.0\Export\GC XLS Export Demo\

Let me know if you have any concern.


Replied On September 20, 2010 02:10 PM UTC

Hi Nirmal,
thanks for the help.
I forgot to mention that this happens only when exporting to CSV.

Unfortunately i cannot use the default exporting method due to business logic.

to export the sheet i use the following call:

sheet.SaveAs(filename, csvExporter.Delimiter, System.Text.Encoding.ASCII);

Please try to reproduce the problem exporting to csv, where the first column has no values and no formatting (and no header is exported)

Replied On September 23, 2010 10:47 AM UTC

Any updates on this issue?

Christopher Issac Sunder K [Syncfusion]
Replied On September 28, 2010 12:28 PM UTC


Thanks for the update.

The GridGroupingControl can be exported to the csv format of file, by copying the text to the buffer which copies with the delimiter so that it can be provided as a csv format.

Please refer the sample attached in the below location which illustrates the behavior:

Let me know if you have any queries.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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