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.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Kuldeep" <ku****************@hotmail.comwrote in message
news:ec**************@TK2MSFTNGP03.phx.gbl...

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

[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

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.

On Thu, 9 Aug 2007 22:19:20 +0530, "Kuldeep"
<ku****************@hotmail.comwrote:

>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

[Mark Rae [MVP]]

"Kuldeep" <ku****************@hotmail.comwrote in message
news:ec**************@TK2MSFTNGP03.phx.gbl...

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/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?THVjYXMgSGVuZWtz?=]

"Kuldeep" wrote:

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

[=?Utf-8?B?THVjYXMgSGVuZWtz?=]

sorry for double post :P
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.

"Lucas Heneks" wrote:

>

"Kuldeep" wrote:

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

[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.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley
"Lucas Heneks" <Lu*********@discussions.microsoft.comwrote in message
news:46**********************************@microsof t.com...

sorry for double post :P
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.

"Lucas Heneks" wrote:

>>

"Kuldeep" wrote:

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