Question
3
Replies
74
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?
Posted: 1 year ago
you should include your logic and also insert query of the db in forLoop. You can use getCellvalue to read the data from Excel sheet
Posted: 1 year ago
Updated: 1 year ago
Hi AniruddhaS2132,
Could you share the screenshot of the automation window and also db config settings screenshot?. because i not able to find any tutorial to retrieve data from db and storing in excel. would be greatfull if you share the detailed steps with screenshots. Thanks in advance.
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.