Spreadsheets News

Read Excel XLSX Files from a URL Using JavaScript

October 11, 2024
SpreadJS by MESCIUS enables you to directly import Excel files from specified URLs into your JavaScript web applications.

SpreadJS by MESCIUS is a high-performance JavaScript spreadsheet component designed to seamlessly integrate Excel-like functionality into web applications. It empowers developers to deliver robust spreadsheet experiences within their applications, complete with features like data import/export, complex formulas, conditional formatting, and extensive customization options. SpreadJS caters to a wide range of use cases, from financial modeling and data analysis to project management and interactive dashboards, ultimately allowing developers to build feature-rich and user-friendly web applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz demonstrates how to leverage the SpreadJS JavaScript spreadsheet API to effortlessly import and read Excel files from designated URLs. Steps include:

  • Creating a JavaScript Spreadsheet application
  • Fetching XLSX from the URL and Returning the File as a Blob
  • Reading the Excel File Blob and Importing it into the JS Spreadsheet Instance

Detailed JavaScript and HTML code is included to help you along.

Read the complete blog and learn how to integrate a spreadsheet component into your web applications without the need for an external program.

SpreadJS is licensed per developer and includes 1 Year Maintenance (major and minor version releases and unlimited support phone calls). SpreadJS requires an Annual or Perpetual Deployment License. The optional Add-ons are available at an additional cost, and require a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

Generate AI Prompts Directly into Spreadsheets

October 1, 2024
Jspreadsheet Pro incorporates ChatGPT API into data grids, facilitating efficient response management and comprehensive data analysis.

Jspreadsheet Pro is a flexible JavaScript-based spreadsheet solution that enables developers to create customizable, feature-rich data grids for web applications. It offers advanced formulas, data validation, and API integrations. Ideal for tasks like financial modeling, inventory management, and project tracking, it helps businesses efficiently manage and analyze data. Its backend server integration supports real-time data processing, enhancing workflows and boosting productivity across various industries.

Jspreadsheet Pro seamlessly incorporates ChatGPT API into data grids. This integration facilitates automated content generation, efficient response management, and comprehensive data analysis. For full functionality it requires the Jspreadsheet Server extension which enables front-end queries to communicate with the API via your back-end, delivering real-time data and insights to users.

Jspreadsheet Pro is licensed as an Annual or a Perpetual License with support and maintenance. We can supply any Jspreadsheet Pro license including new licenses, maintenance renewals, and upgrade licenses. See our Jspreadsheet Pro for full details.

For more information, visit our Jspreadsheet Pro product page.

Precisely Place Cell Images for Polished Presentation

September 26, 2024
Spread.NET v17.2 empowers users to fit, fill or customize image placement in cells, bringing flexibility and precision to spreadsheet display.

Spread.NET by MESCIUS is a powerful tool for building Excel-like applications in your .NET projects. It lets you create interactive spreadsheets, grids, dashboards, and even forms within WinForms, ASP.NET, and WPF applications. With its rich feature set, including a robust calculation engine, formula support, and Excel compatibility, Spread.NET empowers developers to build data analysis tools, budgeting apps, scientific dashboards, and more, all within the familiar .NET environment.

The Spread.NET v17.2 release introduces greater cell image versatility and customization. With four new distinct sizing options—Fit, Fill, Original, and Custom—users gain precise control over how images are displayed within cells. The Fit mode maintains the image's aspect ratio while ensuring it fits within the cell, preventing distortion. The Fill option covers the entire cell, disregarding the aspect ratio for full coverage. Original preserves the image's natural size, even if it exceeds the cell's dimensions, while Custom allows users to set specific height and width parameters. These flexible sizing options enhance the presentation of images, offering tailored solutions to fit various content needs, whether it’s for data visualization, design, or reporting purposes. This feature significantly improves visual control, ensuring consistency and a professional appearance across documents.

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

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.

Incorporate Charts in JavaScript Spreadsheet Apps

September 24, 2024
Use JavaScript spreadsheet controls with built-in chart functionality to analyze and present data in a visually appealing way.

JavaScript spreadsheet controls with built-in chart features enable developers to visualize data directly within web-based spreadsheet applications. These charts are generated dynamically from the data within the spreadsheet, providing users with a more intuitive way to analyze and interpret complex datasets. By integrating charting capabilities, developers can offer real-time data visualization without relying on external libraries, resulting in more efficient user experiences. This functionality improves data-driven decision-making, enhances user engagement, and reduces the complexity of handling complex datasets in web applications.

Several JavaScript spreadsheet controls offer charts including:

  • SpreadJS by MESCIUS allows you to seamlessly integrate dynamic charts into spreadsheets, enabling advanced data visualization and analysis.
  • Jspreadsheet Pro lets you create interactive charts within your spreadsheet, simplifying data insights and enhancing user interaction.
  • Infragistics Spreadsheet React (part of Ignite UI by Infragistics) facilitates real-time chart generation directly from spreadsheet data for improved decision-making.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise Edition) enables embedded charting to visualize spreadsheet data with minimal coding.

For an in-depth analysis of features and price, visit our comparison of JavaScript Spreadsheet controls.

Compare JavaScript Spreadsheet controls

Boost Spreadsheet Data Analysis in .NET Applications

September 5, 2024
EPPlus v7.3.0 adds new functions to enable more complex statistical and mathematical operations, elevating its formula calculation capabilities.

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The EPPlus v7.3.0 update introduces four new functions that are supported in formula calculations, enhancing the library's capability for data analysis within Microsoft Excel spreadsheets. The GROWTH function enables exponential growth calculations, while DPRODUCT allows the multiplication of values in a field of a list or database based on specified criteria. The DSTDEV and DSTDEVP functions calculate the standard deviation of values in a field within a list or database, but they differ in their scope. DSTDEV is for samples, while DSTDEVP is used for entire populations. These functions allow developers to perform more complex statistical and mathematical operations directly within spreadsheet documents, significantly improving the efficiency of data-driven applications.

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

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.