Create and populate Excel file in c# code behind

Question

Can anyone direct me to a place where I can learn a little bit about creating a .xslx file in code behind then populating it. I would need to create new worksheets as well.

I would be using a text box and parsing the data therein to populate the excel spreadsheet.

Thanks in advance.

Community · Accepted Answer · 2017-05-23 11:47:48Z

1

Check out the Open XML SDK 2.0 for Microsoft Office. It provides a slightly higher level API than simply the formidable Open XML specification. Download both packages - the tools are useful for experimenting.

Here are some links that should get you started using this SDK:

The question OpenXML SDK Spreadsheet starter kits also has some great links.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Dec 9, 2010 at 5:10

ProfK

51.4k127 gold badges419 silver badges808 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt · Accepted Answer · 2010-12-09 09:59:14Z

0

I used a few SDK's when I had to do it, and unfortunately many of them worked but had issues with some security when you open it in Excel again.

I eventually settled for good old COM interop with Excel.

This Interop Arcticle will help you get started.

I just created a nice ExcelHelper class to hide all the ugly COM syntax and handle the memory for me.

answered Dec 9, 2010 at 9:59

Matt

7722 gold badges5 silver badges14 bronze badges

Collectives™ on Stack Overflow

Create and populate Excel file in c# code behind

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related