サクサク読めて、アプリ限定の機能も多数!
トップへ戻る
ノーベル賞
datatables.net
Exporting data from a table can often be a key part of a complex application. The Buttons extension for DataTables provides three plug-ins that provide overlapping functionality for data export: HTML5 export buttons - makes use of HTML5 APIs to create files client-side Print button Both sets of buttons provide: Copy to clipboard Save as Excel (XLSX) Save as CSV Save as PDF Display a print view But
The DataTables API has a number of methods for attaching child rows to a parent row in the DataTable. This can be used to show additional information about a row, useful for cases where you wish to convey more information about a row than there is space for in the host table. The example below makes use of the row().child methods to first check if a row is already displayed, and if so hide it (row
Server-side processing There are times when reading data from the DOM is simply too slow or unwieldy, particularly when dealing with many thousands or millions of data rows. To address this DataTables' server-side processing feature provides a method to let all the "heavy lifting" be done by a database engine on the server-side (they are after all highly optimised for exactly this use case!), and
In some tables you might wish to have some content generated automatically. This can be done in a number of ways: columns.render for content that is dynamic (i.e. based upon the row's data) columns.defaultContent for static content (i.e. simple strings) This examples shows the use of columns.defaultContent to create a button element in the last column of the table. A simple click event listener is
Column width assignment. DescriptionThis parameter can be used to define the width of a column, and may take any CSS value (3em, 20px etc). Please note that pixel perfect column width is virtually impossible to achieve in tables with dynamic content, so do not be surprised if the width of the column is off by a few pixels from what you assign using this property. Column width in tables depends upo
Bootstrap 3 Bootstrap 3 is a CSS framework that lets you quickly and easily build a user interface that has a unified look and feel. It is super easy to integrate Bootstrap and DataTables so that your fully featured DataTables will match the same look and feel of the rest of your site. Bootstrap 3 provides a number of options for styling HTML tables, giving you flexibility over the table, while en
There are many ways to get your data into DataTables, and if you are working with seriously large databases, you might want to consider using the server-side options that DataTables provides. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to a server where an SQL engine (or similar) can perform these actions on the large data se
The searching functionality provided by DataTables is useful for quickly search through the information in the table - however the search is global, and you may wish to present controls that search on specific columns. DataTables has the ability to apply searching to a specific column through the column().search() method (note that the name of the method is search not filter, since filter() is use
DataTables can integrate seamlessly with Bootstrap 3 using Bootstrap's table styling options to present an interface with a uniform design, based on Bootstrap, for your site / app. DataTables' Bootstrap integration also provides a renderer for the pagination control in DataTables to ensure that the pagination of the table is also styled consistently by Bootstrap. This integration is done simply by
At times you will wish to be able to create a table from dynamic information passed directly to DataTables, rather than having it read from the document. This is achieved using the data option in the initialisation object, passing in an array of data to be used (like all other DataTables handled data, this can be arrays or objects using the columns.data option). A table must be available on the pa
3. Warning: Cannot reinitialise DataTable DataTables has a wide range of configuration options which can be used to customise the table at initialisation time, but only at initialisation time. After a DataTable has been initialised any attempt to use these options will result in an error. Meaning Simply put, DataTables does not allow initialisation options to be altered at any time other than at i
7. Warning: Ajax error When using the ajax option to load data for DataTables, a general error can be triggered if the server responds with anything other than a valid HTTP 2xx response. The error given is: DataTables warning: table id={id} - Ajax error where {id} is the DOM id of the table that triggered the error. Meaning This occurs when jQuery falls into its error callback handler (this callba
FixedColumns When making use of DataTables' x-axis scrolling feature (scrollX), you may wish to fix the left or right most columns in place. This extension for DataTables provides exactly this option (for non-scrolling tables, please use the FixedHeader extension, which will create sticky headers and footers for tables). FixedColumns (as of version 4+) makes use of position: sticky in CSS. All eve
Download The best method for getting a hold of DataTables for use in your project depends upon your programming environment. The download builder below provides a simple method that you can use to build your own custom DataTables package - including only the software that you need, and providing options to have it hosted on the DataTables CDN, download the package locally or install through a pack
This example modifies the multiple row selection example by only allowing the selection of a single row. This is done by checking to see if the row already has a selected class, and if so removing it, but if not then the class is removed from all other rows in the table and then applied to the row being selected. Also shown is the row().remove() method which deletes a row from a table, and the dra
Twitter Bootstrap 2 Update: Bootstrap integration with DataTables is now formalised in the styling section of the manual. The Twitter Bootstrap folks have just released v2 of their UI framework that has a number of improvements on the v1 series. However, as might be expected from a major upgrade there are also a few API changes. As such, this post is an update to my original article for Bootstrap
Twitter Bootstrap Update 2: Bootstrap integration with DataTables is now formalised in the styling section of the manual. Update: A new blog post is available, building on this one, describing how to integrate DataTables and Twitter Bootstrap 2.0. Twitter Bootstrap is a CSS framework that lets you quickly and easily build a user interface that has a unified look and feel. The great news is that it
This example shows how you can make use of the column().visible() API method to dynamically show and hide columns in a table. Also included here is scrolling, just to show it enabled with this API method, although it's not required for the API function to work. In addition, groups of columns can be shown and hidden at the same time using the columns() method to select multiple columns and then usi
API DataTables has an extensive API which can be used to access the data contained in a table and otherwise manipulate the table after the table initialisation has completed. The DataTables API is designed to reflect the structure of the data in the table and how you will typically interact with the table through the API. It can also be extended by the extensions and plug-ins providing additional
The following example shows how a callback function can be used to format a particular row at draw time. For each row that is generated for display, the createdRow function is called once and once only. It is passed the create row node which can then be modified. In this case a trivial example of making the 'salary' column blue and bold by adding a CSS class to the container cell if the salary is
In order to perform paging, ordering, searching etc, DataTables can remove rows and cells from the document (i.e. those rows / cells which are not needed are not inserted into the document). This increases performance and compatibility, however, it means that submitting forms which span multiple pages requires a little bit of additional work to get the information that is not in the document any l
One of the best ways to learn how to do anything new (including software APIs!) is to get your hands dirty as quickly as possible. These examples will show you how to perform tasks ranging from something as simple as applying DataTables to an HTML table, right the way through to doing server-side processing with pipelining and custom plug-in functions.
Add advanced interaction controls to your HTML tables the free & easy way
このページを最初にブックマークしてみませんか?
『DataTables | Javascript table library』の新着エントリーを見る
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く