Want to change excel header cells names from a, B, C to 1, 2, 3

Question

2.00/5 (1 vote)

See more:

C#

Want to change Excel header cells names from A,B,C to 1,2,3 using R1C1 option but i want to do this using C# coding

What I have tried:

Want to change Excel header cells names from A,B,C to 1,2,3 using R1C1 option but i want to do this using C# coding

Posted 9-Jun-16 2:24am

yaseenp

Updated 9-Jun-16 4:44am

Add a Solution

Comments

ZurdoDev 9-Jun-16 8:29am

Record a macro doing it and then you'll see the code.

CHill60 9-Jun-16 8:37am

Very good advice from @RyanDev above. But I would like to point out that the "What I have tried:" section is for you to post the code you have tried. As things stand we have no idea how you are handling the excel spreadsheet in your code

Member 11710200 9-Jun-16 9:31am

Can you state few details ?
1. How are you interacting with the excel , are you creating or exporting it through code ?
2.Are you directly dealing with a excel file that is present in the system ?

2 solutions

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)

Tumtum21 · Answer 1 · 2016-06-09T04:05:00

Solution 1

why dont u use ClosedXml nuget package

ClosedXML - The easy way to OpenXML - Documentation

that should allow you too manipulate excel files etc and there is sample code with each feature

Posted 9-Jun-16 4:05am

Tumtum21

Updated 9-Jun-16 4:06am

v2

Richard MacCutchan · Answer 2 · 2016-06-09T04:44:00

Solution 2

Application.ReferenceStyle = xlR1C1

Posted 9-Jun-16 4:44am

Richard MacCutchan