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