Tag: #javascript
10 articles
-
VLOOKUP, XLOOKUP and SUMIFS in a JavaScript spreadsheet
An order sheet that prices and totals itself: pull unit prices out of a product master with VLOOKUP and XLOOKUP, handle the codes that aren't there, then roll the lines up by category with SUMIF, SUMIFS and COUNTIFS β including the criteria syntax and the two lookup functions ReoGrid Web does not have.
-
Wareki Dates and β² Negatives β Excel Number Format Codes in a JavaScript Spreadsheet
Japanese government and finance forms don't accept 什ε1εΉ΄ β they want 什εε εΉ΄. Here's how Excel's number format codes work in ReoGrid Web: era tokens g/gg/ggg and e/ee, the [$-ja-JP-x-gannen] locale tag, bracket colors in English and Japanese, conditional sections, and the β² negative convention accounting departments expect.
-
Generate PDF Invoices in the Browser β One Template, Any Data, No Server
A PDF invoice pipeline that never leaves the browser: design the form once with {{token}} cells, bind a plain data object so the detail band repeats per line item, then export a real vector PDF with saveAsPdf. Page breaks, headers, footers, per-row formulas, and a batch loop that turns one template into a hundred documents.
-
Pivot Tables in a JavaScript Spreadsheet β Live Cross-Tab Summaries in a Few Lines
Turn a few hundred rows of raw records into a cross-tab summary that recomputes as the data changes. One createPivot call declares rows, columns, and aggregations; the handle's update / refresh / remove drive it from code. A full worked example with region Γ product sales, plus filters, grand totals, and the Lite-vs-Pro line.
-
Sort & Filter a JavaScript Spreadsheet β Excel-Style AutoFilter, by Click and in Code
Add Excel-style column sorting and header-dropdown filters to a data table in the browser. One createAutoFilter call gives users the dropdowns; getColumnValues / setColumnFilter drive the same filters from code. A full worked example with a live visible-row counter, plus the sort-vs-filter and Lite-vs-Pro details.
-
Stop Bad Data at the Cell β Data Validation in a JavaScript Spreadsheet
Dropdown lists, numeric and date bounds, custom formula checks β reject invalid input the moment it's typed, with zero form-validation code. A full order-entry example using ReoGrid Web's Excel-style data validation, including input prompts, error alerts, and xlsx round-trip.
-
Convert XLSX to JSON in the browser β no server, no upload
Turn an .xlsx file into JSON entirely client-side: lossless ReoGrid JSON for round-tripping, or plain data rows for your app. Practical code, files never leave the browser.
-
Traffic-Light Dashboards in a JavaScript Spreadsheet β Conditional Formatting by Example
Color-code a spreadsheet by its values β red stock warnings, green over-target sales, status-tinted rows β without writing a single styling loop. A full worked example using ReoGrid Web's three conditional-formatting rule types, with live re-evaluation as data changes.
-
One million rows in a browser spreadsheet β without loading one million rows
Three weeks ago we wrote that a million rows was out of scope for ReoGrid Web. We changed our mind. Here's the delay-load data source: a scrollbar that represents 1,000,000 rows while the grid holds only the few hundred you can actually see.
-
Reading and writing Excel files in JavaScript β import, export, and JSON
How to load .xlsx files into the browser, export a grid back to Excel, and convert between xlsx and JSON β all client-side, with styles and formats preserved. Practical code with ReoGrid Web.