[IrishCoder]

Hey guys,

As the topic title would dictate im pretty much looking for a way to insert from my C# web application form values that it has pulled from my database and dump these values into an Excel template i have. What would be the correct way of going about doing this?

Thanks alot.

[Skydiver]

I can tell you right off the bat that the incorrect way to do it is to using Office Automation. See http://support.microsoft.com/kb/257757

The good thing, though, is that the KB article also suggests some alternatives to using Office Automation, and it links to the appropriate SDKs and walkthroughs.

I've been getting the impression that people on this forum having been having some successes using LibXL: http://www.libxl.com/

[AdamSpeight2008]

LINQ to Excel

[Skydiver]

AdamSpeight2008, on 10 July 2012 - 11:00 AM, said:

LINQ to Excel

Oh, that looks nice!

Scanning the source code, it looks like it uses an OLEDB connection to get to the data in the spreadsheet.

This post has been edited by Skydiver: 10 July 2012 - 11:22 AM

[AdamSpeight2008]

I don't know if is it Read-Write or just Read.

[Alex Heig]

Hi,
You might want to look at this C# Excel Writer. It isn't free, but it's much faster than Microsoft Office Automation and easy to use. Look at this example:

http://eleriumsoft.c...l_Template.aspx

[Bees02]

Hello,

Firstly, I want to know if your Excel template has some place holders for data to offer a location for data to be exported. If so, I think solution in this article: C# - Create Excel Report (Chart Contained) With Mark Designer will give you some suggestions.

Hope Helpful!