Support Portal

for ProcessRobot and WinAutomation

Excel Automation

Excel to PDF Conversion using VBScript
An Excel file can be converted to a PDF, using the "Run VBScript" Action. The code that should be implemented in the Action is the following: ...
Tue, 18 Sep, 2018 at 3:41 PM
AutoFit Excel columns using VBScript
The following VBScipt code opens the Excel file ("%ExcelFile%") and AutoFits the defined columns of the specified worksheet ("Sheet1") ...
Thu, 30 Aug, 2018 at 5:24 PM
Excel Automation using Keystrokes
Shortcut KeyActionDescriptionCtrl+ASelect AllNoneCtrl+BBoldFormat, Cells, Font, Font Style, BoldCtrl+CCopyEdit, CopyCtrl+DFill DownEdit, Fill, DownCtrl+FFind...
Thu, 23 May, 2019 at 6:04 PM
Open a password-protected Excel using VBScript
The following VBScript code can be used inside a "Run VBScript" Action, in order to open a password-protected Excel document. Set xl = CreateO...
Mon, 3 Sep, 2018 at 12:47 PM
Excel Sorting
An Excel worksheet can be sorted in ascending or descending order, using VBScript. Copy the below to a "Run VBScript" Action and replace the %...
Thu, 4 Oct, 2018 at 9:59 AM
How to interact with Google Sheets (workaround)
A google sheet can be handled by using the Google Drive File Stream app. With Drive File Stream, you stream your Drive files directly from the cloud to ...
Wed, 24 Jun, 2020 at 3:51 PM
Execute SQL queries to Microsoft Excel
Excel files consists of one or more Worksheets. A Worksheet can be treated as an SQL Table. Requirements Verify that any one of the below drivers are in...
Fri, 16 Aug, 2019 at 4:55 PM
Read contents of a big Excel Spreadsheet and/or locate the desired cells using SQL
Assuming that you have a huge Excel spreadsheet which contains 1000 or more rows and columns. The 'Read from Excel Worksheet' Action should take s...
Fri, 7 Dec, 2018 at 11:03 PM
Retrieve Excel data with SQL except for a specific row
SQL queries can be executed to Microsoft Excel. Check this article for more information. However, the delete query is not supported in Excel. The reason...
Fri, 3 May, 2019 at 1:47 PM
SQL Connection to password-protected Excel files
An SQL Connection to a password-protected Excel file is not feasible. However, we can automate a procedure that creates a new Excel file that is identic...
Fri, 17 May, 2019 at 2:37 PM