Groups | Blog | Home
all groups > dotnet web services > june 2007 >

dotnet web services : Create Excel without installing MS office


Priya
6/13/2007 12:47:01 PM
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
ronscottlangham NO[at]SPAM yahoo.com
6/13/2007 2:12:02 PM
[quoted text, click to view]


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
6/13/2007 11:58:35 PM
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

[quoted text, click to view]
Eric Schoonover
6/14/2007 2:33:26 AM
Also saw this link today on Larkware:
http://spreadsheetgear.com/


[quoted text, click to view]
Braulio Diez
6/20/2007 6:42:01 AM
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
/// ------------------------------




[quoted text, click to view]
AddThis Social Bookmark Button