This reference documentation is for the Legacy Microsoft Excel book. Refer to the latest version here.
Overview
The Excel Book allows you to work with Excel files in Kognitos. This Book enables users to perform a wide variety of tasks on Excel workbooks and spreadsheets, including opening, converting, merging, and manipulating tables.
Prerequisites
Adding the Excel Book
To work with Excel, you must first add the Excel (Legacy) book to your agent. To do so:
Go to Books → All Books.
Search for Excel and click on it.
Click on Install.
Note: Working with .xls and .csv Files
The .xls and .csv Formats are not directly supported in the Excel Book.
To work with these files, you can use the following code to extract the data as a table. Once you've done this, you can perform table operations and convert to Excel for further Excel operations.
get the file as a table
get the above as the temp table
