Is there an easy wat to create an *.xls file on the c:\Drive from a dataset

[robmays]

I want to create the file so as i can send it as an email attachment?

[minhpc_bk]

Hi there, Basically, the excel file can be saved as the xml spreadsheet,so IMO you can provide a simple xsl template and use the XslTransform to transform data saved in the dataset and produce the excel file. You can download the xml schema of the Excel from here[^].

[robmays]

the download is not available do you have the full address

[minhpc_bk]

robmays wrote:

the download is not available do you have the full address

http://www.microsoft.com/downloads/details.aspx?FamilyId=FE118952-3547-420A-A412-00A2662442D9&displaylang=en I've just tried and it is working.

[robmays]

we are not on office 2003 yet and it seems a lot of work to get an excel file all i am after is to take the rows in a datagrid and email to a receipient

[minhpc_bk]

OK, you can use the html format, more exactly the table html element, to save the rows. You can export the entire datagrid to an excel file, clikety[^], or you can take some data and save it in the html format using the table tag with the .xls extension.