0

I remember that i have seen a project that is generating excel file but it was template based. I mean it was using an excel file that is already have a structure as template.

Do you know such a library for .net ?

Improve this question
3
  • This question doesn't have enough information to be answered. Generally speaking, it is not a problem of the library you are using but of the type of data export you are doing and how you want to interpret the data in the excel template. Commented Oct 10, 2012 at 12:28
  • 1
    It's not very hard to write one from scratch - you just need an existing Excel file that provides the template and then you need to fill it with data. Commented Oct 10, 2012 at 12:31
  • 1
    See EPPlus - How to use a template Commented Oct 10, 2012 at 12:38

2 Answers 2

Reset to default
1

You can easily read an existing excel file, modify it and write the modified version to the same file or a new one using libs like NPOI or EPPlus. We have used both with great success.

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

2 Comments

Or just do this using the interop
Which would require Microsoft Office (with the correct version) being installed on the machine.
0

Take a look at PowerTools for Open XML , Creating Pivot table in excel or you can create the excel file and reflect it using Open xml productivity tool then use the generated code to create the file using Open XML SDK The Open XML SDK Productivity Tool

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.