News in versions: FastGrid 1.0, TreeGrid 17.0
Development References Contacts
FastGrid FastSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Development
services		 References References Contacts
TreeGrid Gantt chart SpreadSheet ExamplesSamples DocumentationDoc Download Licensing Prices Buy Contacts

FastGrid SpreadSheet

FastGrid extension to display and edit data in cell based spreadsheet

FastSheet provides cell based AJAX grid with spreadsheet features like editable formulas, many predefined formula functions, individual cell styling and borders, manipulating cells / cell ranges, auto grid size, auto row and column index. Can display million of rows and thousands of columns like MS Excel.

FastSheet MS Excel xlsx example

Drop any .xlsx file to the grid to open and edit it here! Or open any .xlsx file from your disk by click to import icon on toolbar.
The xlsx files can be opened, edited and saved (by export icon) directly in browser, without any communication with server!

Supported browsers


Google Chrome

Microsoft Edge

Apple Safari
Mac OSX / iOS

Mozilla Firefox

Android Webview

Samsung Internet

Opera


(And all Gecko and WebKit / Chromium / Blink engine clones)

Supported browsers


Google Chrome
Microsoft Edge
Apple Safari; Mac OSX / iOS
Mozilla Firefox
Android Webview
Samsung Internet
Opera
(And all Gecko and WebKit / Chromium / Blink engine clones)

JavaScript frameworks

EJS FastGrid package contains examples and documentation to use in JavaScript frameworks:
  • Angular (TypeScript)
  • Ember (JavaScript / TypeScript)
  • Express (JavaScript)
  • React (JavaScript / TypeScript)
  • Svelte (JavaScript / TypeScript)
  • Vue (JavaScript / TypeScript)
  • SalesForce LWC (JavaScript)
  • Other frameworks (HTML, JavaScript)
EJS FastGrid can be used also in any other client side framework that supports third party JavaScript code.

Server side support

EJS FastGrid package contains examples and predefined code of server side scripts:
  • NodeJS (JavaScript)
  • ASP.NET (C#, Visual Basic)
  • JSP (Java)
  • PHP
  • HTML (all other)
EJS FastGrid can be used also in any other server script environment that can handle and process JSON data.

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



Main advantages

  • the fastest web spreadsheet, in many features it is faster than binary MS Excel
  • full xlsx support - loading and opening xlsx file chosen from file system or dropped to grid by dragging and saving the changes back to the xlsx.
  • big xlsx support - can easily load and display huge xlsx with the same limits as MS Excel, 1 048 576 rows and 16 384 columns.
  • xlsx can be opened, edited and saved without accessing web server
  • editable formulas - every cell can contain formula starting by '=' like in MS Excel. Syntax compatible with MS Excel.
  • 230 built-in formula functions to be used in editable formulas. Names are the same as in MS Excel.
  • selecting formula source cells or cell ranges by mouse during editing
  • more sheets and their manipulation (add, delete, move, copy, rename)
  • editable formulas with external references to other sheet
  • MS Excel outline to arrange rows and columns in tree
  • 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
  • automatic cell type - cell chooses its type and display according to its value and format
  • inserting images to cell text or outside cells like MS Excel, by dropping it to cell or opening image file chosen from file system.
  • editing images inside or outside cells by mouse dragging - move, resize, rotate, crop, change opacity or name.
  • auto sheet size - automatic adding rows and columns on scroll to the sheet end and automatic removing unused rows and columns.
  • 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 and formulas also outside the grid in external edit box.
  • rich text / HTML editor in contentEditable tags, full inline WYSIWYG editor, text, color and shapes styling, images and links.
  • copy & paste cell values, formats and styles 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
  • advanced JavaScript API with events and methods to control the grid from JavaScript
  • using grid without any need of JavaScript code on a page
  • sophisticated JSON input / output format usable instead of xlsx
  • fully customizable key and mouse navigation action schemes
  • full manual and automatic toolbar arrangement
  • localization to any language possible, including date and number formats

FastSheet JSON example

More examples