Programming Excel in C#

Question

0.00/5 (No votes)

See more:

I want to select all the data rows in Col F - Col I
and change the number format to have 2 decimal places.
The following code does not work. Can someone help me out?
The code compiles, but blows up with a COM exception(which I can't figure out)

C#

Excel.Range workSheet_range = sheet.get_Range("F", "I");
workSheet_range.NumberFormat = "0.00";

Posted 17-Jan-12 11:44am

Member 7969139

Updated 17-Jan-12 11:54am

Orcun Iyigun

v2

Add a Solution

Comments

Orcun Iyigun 17-Jan-12 17:54pm

Added tags.

1 solution

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)

**Orcun Iyigun** · Accepted Answer · 2012-01-17T12:04:00

Solution 1

I think you are having the exception in this line:

C#

Excel.Range workSheet_range = sheet.get_Range("F", "I");

Try changing your code to following it should work:

C#

using Excel;
using System.Reflection; // Needed for Missing.Value

C#

// Code to get to the point of selecting the range
Excel.Application excelApp = new Excel.ApplicationClass();
Excel.Workbook workbook = excelApp.Workbooks.Open("c:\yourexcelfile.xls", 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Worksheet worksheet = (Excel.Worksheet) workbook.Worksheets.get_Item("sheet1");
// Select a multi column range
Excel.Range dataRange =worksheet.get_Range("F:F,I:I", Missing.Value);

Also have a look at these two links:
Link 1[^]
Link 2[^]
It will help you solve your problem.

Good luck,
OI

Posted 17-Jan-12 12:04pm

Orcun Iyigun

Updated 17-Jan-12 12:10pm

v3

Comments

thatraja 17-Jan-12 22:41pm

Right, 5!
BTW I like your profile picture(Angry face) :)

Orcun Iyigun 18-Jan-12 12:02pm

Haha thanks. hi from Marvin the Martian :P

thatraja 22-Jan-12 10:26am

/*hi from Marvin the Martian*/
Then what is Orcun Iyigun?

Orcun Iyigun 23-Jan-12 11:53am

you know I have to keep a low profile since I am the Martian. thats how i hide my self. :)

thatraja 23-Jan-12 12:02pm

:D Right, be safe here

Member 7969139 18-Jan-12 15:02pm

I tried your suggestion and it worked partially.
this is the code I entered.
Excel.Range dataRange = sheet.get_Range("F:F,I:I", Type.Missing);
dataRange.NumberFormat = "0.00";

but it only updated Col "F" and "I" it didn't include col's "G" & "H".
Any ideas?

Orcun Iyigun 18-Jan-12 15:08pm

can you try Excel.Range dataRange = sheet.get_Range("F:F,G:G,H:H,I:I", Type.Missing); ?

Member 7969139 18-Jan-12 15:32pm

I'm running the test now. Where can I find the documentation for the sheet.get_Range function?

Orcun Iyigun 18-Jan-12 15:39pm

There you go!![^]

Member 7969139 18-Jan-12 17:15pm

Good news. Your fix work perfectly! Where can I find the documentation for the sheet.get_Range function?