Appearance
Buttons (CSV / Print)
Ninja Tables offers you an amazing feature that is CSV Export / Print Button Settings for Frontend. You can enable/disable Print and CSV export settings according to your needs. Buttons (CSV / Print) is a Pro Feature!
CSV/Print Button in Ninja Tables
- Clicking the Table Configuration tab, you will find a new window appearing with the Buttons (CSV / Print) option on the sidebar.
- Click on the Buttons (CSV / Print), there a new tab will open with a CSV Export / Print Button Settings for Frontend area.
Now, let's talk about the details of the Settings area.
CSV Export Button Settings for Frontend
- To display the CSV Export button on the preview table, enable it.
- Some more options will show up after these button has been enabled.
- Button Label: It displays the text you want to appear on the button label, where you can add any text that meets your needs.
- Button Background Color: It reveals the button's background color.
- Button Text Color: It displays the button's text color.
- Export as Plain Text: Your button will export as plain text if you enable this.
Excel Export Button Settings for Frontend
- To let visitors download the table as an Excel file, turn on Enable Excel Export Button.
- Some more options will show up after the button has been enabled.
- Button Text: The text you want to appear on the button. The default is Excel.
- Button BG Color: The button's background color.
- Button Text Color: The button's text color.
When a visitor clicks the button, the table downloads as an .xlsx file named after the table. Things to know:
- The file contains the rows the visitor is currently viewing. For example, if the visitor has searched or filtered the table, only the matching rows are exported.
- Only the columns that are visible in the table are included.
- Cells are always exported as plain text, so HTML such as links or images is not carried into the file. Numbers stay numbers, and values such as codes with leading zeros stay as text.
- The Excel button works with both the FooTable and DataTables rendering engines.
- The setting only appears when you have a version of Ninja Tables Pro that supports the Excel button. Update Ninja Tables Pro if you do not see it.
Print Button Settings
- To display the Print button on the preview table, enable the Print Button Settings.
- Some options will show up after the Print button has been selected.
- Button Label: It displays the text you want to appear on the button label, where you can add any text that meets your needs.
- Button Background Color: It reveals the button's background color.
- Button Text Color: It displays the button's text color.
- Print Screen Header: If you choose Yes to include a header on each page in the Print Screen Header option and enter the header text in the HTML content box below, the header text of each page will be displayed once you press the Print button.
- Print Screen Footer: In the Print Screen Footer option, if you select Yes to the Footer on each page and enter the text for the footer in the HTML content section below, each page's footer will be displayed once you press the Print button.
Buttons Position
You can adjust the position of your button to suit your requirements. Your button can be placed in one of three places: After the search box, Before the table, or at the Bottom of the table.
Buttons Alignment
Your buttons' alignment can be changed as needed. The button alignment has three options: Left, Center, and Right. When you are done with the configuration, don't forget to click on the Update Settings button. Let's see the Preview Table after you complete the settings.
A CSV file will be downloaded when you click on the CSV button, an Excel file when you click on the Excel button, and several printing options will appear if you click the Print button. This is how you can quickly use and style your CSV, Excel, and Print buttons to match your needs.