ansaurus

Question

Answer 1

A:

You have still few solutions. 1) Third party component for excel files. ( i think this is most pain-les & reliable solution ) 2) Using html-table.

1) Simply look at internet :) 2) The excel works pretty fine with html-tables. If you generate this html:

<html><body>
<table>
<tr><td><b>Column A</b></td><td><b>Column B</b></td></tr>
<tr><td><font color="red">-154</b></td><td><font size="5">hello world</font></td></tr>
</table>
</body></html>

the excel will show it as worksheet as you formated it. I think, this is most universal way, how to create "rich" excel worksheet in internet enviroment without having excel instaled on server.

TcKs 2008-11-15 13:53:38

Answer 2

+3 A:

Check out MyXls a .NET solution for reading and writing binary XLS files.

Todd 2008-11-15 14:08:42

Answer 3

A:

Have a look at Excel Web Access, which is part of Excel Services in MOSS, a server-side version of Excel that lets you calculate and display your Excel information through a Web browser. The MOSS overview page describes the sharepoint framework that can provide Excel functionality on the server. You can use the VSTO API to programmatically access spreadsheets.

gimel 2008-11-15 14:09:22

Answer 4

+1 A:

I've used Aspose.Cells for this sort of thing with good success. The documentation can be a little obtuse, but the product seems to work. It won't require you to have Excel on the server and it works with the latest versions of Excel (and previous versions).

tvanfosson 2008-11-15 14:09:23

Answer 5

A:

not sure if this is exactly what you need, but certainly could be: 4 Editing In Excel Tutorials (under .NET #5-8)

Kyle West 2008-11-15 15:05:25

Answer 6

+1 A:

The problem with using Excel as an ISAM database using any driver (ODBC, OLEDB., etc.) is the datatype of the column is based on the first 8 rows in the column - this is pure evil; for example: if a column is something like a part# and the first 8 parts happen to be only numeric then you get get NULL for any cell in that column where the part# isn't numeric. (110000 vs 111000-1 or 111000A). This is reguardless of how you format the column in excel (even if you set the column as text).

I'll try and find a doc on this and update. Here's one:

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

http://msdn.microsoft.com/en-us/library/bb177610.aspx

Booji Boy 2008-11-15 15:41:53

Answer 7

A:

You may want to take a look at http://www.gemboxsoftware.com/GBSpreadsheetFree.htm.

They have a free version with all features but limited to 150 rows per sheet and 5 sheets per workbook, if that falls within your needs, otherwise the paid version starts at $425 for a 1 Developer License.

There are additional answers that may apply to your question at StackOverflow: Create Excel (.XLS and .XLSX) file from C#.

ManiacZX 2008-11-15 16:25:53

Answer 8

+1 A:

In that situation, I would normally favour not messing with the complex spreadsheet, but setting up a separate data file, to which I would link the data cells in the complex spreadsheet. This is much cleaner and safer than changing a complex spreadsheet from outside.

If this is not easier than the alternatives you are currently facing,it would surprise me. But then I haven't seen your spreadsheet.

dbb 2008-11-15 21:54:12

ansaurus

tags:

views:

answers:

Modifying Excel spreadsheet with .NET

related questions