API Reference All functions are asynchronous and return Promises. getExcelRowCount(filePath: string, sheetName?: string): Promise<number> filePath (string):The absolute or relative path to the Excel ...

Still using Excel for your data analysis? Learn how to leverage Python so you can work with larger datasets and automate repetitive tasks.

How to Use Excel Database Functions for Advanced Data Key Functions That Power the Solution Several dynamic array functions are integral to building a robust formula for filling blank cells.