Nerdiest Political Manifesto

    jquery-xtable

    0.5.0 • Public • Published

    Build Status npm version Bower version

    jQuery XTable

    Introduction

    XTable provides a table selection API for HTML tables on top of jQuery. XTable augments the base jQuery object with a table function. The developer can use this table function to construct a XTable object. Via the XTable object, the developer can access XTable methods in addition to standard jQuery ones.

    License | Supported Platforms | Table selectors | User selection

    Summary

    For example:

     
    var obj = $.table('table.buster')
     
     

    gives you access to a suite XTable methods. These methods include:

    • base/basis - set/return the origin for coordinate mapping
    • row/xrow - select a row by passing in the row number
    • column/xcolumn - select a column by passing in the column label
    • cell/xcell - select a cell by passing in the cell label

    Examples

    Styling

    To set the background color of cells in row 2 to red:

    $.table('table').row(2).css('background-color', 'red');

    To set the text color of cells of A1 to D2 to blue:

    $.table('table').range('A1:D2').css('color', 'blue');

    Find the title element in cell A1 and hide it:

    $.table('table').cell('A1').find('.title').hide();

    Data Extraction

    To get the text of the first row:

    $.table('table').row(1).text()

    To get the text of the A1 cell:

    $.table('table').cell('A1').text();

    To get the value of the A1 cell:

    $.table('table').cell('A1').value();

    Statistics

    To sum column D in table.mlb:

    $.table('table.mlb').column('D').sum()

    To calculate the average of column D in table.mlb:

    $.table('table.mlb').column('D').avg()

    Coordinate Remapping

    Remap coordinates by skipping the first header row. Retrieve the value of the A1 cell with the new coordinate mapping.

    $.table('table').base('A2').cell('A1').value()

    Remap coordinates by skipping the first header row and first header column. Retrieve the value of the A1 cell with the new coordinate mapping.

    $.table('table').base('B2').cell('A1').value()

    User Selection

    To enable user selection:

    $.table('table').enableUI();

    To get cells selected by user:

    $.table('table').selection

    Install

    npm i jquery-xtable

    DownloadsWeekly Downloads

    2

    Version

    0.5.0

    License

    MIT

    Last publish

    Collaborators

    • dicksont