Skip to content
Plugin for jquery-handsontable to make spreadsheet behaviour
JavaScript CSS
Branch: master
Clone or download
gurubenka Merge pull request #2 from uszywieloryba/master
Two fixes + README.md update
Latest commit eb02d5c Dec 7, 2014

README.md

Handsontable-excel

This plugins enables Excel-like formula evaluation for Handsontable.

Demo

See demo on JSFiddle

Usage

Include handsontable-excel code after handsontable code.

<script src="lib/jquery.min.js"></script>
<script src="dist/jquery.handsontable.full.js"></script>
<link rel="stylesheet" media="screen" href="dist/jquery.handsontable.full.css">

<script src="jquery.handsontable-excel.js"></script>

Formula Syntax

Every cell beginning with = will be evaluated. Supported syntax:

  • algebraic operations

    =(4+5+6)*7

  • cell references (letter for colums, number for row format: A4, B1, C7)

    =(A1+A2+A3)*7

  • function calls

    =SUM(A1:A3)*7

You can’t perform that action at this time.