| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Any quicker way to write data from DataTable to Excel?
Hello Group!
I have a DataTable as below and currently I am writing this to excel by looping through each column and then each row. I am wondering if there is a quicker way to dump all the data once or any time smart method to save data writing process. col1 col 2 col3 A B C D E F I am playing with VB.NET Thanks a lot! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Any quicker way to write data from DataTable to Excel?
does the dataTable come from a recordset? if so, you could use the Excel
Range's CopyFromRecordset method "musa.biralo" wrote in message ... Hello Group! I have a DataTable as below and currently I am writing this to excel by looping through each column and then each row. I am wondering if there is a quicker way to dump all the data once or any time smart method to save data writing process. col1 col 2 col3 A B C D E F I am playing with VB.NET Thanks a lot! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Any quicker way to write data from DataTable to Excel?
Thank You Patrick.
The DataTable is created from DataSet. Do you have any snippet or any web-link that I can follow? Thanks for your time. Musa.Biralo On Jun 18, 10:55*am, "Patrick Molloy" wrote: does the dataTable come from a recordset? if so, you could use the Excel Range's CopyFromRecordset method "musa.biralo" wrote in message ... Hello Group! I have a DataTable as below and currently I am writing this to excel by looping through each column and then each row. I am wondering if there is a quicker way to dump all the data once or any time smart method to save data writing process. col1 *col 2 col3 A * * * B * * * *C D * * * E * * * *F I am playing with VB.NET Thanks a lot! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Any quicker way to write data from DataTable to Excel?
alas no ... the last time i had to do this i iterated through the DataTable
(C#) However, you probably already have the sql, so you could maybe use a DataReader instead - I've found that to be quicker "musa.biralo" wrote in message ... Thank You Patrick. The DataTable is created from DataSet. Do you have any snippet or any web-link that I can follow? Thanks for your time. Musa.Biralo On Jun 18, 10:55 am, "Patrick Molloy" wrote: does the dataTable come from a recordset? if so, you could use the Excel Range's CopyFromRecordset method "musa.biralo" wrote in message ... Hello Group! I have a DataTable as below and currently I am writing this to excel by looping through each column and then each row. I am wondering if there is a quicker way to dump all the data once or any time smart method to save data writing process. col1 col 2 col3 A B C D E F I am playing with VB.NET Thanks a lot! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Block copy of Datatable to Excel Spreadsheet using C# | Excel Programming | |||
| How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net? | Excel Programming | |||
| Retrieving Data from Excel Pivot tables into Datatable | Excel Programming | |||
| Bind datatable to excel worksheet | Excel Programming | |||
| Excel into DataTable using OleDbDataAdapter | Excel Programming | |||
Linear Mode
