pyhandsontable 0.1.7

Bring the power of Handsontable to Python and Jupyter Notebook

pyhandsontable

View a 2-D array, probably from pyexcel in Jupyter Notebook, and export to *.html.

Installation

pip install pyhandsontable

Usage

>>> from pyhandsontable import generate_html, view_table
>>> view_table(width=800, height=500, data=data_matrix, **kwargs)

Acceptable kwargs

• title: title of the HTML file
• maxColWidth: maximum column width. Set to 200.
• css: url of the Handsontable CSS
• js: url of the Handsontable Javascript
• css_custom: your custom CSS
• js_pre: Javascript before rendering the table (but after most other things.)
• js_post: Javascript after rendering the table.
• config: add additional config as defined in https://docs.handsontable.com/pro/5.0.0/tutorial-introduction.html
  • This will override the default config (per key basis) which are:

{
  rowHeaders: true,
  colHeaders: true,
  dropdownMenu: true,
  filters: true,
  modifyColWidth: function(width, col){
    if(width > maxColWidth) return maxColWidth;
  }
}