JavaScript / HTML5 News

Import and Export Excel XLSX Files in JavaScript

December 5, 2023

Use SpreadJS by MESCIUS to add complete JavaScript Spreadsheets to your Enterprise Apps.

SpreadJS is a complete enterprise JavaScript spreadsheet solution used to create financial reports and dashboards, budgeting and forecasting models, scientific, engineering, healthcare, education, science lab notebooks, and other similar JavaScript business applications. Spreadsheets are a primary medium for displaying and sharing vital company data and it is crucial that this data can be easily viewed and updated in your JavaScript applications.

In this blog post, MESCIUS Product Manager Kevin Ashley shows you how to leverage the power of SpreadJS to import and export Excel spreadsheets into your enterprise web applications. Steps include:

Setting up the JavaScript Spreadsheet Project
Adding Excel Import Code
Adding Data to the Imported Excel File
Adding a Sparkline
Adding Excel Export Code

View the complete blog and start working directly with Excel files in your JavaScript applications.

For more information visit our SpreadJS product page.

Make your Grids and Spreadsheets More Accessible

December 5, 2023

Handsontable 14.0.0 improves screen reader support and adds new keyboard shortcuts to help make navigation more intuitive and inclusive.

Handsontable is a JavaScript data grid component that provides a spreadsheet-like user experience for web applications. It allows developers to easily integrate data tables into their web pages, enabling users to manipulate data in a familiar and intuitive way.

Handsontable V14 now meets Web Content Accessibility Guidelines (WCAG) 2.1 AA standards, making it easier for people with disabilities to use the grid. This release also enhances screen reader compatibility by incorporating ARIA attributes into the HTML markup, ensuring seamless navigation for users of NVDA and JAWS on Windows, and VoiceOver on macOS.

To see a full list of what's new in version 14.0.0, see our release notes.

For more information, visit our Handsontable product page.

Select and Input Colors in Vue Apps

December 4, 2023

Color pickers empower users to choose and apply colors seamlessly across designs and user interfaces.

A color picker is a graphical tool that allows users to select colors from a palette or by adjusting different color parameters. Color pickers are commonly found in graphics software, web development tools, and design applications. They are used to ensure accurate and visually appealing color choices in various creative and technical projects. Color pickers provide an intuitive way to select precise colors, commonly by using sliders for RGB values or hex codes.

Several Vue.js data editor collections provide color pickers including:

DevExtreme Complete Data Editors (part of DevExtreme Complete by DevExpress) offers a user-friendly interface for selecting colors, including predefined color palettes.
Wijmo Input and Editors (part of Wijmo by MESCIUS) provides a comprehensive color selection experience with features like color sliders and color swatches.
Kendo UI for Vue Data Editors (part of Kendo UI by Telerik) delivers a customizable color picker solution with options for popup placement, palette customization, and accessibility support.
jQWidgets Data Editors (part of jQWidgets) features a versatile color selection mechanism with support for various color formats and color presets.
Syncfusion Essential Studio Data Editors (part of Syncfusion Essential Studio Enterprise) offers a rich set of color selection capabilities, including color sliders and color eyedroppers.

For an in-depth analysis of features and price, visit our Vue Data Editors comparison.

Compare Vue Data Editors Components

Enhance Analytics with Angular Chart Trend Lines

December 1, 2023

Provide a visual representation of the overall direction of chart data, helping users identify trends and patterns.

Trend lines are a chart feature used to indicate patterns or trends in data over time. Common examples include linear, exponential, polynomial, logarithmic, and moving average. Trend lines are crucial for making predictions or understanding the direction of data points in scatter plots and line charts, helping make data-driven decisions.

Several Angular chart components provide trend line support including:

Highcharts Stock by Highsoft features various trend line types and customization options.
Wijmo FlexChart and FinancialChart (part of Wijmo by MESCIUS) includes trend lines for analyzing and visualizing data trends.
amCharts 5: Stock Chart offers a variety of trend line types and advanced analytical features.
AnyStock JS by AnyChart provides rich trend line customization and predictive analysis capabilities.
JSCharting supports trend lines with a variety of line fit variations.

For an in-depth analysis of features and price, visit our Angular Chart Component comparison.

Compare Angular Chart Components

How to Save Searches in Grids

November 29, 2023

Use Isomorphic Software's SmartClient to save search preferences, instead of repeating the same process time after time.

SmartClient is a comprehensive JavaScript component suite compatible with React, Vue, Angular, and more, that empowers you to craft large-scale, high-productivity Enterprise web applications. Its modern class system fosters clean encapsulation of application modules and screens, resulting in a more maintainable and comprehensible codebase.

In this blog post, Alex Fashakin demonstrates how to use SmartClient's built-in feature to save search preferences on grids. Steps include: