For your Microsoft Excel account, YAP supports reading and writing Excel data using Microsoft Office 365:
- Add row
- Update row
- Add row to table
- Create spreadsheet
- Find row
Before setup, check that you have granted to YAP the permission to send notification to your Microsoft Excel account. For this, sign in to Microsoft Excel and authorize the permissions requested by YAP.
- Importing customer details from a Microsoft Excel file to Tableau and analyzing the data.
- Using Microsoft Excel source objects as sources in synchronization tasks, mappings, and mapping tasks.