Spreadsheets 新闻

将类似 Excel 的功能区添加到您的 .NET 电子表格

1月 2, 2024
Spread.NET 17 带有一个新的功能区控件，让您将上下文选项卡、按钮和菜单添加到您的电子表格应用程序。

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 release adds a new Ribbon control to modernize your spreadsheet's look and feel. Inspired by Excel, this intuitive interface organizes commands into clear, contextual tabs and groups, making it easy for users to find the tools they need. This modern upgrade not only boosts productivity but also brings a familiar feel to your spreadsheets, streamlining the entire user experience.

To see a full list of what's new in version 17, 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.

在 JavaScript 中创建甘特计划应用程序

12月 27, 2023
SpreadJS 17 引入了 GanttSheet 可选插件，提供具有甘特图行为的数据绑定 DataTable 视图和电子表格 UI。

SpreadJS by MESCIUS is a powerful JavaScript library that lets you build Excel-like spreadsheets within your web applications. It offers tables, charts, formulas, pivot tables, and more, all running within the browser. It works with major frameworks like Angular, React, and Vue, and offers Excel file import and export. SpreadJS empowers developers to create interactive dashboards, analyze data, and streamline workflows, all within the familiar spreadsheet interface.

The SpreadJS 17 release introduces the optional GanttSheet Add-On, a full Gantt implementation that works inside of SpreadJS. It seamlessly integrates with your existing spreadsheets, transforming them into clear and concise Gantt charts. This allows you to visualize tasks, dependencies, and progress at a glance, identifying potential bottlenecks and adjust schedules proactively. GanttSheet offers a flexible and intuitive may to manage tasks, sort data, customize calendar settings, and even import/export plans for smooth collaboration.

To see a full list of what's new in version 17, 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 GanttSheet Add-On is available at an additional cost, and requires a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

在 WinForms 应用程序中将电子表格导出为 CSV

12月 21, 2023
导出为 CSV 可解锁通用兼容性，并简化跨平台和跨应用程序的数据共享。

The ability to export to comma-separated values (CSV) from a spreadsheet control enhances interoperability and data accessibility. It seamlessly translates spreadsheet data into the ubiquitous CSV format, fostering effortless integration with a vast ecosystem of analytical tools, databases, and third-party applications. This democratizes your data, empowering users to leverage existing workflows and external expertise, enriching analysis, and maximizing the reach and impact of your data-driven insights.

Several WinForms spreadsheet components provide CSV export functionality, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) supports precision-tuned CSV exports with customizable formatting, separators, and macros.
  • Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio) offers flexible CSV export with support for custom delimiters, headers, and intelligent filters.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) provides CSV export with support for selected ranges and high performance even with large datasets.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) allows you to craft complex multi-sheet exports with cell mapping, macros, and conditional formatting for enhanced clarity.

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

Compare WinForms Spreadsheet Components

在 Angular 电子表格应用程序中过滤和分组数据

12月 19, 2023
数据过滤和分组使电子表格用户能够轻松高效地管理和分析大型数据集。

Data filtering and grouping are key spreadsheet features that allow users to manage and analyze large datasets efficiently. Filtering enables users to hide data that does not meet certain criteria, making it easier to focus on relevant information. Grouping clusters related data together, which can then be summarized with functions such as sum, average, and count. These features are vital for working with extensive spreadsheets, enabling users to simplify their view, and gain insights from specific subsets of data.

Several Angular Spreadsheet components provide data filtering and grouping support including:

  • Jspreadsheet Pro supports navigating large datasets with ease using multi-level filtering and summarize key trends with dynamic group summaries.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio) allows you to gain insights and enhance understanding with nested grouping.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) lets you simplify data exploration with drag-and-drop grouping and aggregate functions for instant summaries.
  • SpreadJS by MESCIUS supports crafting precise filters using advanced formulas and grouping data by multiple criteria for deeper analysis.

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

Compare Angular Spreadsheet Components

在 React 电子表格应用中验证数据

12月 15, 2023
通过提高准确性并防止错误和不一致，数据验证有助于提高生产力。

Data Validation is a crucial feature for maintaining the integrity of data within a spreadsheet. It restricts the type of data or the values that users can enter into a cell. For example, a cell can be configured to only accept dates or numbers within a certain range. This minimizes input errors and ensures that data adheres to specified parameters, which is particularly important in scenarios where spreadsheets are used for data entry by multiple users or when the data feeds into critical business processes.

Several React Spreadsheet components provide data validation support including:

  • Jspreadsheet Pro implements custom data validation rules and error messages for robust data entry.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio) provides comprehensive data validation features, including highlighting invalid data.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) offers flexible data validation options, enabling developers to enforce data integrity in React applications.
  • SpreadJS by MESCIUS supports a variety of data validation rules, ensuring data accuracy and consistency within React spreadsheets.

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

Compare React Spreadsheet Components