Theme-Logo
    • Notifications
    • Generic placeholder image
      John Doe

      Lorem ipsum dolor sit amet, consectetuer elit.

      30 minutes ago
    • Generic placeholder image
      Joseph William

      Lorem ipsum dolor sit amet, consectetuer elit.

      30 minutes ago
    • Generic placeholder image
      Sara Soudein

      Lorem ipsum dolor sit amet, consectetuer elit.

      30 minutes ago
  • User-Profile-Image John Doe
    • Settings
    • Profile
    • My Messages
    • Lock Screen
    • Logout
Generic placeholder image
Josephin Doe
Generic placeholder image
Lary Doe
Generic placeholder image
Alice
Generic placeholder image
Alia
Generic placeholder image
Suzen
Josephin Doe
Generic placeholder image

I'm just looking around. Will you tell me something about yourself?

8:20 a.m.

I'm just looking around. Will you tell me something about yourself?

8:20 a.m.

Generic placeholder image
Navigation
  • D Dashboard
    • Default
    • Ecommerce
    • Analytics NEW
  • P Page layouts NEW
    • Vertical
      • Static Layout
      • Header Fixed
      • Compact
      • Sidebar Fixed
    • Horizontal
      • Static Layout
      • Fixed layout
      • Static With Icon
      • Fixed With Icon
    • Bottom Menu
    • Box Layout
    • RTL
  • N Navigation
  • W Widget 100+
    • Statistic
    • Data
    • Chart Widget
UI Element
  • BC Basic
    • Alert
    • Breadcrumbs
    • Button
    • Box-Shadow
    • Accordion
    • Generic Class
    • Tabs
    • Color
    • Label Badge
    • Progress Bar
    • Pre-Loader
    • List
    • Tooltip And Popover
    • Typography
    • Other
  • AC Advance
    • Draggable
    • Grid Stack
    • Light Box
    • Modal
    • Notifications
    • PNOTIFY NEW
    • Rating
    • Range Slider
    • Slider
    • Syntax Highlighter
    • Tour
    • Tree View
    • Nestable
    • Toolbar
    • X-Editable
  • EC Extra
    • Session Timeout
    • Session Idle Timeout
    • Offline
  • A Animations
  • S Sticky Notes HOT
  • I Icons
    • Font Awesome
    • Themify
    • Simple Line Icon
    • Ion Icon
    • Material Design
    • Ico Fonts
    • Weather Icon
    • Typicons
    • Flags
Forms
  • FC Form
    • Components
    • Add-On
    • Advance
    • Validation
  • FP Form Picker NEW
  • FS Form Select
  • FM Form Masking
  • F Form Wizard
  • R Ready To Use HOT
    • Cloned Elements Form
    • Currency Form
    • Booking Form
    • Booking Multi Steps
    • Comment Form
    • Contact Form
    • Job Application Form
    • JS Addition Form
    • Login Form
    • Popup Modal Form
    • Registration Form
    • Review Form
    • Subscribe Form
    • Suggestion Form
    • Tabs Form
Tables
  • B Bootstrap Table
    • Basic Table
    • Sizing Table
    • Border Table
    • Styling Table
  • DT Data Table
    • Basic Initialization
    • Advance Initialization
    • Styling
    • API
    • Ajax
    • Server Side
    • Plug-In
    • Data Sources
  • D DT Extensions
    • AutoFill
    • Button
      • Basic Button
      • Data Export
    • Col Reorder
    • Fixed Columns
    • Fixed Header
    • Key Table
    • Responsive
    • Row Reorder
    • Scroller
    • Select Table
  • F FooTable
  • HT Handson Table
    • Appearance
    • Data Operation
    • Rows Columns
    • Columns Only
    • Cell Features
    • Cell Types
    • Integrations
    • Rows Only
    • Utilities
  • E Editable Table
