TreeGrid extension to display and edit data in cell based spreadsheet
TreeGrid SpreadSheet provides cell based AJAX grid with spreadsheet features like editable formulas, many predefined and custom formula functions,
individual cell styling and borders, manipulating individual cells or selected cell groups, auto grid size, auto row and column index.
TreeGrid SpreadSheet MS Excel look example
Microsoft Internet Explorer IE6, IE7, IE8, IE9, IE10, IE11 Microsoft Edge 12, 13, 14 (all document modes quirks, quirks5, strict, compatibility)
(And all Trident, Gecko and WebKit / Chromium / Blink engine clones)
Basic sheet features
cell content editing
changes update to server by AJAX or by page / form submit (HTTP POST)
row selecting, adding and deleting
column selecting, adding and deleting
row and column moving and resizing
row and column hiding / displaying
toolbar and row / column control panel
Server side support
EJS TreeGrid package contains many examples and predefined code of server side scripts:
ASP.NET (C#, Visual Basic)
AngularJS 1 & 2 (NodeJS REST API)
React (NodeJS REST API)
HTML (all other)
EJS TreeGrid can be used also in any other server script environment that can handle and process XML or JSON data.
editable formulas - every cell can contain formula starting by '=' like in MS Excel.
many built-in formula functions and possibility to create any new custom functions to be used in editable formulas.
fully localized formulas - the formula function names, operators and separators can be different in every language.
selecting formula source cells or cell ranges by mouse during editing
suggest list with available formula functions shown during editing
mass change of selected cell groups - copy, move, auto fill, clear, copy&paste
mass changes can affect cell values, formulas, styles, borders, span or any other attributes.
dynamic cell styling - every cell can have set and changed style attributes:
text color, background color, shadow color and style, font size and name, text bold, italic, underline, strike, overline and small caps.
And also horizontal and vertical alignment, wrapping text vertically and text rotate 90 and 270 degrees.
dynamic cell border - every cell can have set and changed its border on any edge.
The border can can have different width, style and color and is shared between adjacent cells.
dynamic cell span - every cell can be vertically and horizontally spanned through more next cells.
dynamic cell format - every cell can have set and changed its type and display format
auto sheet size - automatic adding rows and columns on scroll to the sheet end and automatic removing unused rows and columns.
full paging of rows and columns to handle large sheets with many cells.
auto rows and columns index - identifying rows and columns by their position rather than id or name.
full undo & redo - every action in sheet can be undone.
fully customizable cell popup menu with available actions for actual / focused or selected cell.
editing cell content also outside the grid in external edit box.
copy & paste cells to and from MS Excel or another spreadsheet program.
export sheet data to xlsx, xls or csv file and open this file in MS Excel.
print and print to PDF
fixed (frozen) columns and rows on all the edges
grid features like tree, grouping, sorting, filter and search
responsive web design, changing grid layout according to viewport size by defined media rules.
fully customizable CSS styles to change grid look
sophisticated XML input / output format, JSON format also supported
fully customizable key and mouse navigation action schemas
very fast to display and control
script modules - modules not in use can be removed from the script in order to shorten its length
localization to any language possible, including all texts, date and number formats
RTL version for Middle East languages plus Hirji dates
both CSS1 strict and quirks mode supported (any <!DOCTYPE> setting)