VeryUtils HTML5 Excel is an Online Excel Application which written in JavaScript completely. VeryUtils HTML5 Excel is an online spreadsheet like MS Excel application that is powerful, simple to configure, and able to be embedded into your web and desktop applications easily.
VeryUtils HTML5 Excel is a Best JavaScript Data Grids and Spreadsheets for web and desktop developers. VeryUtils HTML5 Excel is a cloud based Excel Editor, you can use it to Open, View, Edit Excel Online easily. You can use this Online Excel Application to edit Excel files online from Windows, Mac OS, Linux, Android, iOS and anywhere.
If you want to implement following features programmatically, please feel free to contact us,
* Edit XLS, XLSX, XLSM, XLSB, ODS, CSV, TSV, HTML, HTM, MHT, MHTML
* Save to desired format: XLSX, PDF, HTML or original Excel format
* Advanced WYSIWYG Excel editor online
* Calculate formulas
* Set fonts & styles
* Render Charts & Shapes, Edit Comments
* Create an Excel file from templates or open Excel Spreadsheet to edit
* Open OpenDocument Spreadsheet to edit
Demo URLs:
* Open a black Excel Spreadsheet online,
https://veryutils.com/demo/online-excel/
* Open a CSV document online,
https://veryutils.com/demo/online-excel/?file=https://veryutils.com/demo/online-excel/samples/test.csv
* Open an Excel XLS document online,
https://veryutils.com/demo/online-excel/?file=https://veryutils.com/demo/online-excel/samples/test.xls
* Open an Excel XLSX document online,
https://veryutils.com/demo/online-excel/?file=https://veryutils.com/demo/online-excel/samples/test.xlsx
Online Excel Application Highlight Features:
* Edit from Anywhere. It works from all platforms including Windows, Mac, Android and iOS.
* All Excel files are processed in your local system, no files are sent to our servers, 100% protection of your sensitive documents.
* No plugin or software installation required for you.
* It's written entirely in JavaScript and runs entirely within your local web browser.
* Formatting: style, conditional formatting, text alignment and rotation, text truncation, overflow, automatic line wrapping, multiple data types, cell segmentation style
* Cells: drag and drop, fill handle, multiple selection, find and replace, location, merge cells, data verification
* Row & column: hide, insert, delete rows or columns, freeze, and split text
* Operation: undo, redo, copy, paste, cut, hot key, format painter, drag and drop selection
* Formulas & Functions: Built-in, remote and custom formulas
* Tables: filter, sort
* Enhanced functions: Pivot tables, charts, comments, cooperative editing, insert picture, matrix calculations, screenshots, copying to other formats, EXCEL import and export, etc.
Formatting
* Styling (Change font style, size, color, or apply effects)
* Conditional formatting (highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data by using data bars, color scales, and icon sets that correspond to specific variations in the data)
* Align or rotate text
* Support text truncation, overflow, automatic line wrapping
* Data types
-- currency, percentages, decimals, dates
-- Custom (E.g ##,###0.00 , $1,234.56$##,###0.00_);[Red]($##,###0.00), _($* ##,###0.00_);_(...($* "-"_);_(@_), 08-05 PM 01:30MM-dd AM/PM hh:mm )
* Cell segmentation style (Alt+Enter line break, sub,super, in-cell style)
Cells
* Move cells by drag and dropping (Operate on selection)
* Fill handle (For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4. Support arithmetic sequence, geometric sequence,date, week,chinese numbers)
* Auto Fill Options (Fill copy, sequence, only format, no format, day, month, year)
* Multiple selection (Hold Ctrl Selecting multiple cells, copy and paste)
* Find and replace (Such as a particular number or text string, Support regular expression, whole word, case sensitive)
* Location (Cells can be selected according to the data type)
* Merge cells
* Data validation (Checkbox, drop-down list, datePicker)
Row & columns
* Hide, Insert, Delete rows and columns
* Frozen rows and columns (First row, first column, Frozen to selection, freeze adjustment lever can be dragged)
* Split text (Split text into different columns with the Convert Text to Columns Wizard)
Operation
* Undo/Redo
* Copy/Paste/Cut (Copy from excel to VeryUtils HTML5 Excel with format, vice versa)
* Hot key (The operating experience is consistent with excel, if there are differences or missing, please feedback to us)
* Format Painter (Similar to google sheet)
* Selection by drag and dropping (Change the parameters of formula and chart through selection)
Formulas & functions
* Built-in formulas
-- Math (SUMIFS, AVERAGEIFS, SUMIF, SUM, etc.)
-- Text (CONCATENATE, REGEXMATCH, MID)
-- Date (DATEVALUE, DATEDIF, NOW, WEEKDAY, etc.)
-- Financial (PV, FV, IRR, NPV, etc.)
-- Logical (IF, AND, OR, IFERROR, etc.)
-- Lookup (VLOOKUP, HLOOkUP, INDIRECT, OFFSET, etc.)
-- Dynamic Array (Excel2019 new formulas, SORT,FILTER,UNIQUE,RANDARRAY,SEQUENCE)
* Array (={1,2,3,4,5,6}, Crtl+Shift+Enter)
* Remote formulas (DM_TEXT_TFIDF, DM_TEXT_TEXTRANK,DATA_CN_STOCK_CLOSE etc. Need remote interface, can realize complex calculation)
* Custom (Some formula suitable for use in China have been added. AGE_BY_IDCARD, SEX_BY_IDCARD, BIRTHDAY_BY_IDCARD, PROVINCE_BY_IDCARD, CITY_BY_IDCARD, etc. You can define any formula you want)
Tables
* Filters (Support color , numerical, date, text filtering)
* Sort (Sort multiple fields simultaneously)
Pivot table
* Arrange fields (Add fileds to rows, columns, values, area, it is similar to excel)
* Aggregation (Surport Sum,Count,CountA,CountUnique,Average,Max,Min,Median,Product,Stdev,Stdevp,Var,VarP etc.)
* Filter data (Add fileds to filters area and analyze the desired data )
* Drill down (Double click pivot table cell to drill down for detail data )
* Create a PivotChart (Pivot table can create a chart )
Chart
* Support types (Line, Column, Area, Bar, Pie, comming soon Scatter, Radar, Gauge, Funnel etc.)
* Chart Plugins (Link to another project ChartMix (opens new window)(MIT): ECharts is currently supported,Highcharts, Ali G2, amCharts, googleChart, chart.js are being developed gradually)
* Sparklines (Support by formula : Line, Pie, Box, Pie etc.)
Share
* Comments (Add, delete, update)
* Collaborate (Simultaneous editing by multiple users)
Insert object
* Insert picture (JPG,PNG,SVG and so on)
VeryUtils HTML5 Excel
* Matrix operation (Operate selection through the right-click menu: transpose, rotate, numerical calculation)
* Screenshot (Take a screenshot with selection)
* Copy to (In the right-click menu, copy selection to json, array etc.)
* EXCEL import/export
Keyboard shortcuts
CTRL + C -- Copy cell
CTRL + V -- Paste cell
CTRL + X -- Cut cell
CTRL + Z -- Undo
CTRL + Y -- Redo
CTRL + A -- Select all
CTRL + B -- Bold
CTRL + F -- Find
CTRL + H -- Replace
CTRL + I -- Italic
CTRL + UP/DOWN/LEFT/RIGHT -- Quickly adjust cell marquee
SHIFT + UP/DOWN/LEFT/RIGHT -- Adjust selection area
CTRL + Left mouse click -- Multiple selection cell
SHIFT + Left mouse click -- Adjust selection area
UP/DOWN/LEFT/RIGHT -- Move cell selection box
ENTER -- Edit cell
TAB -- Move cell selection box to the right
DELETE -- Clear cell data
Comments