Contents
A common UI paradigm to use with interactive tables is to present buttons that will trigger some action – that may be to alter the table’s state, modify the data in the table, gather the data from the table or even to activate some external process.
When working with a complex DataTable it is not uncommon to wish to present options that the end user can activate to affect the table, or the data contained within the table in some manner.
Taking the inline styling out of the html seems to fix most problems. Then, just like @ArmanVirdi said, add the width and the height of the link to be 100%. The tags don’t seem to be doing anything, so those are removed in the below HTML, as well as an unclosed tag.
How to add buttons to a DataTable in Excel?
As part of the DataTables constructor, the buttons option can be given as an array of the buttons you wish to show – this is typically just the button name, although you can provide options to customise the button’s actions: $(‘#myTable’).DataTable( { buttons: [ ‘copy’, ‘excel’, ‘pdf’ ] } );
How are buttons used in a DataTable?
The Buttons library can be initialised and used in two different ways: It is important to note that multiple instances of Buttons can be created for use with a DataTable. This can be particularly useful if you want to present different sets of buttons to the end user – for example above and below the table.
For example, this might be activating a user account in a list of users, where you simply click an Activate button.
In this example, we make use of Buttons’s ability to easily create customised button actions to show a button that will use the Editor form (without displaying it to the end user) to add 250 to the salary value for the selected row.