This option enables you to manually add, edit, and delete data in your XLReporting data sets in a spreadsheet-like manner:
While editing, you can choose from a number of features for ease of use:
You can edit any column in any row. Certain columns may feature a dropdown that show a list of values or a calendar. To insert, delete, copy, or move rows, you can either right-click on a row, or click on the ☰ button in the last column of a row:
Click on the Save button if you want to save your changes. If the data has been succesfully validated, it will be imported into the XLReporting database. If there are any validation issues, XLReporting will report these on the page. No data will be imported. After you have resolved these issues, you can click Save again.
When editing data, you can use the Save and Actions buttons in the right-top of the screen:
These buttons enable you to do the following:
Click on Actions - Import from file to import data from a file. This will replace all existing data.
After you have selected your import file, you will see a data preview:
If you selected an Excel workbook, you will be able to select which sheet within that workbook you want to import. You can also indicate at which row the data starts (enabling you to ignore empty or title rows in files) and whether your file contains column headers.
The header names in your import file must correspond to the column names in the data set.
Once you have reviewed the data, click on Apply and the data will be imported if all column headers match. If they don't, XLReporting will tell you which columns are missing in your import file.
Click on Actions - Review this data to review a number of aspects of this data set: