Question
3
Replies
47
Views
Syntel Ltd
Posted: 6 months ago
Last activity: 6 months 1 week ago
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: 6 months ago
Posted: 6 months 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: 6 months ago
Updated: 6 months 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.