Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

How Can I Transform a SQL Result to Spreadsheet

Hello everyone!


I would like to transform my variable result %QueryResult% in a Spreadsheet.


Can you help me please?


Regards


Best Answer

Hello Daniele,


To transfer the results of a SQL query, all you need to do is to use the "Write to Excel Worksheet" action and set the %QueryResult% variable to the "Value to Write:" field. The results will be written into separate columns starting from the Column-Row specified from the action's properties window.

1 Comment

ADMIN
Answer

Hello Daniele,


To transfer the results of a SQL query, all you need to do is to use the "Write to Excel Worksheet" action and set the %QueryResult% variable to the "Value to Write:" field. The results will be written into separate columns starting from the Column-Row specified from the action's properties window.

Login or Signup to post a comment