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="https://github.com/gurubenka/handsontable-excel/raw/master/lib/jquery.min.js"></script>
<script src="https://github.com/gurubenka/handsontable-excel/raw/master/dist/jquery.handsontable.full.js"></script>
<link rel="stylesheet" media="screen" href="https://github.com/gurubenka/handsontable-excel/blob/master/dist/jquery.handsontable.full.css">

<script src="https://github.com/gurubenka/handsontable-excel/raw/master/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