Excel Advanced Package Operations

 RPA | Excel Advanced Command Operations | Automation Anywhere - Part-16

Excel Advanced Command Operations | In this article, we will be discussing the various operations that can be performed on Excel using the Excel Advanced package. So in this article, we will cover various topics which includes how to access password protected worksheet, how to append workbook and worksheet, close an excel file, how to convert an excel file to pdf file and last but not the least how to create workbook and worksheet.

So we will cover each of the command in detail that is highlighted in the bold above.

1. Access Password protected worksheet - This command is used to unprotect a password protected worksheet. This action works with "xlsx, xls, xlsm and xlsb files".
2. Append Workbook - This command is used to append all worksheets from a specified workbook to the current workbook. The action works with the xlsx, xls, xlsm and xlsb files.
3. Append Worksheet - This command is used to append a worksheet from a specified workbook to the current workbook. This action works with the xlsx, xls, xlsm and xlsb files.
4. Close - This command is used to close an Excel spreadsheet which was opened during the Open command. This command works with the xlsx, xls, xlsm, xlsb and csv files.
5. Convert Excel to PDF - This command is used to convert an excel workbook or worksheet to a pdf file. This means that we can convert the entire excel file or we can convert the sheets present inside the excel file to a pdf file. This action also works with xlsx, xls, xlsm, xlsb and csv files.
6. Create Workbook - This command is used to create an excel workbook. This action works with xlsx, xls, xlsm and csv files.
7. Create Worksheet - This command is used to create an excel worksheet. This action works with xlsx, xls, xlsm and xlsb files.

Note - The notable difference between Append Workbook and Append Worksheet is that we can append as many sheets in the Append workbook into a single workbook but in Append Worksheet we can append or merge one sheet at a time from a specified workbook into the current workbook.

So now we will take a look at the code snippet for all the commands mentioned above.

So in this blog we discussed how we can access a password protected worksheet, how to append workbook and worksheet, how we can convert excel to pdf file and how we can create workbook and worksheet using the Excel Advanced Package.

If you have any queries then please feel free to reach out with your queries and I will be more than happy to answer your queries.