ansaurus

Question

Create an Excel workbook on a x64 system

Answer 1

+1 A:

Personally from an ASP.NET application standpoint I have found that using XML and XSLT to go into the Excel XML format is the most effective, and really trouble free way to go. There are no costs involved, and once you get the hang of it, it is really quick!

In addition to that, I'm personally strongly against any form of automation to accomplish that kind of task.

Mitchel Sellers 2008-10-22 17:32:57

Answer 2

A:

I agree with Mitchel Sellers. Another way is create a simple html document with table, the excel will quite accept.

Example:

<html><body>
<table>
<tr><td>First column</td><td>Second column</td></tr>
<tr><td>Value of first row in first column</td><td>Value of first row in second column</td></tr>
<tr><td>Value of second row in first column</td><td>Value of secondrow in second column</td></tr>
</table>
</body></html>

TcKs 2008-10-22 17:37:02

Answer 3

A:

Mike, do you have any example I can look at? Exporting to Excel isn't something I have had much call foor ( None really ), so any head start would be nice.

TcKs, I tried the Html route and didn't much care for the way excel complained about the file format of html not being the expected .xls(x) format. I'm exporting for Sales guys, so the less messages thay have to wade through, ( and as a result questions I have to anyswer ), the better.

2008-10-22 17:43:45

Answer 4

A:

The simplest way that worked well for me is to create the Excel file in the correct format with one row of data.

Then save the file in html format and use it as a template for the actual data.

There is some metadata included that will automatically start Excel when doubleclicking the generated html file.

I had to go this way because we use Excel 2002 and 2003 which have no open file format.

VVS 2008-10-22 17:47:02

Answer 5

A:

Have a look at: http://www.codeproject.com/KB/office/excelxmlspreadsheet.aspx

I think we modelled an inhouse solution from this.

dragonspeed 2008-10-22 22:31:48

ansaurus

tags:

views:

answers:

Create an Excel workbook on a x64 system

related questions