Generating an Excel File without using Interops

[Kuldeep]

Framework: Visual Studio 2005
Technology: ASP.NET 2.0
Language: C#.NET 2.0

Hi All,

How can we generate an Excel File through C#.NET without using Interops or
XML ?
Any leads on this would be highly appreciated.

Regards,
Kuldeep

 

[Nicholas Paldino [.NET/C# MVP]]

Kuldeep,

It sounds like you want to create excel workbooks for versions of excel
prior to 2007 (even though the version before 2007 could handle XML, it
sounds like you don't want that either). If you are not going to use XML or
interop, then you have to use a third party component to generate the file
(you should be able to google for some). The format of those files is not
in the public domain, so you are more than likely going to have to pay for
it as well.

 

[Samuel R. Neff]

ActiveReports from DataDynamics includes an excel writer which we use
to generate Excel files. We were already using their reporting engine
so there was no cost, so I can't say whether buying ActiveReports just
for the excel writer is worthwhile, but it is an option.

http://www.datadynamics.com

While we're not at all happy with DataDynamics in general, we've found
the excel writer pretty easy to use and the API was straightforward.

Sam

 

[Mark Rae [MVP]]

Framework: Visual Studio 2005
Technology: ASP.NET 2.0
Language: C#.NET 2.0

Hi All,

How can we generate an Excel File through C#.NET without using Interops or
XML ?

There really is only one guaranteed way:
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Guest]

Framework: Visual Studio 2005
Technology: ASP.NET 2.0
Language: C#.NET 2.0

Hi All,

How can we generate an Excel File through C#.NET without using Interops or
XML ?
Any leads on this would be highly appreciated.

Regards,
Kuldeep

 

[Guest]

sorry for double post
The simplest solution may work for you. If you separate values with commas
and lines with a newline, a file with extension xls will open and display
correctly in Excel.
For example, if you were to write
header1, header2, header3
val1, val2, val3
into a simple text file with extension xls, you would have a usable Excel
file.

 

[Alvin Bruney [MVP]]

FYI: With that approach you will lose formatting capabilities that are
otherwise available using other approaches. If that is not a major concern
then it is a suitable solution.