Question
Syntel Ltd
IN
Last activity: 17 Mar 2020 15:12 EDT
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?
Pegasystems Inc.
US
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.
Atos
IN
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
Updated: 17 Mar 2020 15:12 EDT
Maveric Systems
IN
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.