Authoring sheets
Document Authoring provides the ability to work with structured data using spreadsheets.
Tips
Document Authoring sheets provide a way to work with spreadsheets. Here are a few tips to help get you started.
- All sheet tabs are public by default. Because DA sheets are targeted towards public web content and not line of business applications, all sheets are public by default. If you would like a sheet to be private, you can prefix the sheet with
private-
. - DA sheets are not designed to replace all Excel use cases. At the time of this writing, DA sheets do not have feature parity with Excel and Google Sheets. If you require conditional formatting, formulas, or you have 10,000+ rows, we recommend you keep this content in SharePoint / Google Drive and use AEM's content overlay feature.
- Previewing a sheet saves the sheet. - Unlike DA docs, you need to manually preview and save your sheet.
Basics
Below you will find details about basic editing. If you have made spreadsheets in other applications like Excel or Google Sheets, Document Authoring (DA) should feel familiar and intuitive.
Edit sheet details
You can use the edit sheet button to edit the sheet name or delete the sheet completely.
Editing rows, columns, cells, and more
Right clicking into a cell can help you work with your content. You can add rows and columns, delete them, or even export your sheet as a CSV.