By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,957 Members | 1,213 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,957 IT Pros & Developers. It's quick & easy.

Create Excel without installing MS office

P: n/a
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
Jun 13 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Jun 13, 2:47 pm, Priya <P...@discussions.microsoft.comwrote:
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.

Jun 13 '07 #2

P: n/a
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***@discussions.microsoft.comwrote in message
news:9A**********************************@microsof t.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
Jun 14 '07 #3

P: n/a
Also saw this link today on Larkware:
http://spreadsheetgear.com/
"Priya" <Pr***@discussions.microsoft.comwrote in message
news:9A**********************************@microsof t.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
Jun 14 '07 #4

P: n/a
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
Jun 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.