Microsoft Excel

A newer version of the Microsoft Excel Book is available via the BDK.

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

Learning the Excel Book

In order to work with Excel, you must first learn the Excel book. To do so:

1. In the left sidebar, click on Books.

2. In the search bar, search for Excel.

3. Click on + Book. A pop-up window will appear asking to Add New Book. Click Add.

Once the book has been learned, you can start using Excel in Kognitos.

---

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