Question
3
Replies
58
Views
Syntel Ltd
Posted: March 12, 2020
Last activity: March 17, 2020
Export data from excel sheet to existing table in database using openspan.
My requirement is to fetch data from db initially, do processing on it and store it in an excel sheet. This is done.
Finally, I have to push all data from this excel back into the DB. Could you please explain with detailed steps or with an example?
There are two main methods for getting data out of Excel; GetCellValue and ExportData.
GetCellValue gets a single cell's value
ExportData creates a DataTable representing the range of cells specified.
Your insert query into your database would dictate which method you'd need to use depending on how it accepts the data to be inserted. An example would be difficult to provide since it would also require setup of a corresponding database.