Export to excel in C#

Question

5.00/5 (1 vote)

See more:

Hi I am exporting a datagrid view to excel. Is there any way to make right align for a column. I a working in C# windows application

Posted 29-Nov-11 17:09pm

sumana shabeeb

Add a Solution

Comments

Westlmorland 21-Mar-17 8:02am

You could use this C# code to export to Excel after which you could apply the desired styling to ExcelColumnRowBase.Style property.
But instead of that you could use a direct method, DataGridViewConverter.ImportFromDataGridView, which is provided by this c# library for Excel, you can find an example of how to do that here.

2 solutions

Solution 1

You will need to the Office Interop to open Excel and adjust the properties of the cells

Posted 29-Nov-11 17:19pm

Not Active

Comments

sumana shabeeb 30-Nov-11 0:40am

i am using Interop . the number columns are aligned as right automatically but i need to arrange some text column also right allign

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Amir Mahfoozi · Accepted Answer · 2011-11-29T21:59:00

Solution 2

For example if you want to set the alignment of the second column, here is the code :

C#

var eApp = new Excel.Application { DisplayAlerts = false };
eApp.Workbooks.Open(@"c:\target.xlsx");
eApp.Visible = true;
Worksheet ws = eApp.ActiveSheet;
ws.Columns[2].HorizontalAlignment = XlHAlign.xlHAlignRight;

Hope it helps.

Posted 29-Nov-11 21:59pm

Amir Mahfoozi

Comments

Dalek Dave 30-Nov-11 4:01am

Beat me to it! :)
Have a 5.

Amir Mahfoozi 30-Nov-11 4:33am

Thank you very much Dalek :)