Create and save data to an Excel file with C#.net

[Guest]

I am trying many ways to create and save data to an Excel file, but all I got
is the following error message. (The code behind is in C#.net)

System.UnauthorizedAccessException


Here is my codes:

71: // Start a new workbook in Excel.
72: m_objExcel = new Excel.Application();
73: m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
74: m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));

 

[Steve C. Orr [MVP, MCSD]]

This article demonstrates a number of techniques for generating Excel and
Word documents.
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

Here's a good 3rd party product you could use if you need to get really
fancy:
http://www.aspose.com/Products/Aspose.Word/
And here's another:
www.officewriter.com

 

[MDeLeon]

Creating Excel files without Office

If you're trying to make Excel files on the server (without installing Office) then give my API a try: ClosedXML.CodePlex.com

Right now it's fairly robust but I want to get more feedback to keep improving it.

 

[ketanerp]

Hi,

look at below url. there are give detail desscriptino about how to create and format excel file. May be it help you.

http://dotnet-magic.blogspot.com/2011/10/createformat-excel-file-from-cnet.html