RE: Driving Excel from a DataSet
- From: v-kevy@xxxxxxxxxxxxxxxxxxxx (Kevin Yu [MSFT])
- Date: Sat, 18 Jun 2005 01:36:17 GMT
Hi Steve,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to export data in a DataSet
into an Excel file. If there is any misunderstanding, please feel free to
let me know.
As you said, we can export the data to an .csv file. Similarly, I suggest
the following steps:
1. Create a new text file and name it as filename.xls.
2. Go through each row and column in the DataSet table you need to export
and write the data as comma seperated format.
When you open the file, Excel will convert it to a spread***
automatically.
HTH.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
.
- Follow-Ups:
- Re: Driving Excel from a DataSet
- From: shriop
- Re: Driving Excel from a DataSet
- References:
- Driving Excel from a DataSet
- From: Steve Wolfie
- Driving Excel from a DataSet
- Prev by Date: Re: row height in datagrid
- Next by Date: Re: Driving Excel from a DataSet
- Previous by thread: Driving Excel from a DataSet
- Next by thread: Re: Driving Excel from a DataSet
- Index(es):