Chart And Maps
  • C Charts
    • Google Chart
    • Echarts
    • ChartJs
    • List Chart
    • Float Chart
    • Knob chart
    • Morris Chart
    • Nvd3 Chart
    • Peity Chart
    • Radial Chart
    • Rickshaw Chart
    • Sparkline Chart
    • C3 Chart
  • M Maps
    • Google Maps
    • Vector Maps
    • Google Map Search API
    • Location
  • LP Landing Page
Pages
  • A Authentication
    • Login
      • Simple
      • Header & Footer
      • Social
      • Social With Header & Footer
    • Registration
      • Simple
      • Header & Footer
      • Social
      • Social With Header & Footer
    • Multi Step Registration
    • Forgot Password
    • Lock Screen
    • Modal
  • M Maintenance
    • Error
    • Comming Soon
    • Offline UI
  • UP User Profile
    • Timeline
    • Timeline Social
    • User Profile
    • User Card
  • E E-Commerce NEW
    • Product
    • Product List
    • Product Edit
    • Product Detail
    • Product Card
    • Credit Card Form
  • E Email
    • Compose Email
    • Inbox
    • Read Mail
    • Email Template
      • Welcome Email
      • Reset Password
      • Newsletter Email
      • App Launch
      • Activation Code
App
  • S Social
    • Wall
    • Messages
  • T Task
    • Task List
    • Task Board
    • Task Detail
    • Issue List
  • T To-Do
    • To-Do
    • Notes
  • G Gallery
    • Gallery-Grid
    • Masonry Gallery
    • Advance Gallery
  • S Search
    • Simple Search
    • Grouping Search
  • JS Job Search NEW
    • Card View
    • Job Detailed
    • Job Find
    • Job Panel View
Extension
  • E Editor
    • CK-Editor
    • WYSIWYG Editor
    • Ace Editor
    • Long Press Editor
  • I Invoice
    • Invoice
    • Invoice Summary
    • Invoice List
  • EC Event Calendar
    • Full Calendar
    • CLNDER NEW
  • IC Image Cropper
  • FU File Upload
  • CL Change Loges 1.0
Other
  • M Menu Levels
    • Menu Level 2.1
    • Menu Level 2.2
      • Menu Level 3.1
    • Menu Level 2.3
  • D Disabled Menu
  • S Sample Page
Support
  • D Documentation
  • SI Need Support ?
AutoFill Datatable

Excel like data fill option to DataTables

  • Data Table Extensions
  • AutoFill
