Microsoft Excel (Legacy)
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
.xls
and .csv
FilesThe .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
Last updated
Was this helpful?