The bot can be used to interrogate a linked Excel spreadsheet available on your OneDrive.
Note: The example used here is based on a Sales Demo spreadsheet that should sit in the root directory of your OneDrive. Logic to link to any spreadsheet on the fly is in the process of being rolled out. The Sales Demo spreadsheet used here as a few cells that are named for each month of the year, as well as a total, and an overview chart.
When linked to a spreadsheet, the bot can provide the values of requested cells. As mentioned in the note above, the sheet used here has cells named according to each month of the year. Below is an example of how to return a particular cell's value:
- Sales for May (any month of the year can be used, as well as the Total)
Show chart screenshot
When a spreadsheet contains a chart, the bot can be used to return a screenshot of the chart in its current state. This can be done as follows:
- Show chart (this sheet only contains one chart; when more than one chart is available, the name of said chart should be referenced)
The below video gives an overview of the Excel functionality currently available in the bot.