Spreadsheets News

Import and Export Excel XLSX Using Vue

May 29, 2024
SpreadJS by MESCIUS enables you to drop a fully functioning spreadsheet into your web app, delivering a familiar Excel-like experience to users.

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 Manager Kevin Ashley demonstrates how to enhance an existing Vue app with the ability to import and export XLSX files using SpreadJS. Steps include:

  • Adding SpreadJS to your Vue App
  • Adding Excel Import
  • Adding Excel Export
  • Testing your Vue App

Detailed sample code is included for each step.

View the complete blog and get starting working with Excel files in your Vue applications.

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.

Enhance Angular Spreadsheet Readability

May 28, 2024
Choosing a spreadsheet control with cell formatting support makes your data easier to read, promotes consistency, and enhances user experience.

Cell formatting allows you to customize of the appearance and behavior of individual cells within a spreadsheet or data table to improve readability, comprehension, and accuracy of data presentation. This can encompass adjustments to font style, size, and color, as well as the inclusion of borders, shading, numeric or date formatting, cell alignment and so on. By employing cell formatting, users can significantly enhance the readability and organization of their spreadsheets, allowing for quicker data comprehension and clearer communication of the information they contain. It also helps in distinguishing different types of data, emphasizes important figures, and maintains consistency across related documents, thereby reducing the likelihood of errors and misinterpretations.

Several Angular spreadsheet components support cell formatting, including:

  • SpreadJS by MESCIUS facilitates extensive cell formatting for any cell property allowing Angular developers to create customized spreadsheet solutions.
  • Telerik Excel Export (part of Kendo UI) works with Angular and allows seamless data export to Microsoft Excel, supporting complex cell formatting, alignment, and more.
  • Jspreadsheet Pro offers spreadsheet-like controls tailored for Angular with tools to customize cell appearance, including fonts, colors, and number formats.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) offers an Excel-like interface, providing cell formatting capabilities for dynamic and consistent data presentation.

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

Compare Angular Spreadsheet Controls

Add Spreadsheet Functionality to Your Blazor Apps

May 28, 2024
Telerik UI for Blazor v6.0 (2024 Q2) adds a new spreadsheet component that lets you easily integrate Excel-like capabilities into your apps.

Telerik UI for Blazor is a comprehensive UI library that provides over 110 native Blazor components for building modern and feature-rich web applications. This professional-grade solution offers a complete set of components to satisfy all user interface requirements, saving time and effort in UI design.

The Telerik UI for Blazor v6.0.0 update (part of the 2024 Q2 release) introduces a powerful spreadsheet component, empowering developers to integrate Excel-like functionality seamlessly within Blazor applications. This intuitive interface allows users to view, edit, and manipulate tabular data, complete with formatting options, hyperlink insertion, image embedding, and robust formulas and functions. By eliminating the need for external libraries and streamlining data management through native spreadsheet operations, this update enhances workflow efficiency and application performance.

To see a full list of what's new in 2024 Q2 (v6.0.0), see our release notes.

Telerik UI for Blazor is licensed per developer and is available as a perpetual license with a one year support subscription, which is available in three tiers: Lite, Priority or Ultimate. See our Telerik UI for Blazor licensing page for full details.

Telerik UI for Blazor is available to buy in the following products:

Add the Power of AI to Excel Workbooks

May 21, 2024
Pine AI Excel Add-In v1.4.2 offers expanded input capabilities, enabling Excel formula and VBA code generation from more detailed prompts.

Pine AI Excel Add-In, developed by Pinexl, leverages OpenAI's ChatGPT to provide AI-powered functionalities within Microsoft Excel. This VBA-based add-in caters to both beginner and advanced users by offering formula generation, error correction, and explanation alongside VBA code generation, repair, and description. Pine AI's ability to comprehend user intent and directly analyze data within spreadsheets streamlines data manipulation and automation tasks for Excel users.

The Pine AI v1.4.2 update significantly expands its capabilities for handling complex data and tasks within Excel. The maximum number of characters you can input has been significantly raised for core features, allowing you to tackle more intricate formulas and explanations with the AI Assistant, Formula Explainer, Formula Check, Formula Generator, and VBA Generator. This update expands Pine AI's capabilities, making it an even more powerful tool for developers who want to supercharge their Excel workflow.

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

Pine AI Excel Add-In is licensed per user on an annual subscription basis. To continue using the software you will need an active subscription. See our Pine AI Excel Add-In licensing page for full details.

Learn more on our Pine AI Excel Add-In product page.

Simplify Spreadsheet Navigation with Hyperlinks

May 13, 2024
Choose a React spreadsheet component with hyperlink support to boost user experience with in-cell clickable links for efficient navigation.

Hyperlink support in a spreadsheet control allows developers to integrate clickable links within cells. This functionality offers several advantages: users can seamlessly navigate to external web pages, reference internal documents within the spreadsheet itself (including across worksheets), and launch email compositions directly from specific cells. Hyperlink support enhances user experience by streamlining information access and promoting efficient data exploration within the spreadsheet.

Several React Spreadsheet controls offer Hyperlink support including:

  • SpreadJS by MESCIUS supports hyperlinks in cells, allowing users to link to webpages, email addresses, or other ranges within the spreadsheet.
  • Jspreadsheet Pro allows you to integrate hyperlinks into cells, connecting users to webpages, local files, and other spreadsheet locations.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) enables the creation of interactive spreadsheets with clickable links to external resources and internal data.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) facilitates embedding hyperlinks within cells for seamless navigation.

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

Compare React Spreadsheet Controls