EDN Admin
Well-known member
<p align=left>I have a database extract in the form of a CSV file. On the other hand, I have an Excel template that this data needs to go into. Currently, the data is imported into the template manually. What were trying to do is automate this process. The sinze of the data is considerable. We have approximately 12000 records with 30 columns each. I considered the following options:
<p align=left>
<p align=left>1. Using Microsoft.Office.Interop.Excel, I tried to open up the template and then feed in the data from the CSV, row by row through a DataSet. This took up a lot of time and CPU cycles.
<p align=left>
<p align=left>2. Now Im trying to actually import the data into the template just the way our developer does it. Any leads on this with respect to how this can be done?
<p align=left>
<p align=left>Does anyone have any ideas on how else this can be done? It would be greatly helpful.
<p align=left>
<p align=left>Cheers,
<p align=left>Zorgus
View the full article
<p align=left>
<p align=left>1. Using Microsoft.Office.Interop.Excel, I tried to open up the template and then feed in the data from the CSV, row by row through a DataSet. This took up a lot of time and CPU cycles.
<p align=left>
<p align=left>2. Now Im trying to actually import the data into the template just the way our developer does it. Any leads on this with respect to how this can be done?
<p align=left>
<p align=left>Does anyone have any ideas on how else this can be done? It would be greatly helpful.
<p align=left>
<p align=left>Cheers,
<p align=left>Zorgus
View the full article