Hi All,
I wanted to know if there is anyway to extract multiple rows and columns using execute sql action.Further, I would want to export the results as an excel sheet.
Please help.
Userlevel 6
+22
Hi,
The Query SQL action allows you to select columns that you want to capture so you can have a collection variable for each column.
To update an excel sheet you would have to use the Document Generation action as the Query Excel action does not allow for updates.
The Query SQL action allows you to select columns that you want to capture so you can have a collection variable for each column.
To update an excel sheet you would have to use the Document Generation action as the Query Excel action does not allow for updates.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.