dataset export to excel file [modified]
-
Hello, I am working on a small project with datagrids and datasets, I want to give the user an option of saving this datasets data to xls file (the data is very small not big data which excel can take it) . I tried using different ways still not able to do it. Kindly suggest me or any idea How to convert or export this excel format. Thanking you in advance. -- modified at 21:30 Monday 17th July, 2006
-
Hello, I am working on a small project with datagrids and datasets, I want to give the user an option of saving this datasets data to xls file (the data is very small not big data which excel can take it) . I tried using different ways still not able to do it. Kindly suggest me or any idea How to convert or export this excel format. Thanking you in advance. -- modified at 21:30 Monday 17th July, 2006
I have used the Infragistic .NET Advantage suite in the past which has a control to output data in their Grid control to an Excel file. If you are using Excel 2003, you could just save the DataSet to an XML file, which Excel will happily read. Another way, write your data to a text file usign html tags for formatting and save the file as a .xls file. The advantage here is that you can incorporate forumla into your cells. For Example
**Product** **Price** Baked Beans 1.20 Musty Peas 0.79 **Total** **=SUM(B1:B2)** Steve Jowett -
I have used the Infragistic .NET Advantage suite in the past which has a control to output data in their Grid control to an Excel file. If you are using Excel 2003, you could just save the DataSet to an XML file, which Excel will happily read. Another way, write your data to a text file usign html tags for formatting and save the file as a .xls file. The advantage here is that you can incorporate forumla into your cells. For Example
**Product** **Price** Baked Beans 1.20 Musty Peas 0.79 **Total** **=SUM(B1:B2)** Steve Jowettthanks alot for the help, Can you kindly give an idea how to write to xml file, and if I am writing with HTML, do I have to write the details too as I am using in one computer ms office 2000 and other computer 2003. Sorry for my ignorance I really don't have any idea about it, if you can give me an idea I can learn more about it and will just use it accordingly. Thanking you again