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...
Fri, 22 Jun, 2018 at 11:53 AM
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
Exception Handling - How to avoid the error "Failed to write into Excel an empty string"
In order to avoid that error message, the easiest workaround is to check whether the variable we are trying to write to the corresponding cell is empty or n...
Thu, 6 Sep, 2018 at 5:02 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
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...
Mon, 22 Oct, 2018 at 7:04 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...
Tue, 11 Dec, 2018 at 2:54 PM