Spreadsheetsのニュース

フラットファイルをインタラクティブなスプレッドシートに変換

9月 16, 2025
CSVファイルをスプレッドシートコンポーネントにインポートすると、ユーザーは使い慣れたインターフェイスを使用してプレーンテキストデータを操作、フォーマット、分析可能

Importing CSV files in spreadsheet components allows developers and end-users to load tabular data from simple text-based formats into an interactive grid. The feature typically supports reading CSV with various delimiters, optional headers, and options about how to treat quoted text, line endings, and text formatting. It provides a bridge between raw data sources (spreadsheets exported from other tools, logs, exports from databases) and richer in-browser or in-application editing, formatting, analysis, or further exporting. For many applications, being able to accept CSV imports is essential for interoperability, ease of data ingestion, and enabling users without deep technical skills to bring their data into a system.

Several React spreadsheet controls offer the ability to import CSV files including:

  • SpreadJS by MESCIUS lets you import CSV files directly into the spreadsheet, preserving data formatting, formulas, and structure for immediate editing.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) allows you to load CSV files into interactive sheets.
  • Jspreadsheet Pro facilitates easy CSV file import, instantly converting raw data into an editable spreadsheet with sorting, filtering, and customization options.

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

Compare React Spreadsheet Controls

セル内データ入力で編集を高速化

9月 5, 2025
スプレッドシートで直接迅速な修正や詳細な調整を行い、データの精度とワークフローの効率を制御可能

In-cell data editing allows information to be modified directly within a spreadsheet cell rather than through separate forms or dialog boxes. This approach speeds up data entry, provides immediate visual feedback, and makes it easier to spot and correct mistakes in context. It enhances efficiency by reducing interruptions, lowering cognitive effort, and offering a familiar Excel-style experience. Common use cases include updating financial figures, adjusting inventory records, or revising project timelines where quick, accurate edits are essential.

Several JavaScript spreadsheet controls support in-cell data editing including:

  • Telerik Spreadsheet React lets users edit data directly within spreadsheet cells, enabling quick adjustments, streamlined workflows, and accurate real-time updates.
  • Wijmo FlexSheet by MESCIUS allows direct in-cell editing, giving developers Excel-like functionality with efficient data entry, contextual corrections, and improved productivity.
  • Jspreadsheet Pro enables in-cell editing within modern web applications, offering instant changes, enhanced usability, and efficient management of large datasets.
  • Infragistics Spreadsheet Angular facilitates editing directly in grid cells, supporting faster updates, reduced errors, and seamless interaction with surrounding dataset context.

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

Compare JavaScript Spreadsheet Controls

AIを使用してJavaScriptスプレッドシートを強化

9月 3, 2025
MESCIUS CodeClinicウェビナーでは、SpreadJSの新しいAIアシスタントアドオンをご紹介

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. Leverage the high-speed calculation engine with over 500 Excel built-in functions in 19 languages, to deliver true Excel-like spreadsheet experiences with zero dependencies on Excel.

On August 21st, MESCIUS hosted a CodeClinic for the Developer Preview of the SpreadJS AI Add-on. Product Manager Chris Bannon demonstrated how to enhance your JavaScript spreadsheet applications with natural language formula generation, intelligent PivotTable creation, and AI-powered worksheet functions - all integrated directly into the spreadsheet UI.

The webinar includes the following key takeaways:

  • Use AI to generate and explain existing spreadsheet formulas.
  • Have AI generate PivotTables to give meaningful analysis to large datasets.
  • User AI within cells to do things like transition, gauge sentiment, and ask prompts based on spreadsheet data.

Watch the Webinar On-Demand and get ready to bring the power of AI to your JavaScript Spreadsheets.

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.

スプレッドシートを正確に印刷およびエクスポート

8月 26, 2025
最新のスプレッドシートコンポーネントは、印刷とエクスポートを正確に制御し、形式間でレイアウト、書式設定、データの整合性を維持

Spreadsheet components in modern UI frameworks offer robust capabilities for exporting and printing data, enabling users to take structured, interactive grid content and transform it into static or sharable formats. These features are crucial in enterprise applications, where end users often need to generate reports, export analysis results, or share datasets in widely recognized formats. Whether integrated into financial dashboards, inventory systems, or business intelligence tools, export and print functionalities ensure that grid data remains portable, consistent, and accessible across various workflows and platforms.

Common features include:

  • Exporting to CSV format allows for quick export of raw tabular data, preserving the structure of the spreadsheet while maintaining compatibility with most spreadsheet tools and data processing platforms.
  • Exporting to HTML provides a way to preserve the visual layout and styling of the spreadsheet for embedding in web-based documents or reports.
  • Exporting to JSON supports integration with APIs and back-end systems, making it easier to serialize grid data for programmatic use.
  • Exporting to Microsoft Excel (XSLX) retains advanced formatting, formulas, and multi-sheet structures, providing easy interoperability with the Excel desktop and web apps.
  • Image export captures a visual snapshot of the spreadsheet, useful for presentation slides or visual documentation where editable data is not required.
  • PDF export delivers a print-ready, paginated view of spreadsheet content with options for customizing headers, footers, fonts, and layout.
  • Printing support lets users generate hard copies or digital prints with configurable page settings, headers, and footers, often matching what is seen on screen.

For an in-depth analysis of features and price, visit our ASP.NET Core spreadsheet components comparison.

Explore ASP.NET Core File Export and Printing Features

LAMBDA関数をセル選択に直接適用

8月 15, 2025
SpreadJS 18.2では、選択したセルに対してLAMBDA数式を実行し、1つのステップで置き換えるための新しい変換コマンドを追加

SpreadJS is a high-performance JavaScript spreadsheet and data presentation component designed for enterprise web applications. It enables developers to deliver Excel-like functionality directly within their web solutions, providing advanced features such as data binding, complex calculations, pivot tables, charts, and extensive formatting options. Fully compatible with modern JavaScript frameworks like React, Angular, and Vue, SpreadJS allows seamless integration and customization, empowering development teams to create interactive, data-driven user experiences without relying on external spreadsheet applications.

The SpreadJS 18.2 adds a new Transform command which enables you to apply LAMBDA functions directly to a selected range of cells and replace the original content with calculated results. This simplifies data transformations - whether mapping, filtering, or reshaping - into a clean, single-step process. With this feature, you can select any range and apply a custom LAMBDA formula - for example, converting units, adjusting values, or formatting entries - and have SpreadJS overwrite the selection with the computed results immediately. This removes manual steps like inserting formulas in separate cells, copying values, or pasting back as values. This feature integrates with SpreadJS’s existing LAMBDA capabilities to offer more interactive and efficient spreadsheet manipulation.

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

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.