Working with Excel in BAS

Spreadsheets are where a lot of business data lives, so a bot that reads and writes Excel slots straight into real workflows. BAS ships with a built-in, powerful Excel module for exactly that.

What it’s for

The module gives you all the action blocks needed to build automation around Excel spreadsheets — reading input from them and writing results back. It’s comprehensive enough to be the data layer of a bot on its own.

What it can do

The module covers the full range of spreadsheet work:

• Files — create an Excel file, open and save.
• Cells — read and write a cell, count cells.
• Rows — read, write, insert and delete rows; count them.
• Sheets — read and write sheets, add, move, rename, delete and clear them, and get the sheet list.
• Ranges — read and write cell areas in bulk.
• Search and formulas — find by cell value and convert formulas.
• Import / export — import data, and export sheets to resources and back — the bridge between a spreadsheet and the data your bot runs on.

Where it fits

Excel is the friendly, human-readable end of a bot’s input and output. A common pattern: a client hands you an .xlsx of accounts or tasks; you export its sheet to a resource, run the bot across threads on that data, and write the results back into the spreadsheet they can open and read. Where lists hold data in memory and files handle plain text, Excel is the module for structured, business-facing spreadsheets — the format your clients already use.