Excel Automation
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
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
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
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
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
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
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
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
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
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
