Excel problem in C# format

Question

1.00/5 (1 vote)

See more:

hello!

Can excel be formated in c#? And if i can, how do i proced?

What I have tried:

Nothing, i need to understand first if it's possibile

Posted 14-Jan-19 11:57am

Member 14117959

Updated 14-Jan-19 20:42pm

Add a Solution

Comments

Richard Deeming 18-Jan-19 11:53am

NB: If you're writing a website, a Windows service, or anything else that runs in the background instead of in an interactive session, then you can't use Office Interop:

Considerations for server-side Automation of Office[^]
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

In this case, you would need to use an alternative library - for example:
* EPPlus[^];
* ClosedXML[^];
* The OpenXML SDK[^];

4 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)

Kevin Marois · Answer 1 · 2019-01-14T12:09:00

Solution 1

Google Microsoft Office Interop in C# or Excel Automation in C#

Posted 14-Jan-19 12:09pm

Kevin Marois

Patrice T · Answer 2 · 2019-01-14T12:26:00

Quote:
Can excel be formated in c#?

Yes it can.

Quote:
And if i can, how do i proced?

If you can do it with Excel and mouse/keyboard, Excel can tell you how to convert to code.
- Open XL, get ready to do stuff.
- Start to record a macro
with xl2003, Menu > Tools > Macro > New Macro
with ribbon use Dev Ribbon
- Do your stuff
- Stop macro recording
- Open VBE (Visual Basic Editor)
- The code of macro is how your stuff translate to code.
Even if code need tuning, VBA is close to what you need for C#.
A little search on internet will give missing information.

James Walsh Jr · Answer 3 · 2019-01-14T13:04:00

Here is a simple example. There is a ton of information on MSDN around C# and the Interop libraries.

C#

Microsoft.Office.Tools.Excel.NamedRange myRange =
this.Controls.AddNamedRange(this.Range["A1", "A5"], "myRange");

myRange.NoteText("This is a Formatting test", missing, missing);
myRange.Value2 = "Text I want to Format";
myRange.Font.Name = "Arial";
myRange.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
myRange.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

Maciej Los · Answer 4 · 2019-01-14T20:42:00

Solution 4

Yes, a range (cells) in Excel can be formatted. See:
How to: Programmatically apply styles to ranges in workbooks - Visual Studio | Microsoft Docs[^]
How to: Programmatically apply color to Excel ranges - Visual Studio | Microsoft Docs[^]

Posted 14-Jan-19 20:42pm

Maciej Los

Excel problem in C# format

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0