Create Excel without installing MS office

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

Hi,

I'm developing a webservice whicg reads data from a database and exports to
a excel sheet. This applciation works if i have MS Office installed in my
system . Since i'm unable to install MS Office in teh server is there any
alternate way to program this.

Thanks in advance
Priya

[ronscottlangham]

On Jun 13, 2:47 pm, Priya <P...@discussio ns.microsoft.co mwrote:

Hi,

I'm developing a webservice whicg reads data from a database and exports to
a excel sheet. This applciation works if i have MS Office installed in my
system . Since i'm unable to install MS Office in teh server is there any
alternate way to program this.

Thanks in advance
Priya

I assume you are using the automation libraries of Excel. I believe
in this case that it requires Excel to be installed.

You may need to consider using a third party library, I think there
are a number of them available.

[Eric Schoonover]

You should be able to create Excel files for consumption by at least the
2007 versions of Office by using the new OpenXML file formats.

Here is a CodePlex project that describes itself as "The convenient way to
create SpreadsheetML OOXML on the server"

http://www.codeplex.com/ExcelPackage

Thanks,
Eric

"Priya" <Pr***@discussi ons.microsoft.c omwrote in message
news:9A******** *************** ***********@mic rosoft.com...

Hi,

I'm developing a webservice whicg reads data from a database and exports
to
a excel sheet. This applciation works if i have MS Office installed in my
system . Since i'm unable to install MS Office in teh server is there any
alternate way to program this.

Thanks in advance
Priya

[Eric Schoonover]

Also saw this link today on Larkware:
http://spreadsheetgear.com/
"Priya" <Pr***@discussi ons.microsoft.c omwrote in message
news:9A******** *************** ***********@mic rosoft.com...

Hi,

I'm developing a webservice whicg reads data from a database and exports
to
a excel sheet. This applciation works if i have MS Office installed in my
system . Since i'm unable to install MS Office in teh server is there any
alternate way to program this.

Thanks in advance
Priya

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

You have several lite options:

- Use the XMLSS format, is compatible with Office 2002 or later, and there
is a trick to create an XSL to combine it with a dataset (XML). If you don't
have to include images, or macros, or charts, this options rocks !!!, here is
a link that explains step by step how to do it:

http://support.microsoft.com/kb/278976

- Return the info in CSV format.

- Return an HTML but in the mimetype say that is excel (I think excel 2002
or later just read the file and show it as Excel).

- Use a third partie tool or call via WebServices to Reporting Services.

/// ------------------------------
/// Braulio DÃ*ez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"Priya" wrote:

Hi,

I'm developing a webservice whicg reads data from a database and exports to
a excel sheet. This applciation works if i have MS Office installed in my
system . Since i'm unable to install MS Office in teh server is there any
alternate way to program this.

Thanks in advance
Priya