Auto Fill
AutoFill gives an Excel like option to a DataTable to click and drag over multiple cells, filling in information over the selected cells and incrementing numbers as needed.
Name Position Office Age Start date Salary
Tiger Nixon System Architect Edinburgh 61 2011/04/25 $320,800
Garrett Winters Accountant Tokyo 63 2011/07/25 $170,750
Ashton Cox Junior Technical Author San Francisco 66 2009/01/12 $86,000
Cedric Kelly Senior Javascript Developer Edinburgh 22 2012/03/29 $433,060
Airi Satou Accountant Tokyo 33 2008/11/28 $162,700
Brielle Williamson Integration Specialist New York 61 2012/12/02 $372,000
Herrod Chandler Sales Assistant San Francisco 59 2012/08/06 $137,500
Rhona Davidson Integration Specialist Tokyo 55 2010/10/14 $327,900
Colleen Hurst Javascript Developer San Francisco 39 2009/09/15 $205,500
Sonya Frost Software Engineer Edinburgh 23 2008/12/13 $103,600
Jena Gaines Office Manager London 30 2008/12/19 $90,560
Quinn Flynn Support Lead Edinburgh 22 2013/03/03 $342,000
Charde Marshall Regional Director San Francisco 36 2008/10/16 $470,600
Haley Kennedy Senior Marketing Designer London 43 2012/12/18 $313,500
Tatyana Fitzpatrick Regional Director London 19 2010/03/17 $385,750
Michael Silva Marketing Designer London 66 2012/11/27 $198,500
Paul Byrd Chief Financial Officer (CFO) New York 64 2010/06/09 $725,000
Gloria Little Systems Administrator New York 59 2009/04/10 $237,500
Bradley Greer Software Engineer London 41 2012/10/13 $132,000
Dai Rios Personnel Lead Edinburgh 35 2012/09/26 $217,500
Jenette Caldwell Development Lead New York 30 2011/09/03 $345,000
Yuri Berry Chief Marketing Officer (CMO) New York 40 2009/06/25 $675,000
Caesar Vance Pre-Sales Support New York 21 2011/12/12 $106,450
Doris Wilder Sales Assistant Sidney 23 2010/09/20 $85,600
Angelica Ramos Chief Executive Officer (CEO) London 47 2009/10/09 $1,200,000
Gavin Joyce Developer Edinburgh 42 2010/12/22 $92,575
Jennifer Chang Regional Director Singapore 28 2010/11/14 $357,650
Brenden Wagner Software Engineer San Francisco 28 2011/06/07 $206,850
Fiona Green Chief Operating Officer (COO) San Francisco 48 2010/03/11 $850,000
Shou Itou Regional Marketing Tokyo 20 2011/08/14 $163,000
Michelle House Integration Specialist Sidney 37 2011/06/02 $95,400
Suki Burks Developer London 53 2009/10/22 $114,500
Prescott Bartlett Technical Author London 27 2011/05/07 $145,000
Gavin Cortez Team Leader San Francisco 22 2008/10/26 $235,500
Martena Mccray Post-Sales support Edinburgh 46 2011/03/09 $324,050
Unity Butler Marketing Designer San Francisco 47 2009/12/09 $85,675
Howard Hatfield Office Manager San Francisco 51 2008/12/16 $164,500
Hope Fuentes Secretary San Francisco 41 2010/02/12 $109,850
Vivian Harrell Financial Controller San Francisco 62 2009/02/14 $452,500
Timothy Mooney Office Manager London 37 2008/12/11 $136,200
Jackson Bradshaw Director New York 65 2008/09/26 $645,750
Olivia Liang Support Engineer Singapore 64 2011/02/03 $234,500
Bruno Nash Software Engineer London 38 2011/05/03 $163,500
Sakura Yamamoto Support Engineer Tokyo 37 2009/08/19 $139,575
Thor Walton Developer New York 61 2013/08/11 $98,540
Finn Camacho Support Engineer San Francisco 47 2009/07/07 $87,500
Serge Baldwin Data Coordinator Singapore 64 2012/04/09 $138,575
Zenaida Frank Software Engineer New York 63 2010/01/04 $125,250
Zorita Serrano Software Engineer San Francisco 56 2012/06/01 $115,000
Jennifer Acosta Junior Javascript Developer Edinburgh 43 2013/02/01 $75,650
Cara Stevens Sales Assistant New York 46 2011/12/06 $145,600
Hermione Butler Regional Director London 47 2011/03/21 $356,250
Lael Greer Systems Administrator London 21 2009/02/27 $103,500
Jonas Alexander Developer San Francisco 30 2010/07/14 $86,500
Shad Decker Regional Director Edinburgh 51 2008/11/13 $183,000
Michael Bruce Javascript Developer Singapore 29 2011/06/27 $183,000
Donna Snider Customer Support New York 27 2011/01/25 $112,000
Name Position Office Age Start date Salary
KeyTable Integration
If you are looking to emulate the UI of spreadsheet programs such as Excel with DataTables, the combination of KeyTable and AutoFill will take you a long way there!
Name Position Office Age Start date Salary
Tiger Nixon System Architect Edinburgh 61 2011/04/25 $320,800
Garrett Winters Accountant Tokyo 63 2011/07/25 $170,750
Ashton Cox Junior Technical Author San Francisco 66 2009/01/12 $86,000
Cedric Kelly Senior Javascript Developer Edinburgh 22 2012/03/29 $433,060
Airi Satou Accountant Tokyo 33 2008/11/28 $162,700
Brielle Williamson Integration Specialist New York 61 2012/12/02 $372,000
Herrod Chandler Sales Assistant San Francisco 59 2012/08/06 $137,500
Rhona Davidson Integration Specialist Tokyo 55 2010/10/14 $327,900
Colleen Hurst Javascript Developer San Francisco 39 2009/09/15 $205,500
Sonya Frost Software Engineer Edinburgh 23 2008/12/13 $103,600
Jena Gaines Office Manager London 30 2008/12/19 $90,560
Quinn Flynn Support Lead Edinburgh 22 2013/03/03 $342,000
Charde Marshall Regional Director San Francisco 36 2008/10/16 $470,600
Haley Kennedy Senior Marketing Designer London 43 2012/12/18 $313,500
Tatyana Fitzpatrick Regional Director London 19 2010/03/17 $385,750
Michael Silva Marketing Designer London 66 2012/11/27 $198,500
Paul Byrd Chief Financial Officer (CFO) New York 64 2010/06/09 $725,000
Gloria Little Systems Administrator New York 59 2009/04/10 $237,500
Bradley Greer Software Engineer London 41 2012/10/13 $132,000
Dai Rios Personnel Lead Edinburgh 35 2012/09/26 $217,500
Jenette Caldwell Development Lead New York 30 2011/09/03 $345,000
Yuri Berry Chief Marketing Officer (CMO) New York 40 2009/06/25 $675,000
Caesar Vance Pre-Sales Support New York 21 2011/12/12 $106,450
Doris Wilder Sales Assistant Sidney 23 2010/09/20 $85,600
Angelica Ramos Chief Executive Officer (CEO) London 47 2009/10/09 $1,200,000
Gavin Joyce Developer Edinburgh 42 2010/12/22 $92,575
Jennifer Chang Regional Director Singapore 28 2010/11/14 $357,650
Brenden Wagner Software Engineer San Francisco 28 2011/06/07 $206,850
Fiona Green Chief Operating Officer (COO) San Francisco 48 2010/03/11 $850,000
Shou Itou Regional Marketing Tokyo 20 2011/08/14 $163,000
Michelle House Integration Specialist Sidney 37 2011/06/02 $95,400
Suki Burks Developer London 53 2009/10/22 $114,500
Prescott Bartlett Technical Author London 27 2011/05/07 $145,000
Gavin Cortez Team Leader San Francisco 22 2008/10/26 $235,500
Martena Mccray Post-Sales support Edinburgh 46 2011/03/09 $324,050
Unity Butler Marketing Designer San Francisco 47 2009/12/09 $85,675
Howard Hatfield Office Manager San Francisco 51 2008/12/16 $164,500
Hope Fuentes Secretary San Francisco 41 2010/02/12 $109,850
Vivian Harrell Financial Controller San Francisco 62 2009/02/14 $452,500
Timothy Mooney Office Manager London 37 2008/12/11 $136,200
Jackson Bradshaw Director New York 65 2008/09/26 $645,750
Olivia Liang Support Engineer Singapore 64 2011/02/03 $234,500
Bruno Nash Software Engineer London 38 2011/05/03 $163,500
Sakura Yamamoto Support Engineer Tokyo 37 2009/08/19 $139,575
Thor Walton Developer New York 61 2013/08/11 $98,540
Finn Camacho Support Engineer San Francisco 47 2009/07/07 $87,500
Serge Baldwin Data Coordinator Singapore 64 2012/04/09 $138,575
Zenaida Frank Software Engineer New York 63 2010/01/04 $125,250
Zorita Serrano Software Engineer San Francisco 56 2012/06/01 $115,000
Jennifer Acosta Junior Javascript Developer Edinburgh 43 2013/02/01 $75,650
Cara Stevens Sales Assistant New York 46 2011/12/06 $145,600
Hermione Butler Regional Director London 47 2011/03/21 $356,250
Lael Greer Systems Administrator London 21 2009/02/27 $103,500
Jonas Alexander Developer San Francisco 30 2010/07/14 $86,500
Shad Decker Regional Director Edinburgh 51 2008/11/13 $183,000
Michael Bruce Javascript Developer Singapore 29 2011/06/27 $183,000
Donna Snider Customer Support New York 27 2011/01/25 $112,000
Name Position Office Age Start date Salary
Column Selector
AutoFill provides the ability to determine what columns it should be enabled upon through the autoFill.columns option. This will accept any value allowed by the column-selector data type, such as an array of column indexes, class names, or as shown in this case a jQuery selector.
Name Position Office Age Salary
Tiger Nixon System Architect Edinburgh 61 $320,800
Garrett Winters Accountant Tokyo 63 $170,750
Ashton Cox Junior Technical Author San Francisco 66 $86,000
Cedric Kelly Senior Javascript Developer Edinburgh 22 $433,060
Airi Satou Accountant Tokyo 33 $162,700
Brielle Williamson Integration Specialist New York 61 $372,000
Herrod Chandler Sales Assistant San Francisco 59 $137,500
Rhona Davidson Integration Specialist Tokyo 55 $327,900
Colleen Hurst Javascript Developer San Francisco 39 $205,500
Sonya Frost Software Engineer Edinburgh 23 $103,600
Jena Gaines Office Manager London 30 $90,560
Quinn Flynn Support Lead Edinburgh 22 $342,000
Charde Marshall Regional Director San Francisco 36 $470,600
Haley Kennedy Senior Marketing Designer London 43 $313,500
Tatyana Fitzpatrick Regional Director London 19 $385,750
Michael Silva Marketing Designer London 66 $198,500
Paul Byrd Chief Financial Officer (CFO) New York 64 $725,000
Gloria Little Systems Administrator New York 59 $237,500
Bradley Greer Software Engineer London 41 $132,000
Dai Rios Personnel Lead Edinburgh 35 $217,500
Jenette Caldwell Development Lead New York 30 $345,000
Yuri Berry Chief Marketing Officer (CMO) New York 40 $675,000
Caesar Vance Pre-Sales Support New York 21 $106,450
Doris Wilder Sales Assistant Sidney 23 $85,600
Angelica Ramos Chief Executive Officer (CEO) London 47 $1,200,000
Gavin Joyce Developer Edinburgh 42 $92,575
Jennifer Chang Regional Director Singapore 28 $357,650
Brenden Wagner Software Engineer San Francisco 28 $206,850
Fiona Green Chief Operating Officer (COO) San Francisco 48 $850,000
Shou Itou Regional Marketing Tokyo 20 $163,000
Michelle House Integration Specialist Sidney 37 $95,400
Suki Burks Developer London 53 $114,500
Prescott Bartlett Technical Author London 27 $145,000
Gavin Cortez Team Leader San Francisco 22 $235,500
Martena Mccray Post-Sales support Edinburgh 46 $324,050
Unity Butler Marketing Designer San Francisco 47 $85,675
Howard Hatfield Office Manager San Francisco 51 $164,500
Hope Fuentes Secretary San Francisco 41 $109,850
Vivian Harrell Financial Controller San Francisco 62 $452,500
Timothy Mooney Office Manager London 37 $136,200
Jackson Bradshaw Director New York 65 $645,750
Olivia Liang Support Engineer Singapore 64 $234,500
Bruno Nash Software Engineer London 38 $163,500
Sakura Yamamoto Support Engineer Tokyo 37 $139,575
Thor Walton Developer New York 61 $98,540
Finn Camacho Support Engineer San Francisco 47 $87,500
Serge Baldwin Data Coordinator Singapore 64 $138,575
Zenaida Frank Software Engineer New York 63 $125,250
Zorita Serrano Software Engineer San Francisco 56 $115,000
Jennifer Acosta Junior Javascript Developer Edinburgh 43 $75,650
Cara Stevens Sales Assistant New York 46 $145,600
Hermione Butler Regional Director London 47 $356,250
Lael Greer Systems Administrator London 21 $103,500
Jonas Alexander Developer San Francisco 30 $86,500
Shad Decker Regional Director Edinburgh 51 $183,000
Michael Bruce Javascript Developer Singapore 29 $183,000
Donna Snider Customer Support New York 27 $112,000
Name Position Office Age Salary
Scrolling DataTable
When dragging an AutoFill handle, the table (if DataTables scrolling is enabled) or the window will be automatically scrolled, as you approach the edge of the scrolling component. The example below shows the effect with DataTables scrolling (and also window if needed).
Name Position Office Age Salary
Tiger Nixon System Architect Edinburgh 61 $320,800
Garrett Winters Accountant Tokyo 63 $170,750
Ashton Cox Junior Technical Author San Francisco 66 $86,000
Cedric Kelly Senior Javascript Developer Edinburgh 22 $433,060
Airi Satou Accountant Tokyo 33 $162,700
Brielle Williamson Integration Specialist New York 61 $372,000
Herrod Chandler Sales Assistant San Francisco 59 $137,500
Rhona Davidson Integration Specialist Tokyo 55 $327,900
Colleen Hurst Javascript Developer San Francisco 39 $205,500
Sonya Frost Software Engineer Edinburgh 23 $103,600
Jena Gaines Office Manager London 30 $90,560
Quinn Flynn Support Lead Edinburgh 22 $342,000
Charde Marshall Regional Director San Francisco 36 $470,600
Haley Kennedy Senior Marketing Designer London 43 $313,500
Tatyana Fitzpatrick Regional Director London 19 $385,750
Michael Silva Marketing Designer London 66 $198,500
Paul Byrd Chief Financial Officer (CFO) New York 64 $725,000
Gloria Little Systems Administrator New York 59 $237,500
Bradley Greer Software Engineer London 41 $132,000
Dai Rios Personnel Lead Edinburgh 35 $217,500
Jenette Caldwell Development Lead New York 30 $345,000
Yuri Berry Chief Marketing Officer (CMO) New York 40 $675,000
Caesar Vance Pre-Sales Support New York 21 $106,450
Doris Wilder Sales Assistant Sidney 23 $85,600
Angelica Ramos Chief Executive Officer (CEO) London 47 $1,200,000
Gavin Joyce Developer Edinburgh 42 $92,575
Jennifer Chang Regional Director Singapore 28 $357,650
Brenden Wagner Software Engineer San Francisco 28 $206,850
Fiona Green Chief Operating Officer (COO) San Francisco 48 $850,000
Shou Itou Regional Marketing Tokyo 20 $163,000
Michelle House Integration Specialist Sidney 37 $95,400
Suki Burks Developer London 53 $114,500
Prescott Bartlett Technical Author London 27 $145,000
Gavin Cortez Team Leader San Francisco 22 $235,500
Martena Mccray Post-Sales support Edinburgh 46 $324,050
Unity Butler Marketing Designer San Francisco 47 $85,675
Howard Hatfield Office Manager San Francisco 51 $164,500
Hope Fuentes Secretary San Francisco 41 $109,850
Vivian Harrell Financial Controller San Francisco 62 $452,500
Timothy Mooney Office Manager London 37 $136,200
Jackson Bradshaw Director New York 65 $645,750
Olivia Liang Support Engineer Singapore 64 $234,500
Bruno Nash Software Engineer London 38 $163,500
Sakura Yamamoto Support Engineer Tokyo 37 $139,575
Thor Walton Developer New York 61 $98,540
Finn Camacho Support Engineer San Francisco 47 $87,500
Serge Baldwin Data Coordinator Singapore 64 $138,575
Zenaida Frank Software Engineer New York 63 $125,250
Zorita Serrano Software Engineer San Francisco 56 $115,000
Jennifer Acosta Junior Javascript Developer Edinburgh 43 $75,650
Cara Stevens Sales Assistant New York 46 $145,600
Hermione Butler Regional Director London 47 $356,250
Lael Greer Systems Administrator London 21 $103,500
Jonas Alexander Developer San Francisco 30 $86,500
Shad Decker Regional Director Edinburgh 51 $183,000
Michael Bruce Javascript Developer Singapore 29 $183,000
Donna Snider Customer Support New York 27 $112,000
Name Position Office Age Salary