Spreadsheets 新闻

用场景自动化增强假设分析

12月 16, 2024
Document Solutions for Excel v8.0.0 引入了对场景假设分析的编程支持，从而提升了 Excel 中的决策功能。

Document Solutions for Excel by MESCIUS is a comprehensive tool designed to streamline the creation, management, and distribution of Excel-based reports and documents. It simplifies tasks such as generating dynamic templates, automating complex data processing workflows, and ensuring consistency across reports. By integrating seamlessly with Excel, it caters to organizations needing efficient, scalable solutions for financial reporting, data analysis, and operational documentation. Its key benefits include reducing manual effort, minimizing errors, and improving productivity, making it ideal for finance teams, analysts, and any professionals managing high-volume data tasks.

The Document Solutions for Excel v8.0.0 update enhances what-if analysis capabilities by introducing programmatic support for scenarios, enabling developers to create, manage, and apply multiple sets of input values to dynamically assess their impact on spreadsheet calculations. This new functionality allows precise control over scenarios, including defining changing cells, locking or hiding scenarios for security, and modifying or deleting them as needed. Developers can seamlessly integrate scenario management into workflows, automate complex forecasting tasks, and ensure secure collaboration on protected worksheets. These enhancements streamline decision-making processes and provide robust tools for developing data-driven applications.

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

Document Solutions for Excel is licensed per developer and is available in several license options for differing distribution needs. Team licenses are also available for multiple developers within the same organization. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Document Solutions for Excel is available to buy in the following products:

利用 AI 翻译电子表格中的单元格内容

12月 12, 2024
Pine AI Excel Add-In 使用户能够在保留数据的原始结构的同时，轻松地在任何语言之间翻译电子表格数据。

Pine AI Excel Add-In, developed by Pinexl, integrates OpenAI's ChatGPT into Microsoft Excel, enabling users to generate, debug, and interpret complex formulas and Visual Basic for Applications (VBA) code by simply describing their requirements. This tool enhances productivity by automating tasks such as data analysis, summarization, transformation, and translation directly within Excel spreadsheets. For instance, users can extract specific information from unstructured data, fill in missing details like country names based on city data, and translate text without leaving the Excel environment. By streamlining these processes, Pine AI reduces the time spent on manual data manipulation and extensive online research, making it a valuable asset for professionals seeking to optimize their workflow within Excel.

Using the Pine AI Excel Add-In, translating spreadsheet cell content is simple and seamless. Users can select the data they wish to translate directly within Excel, specify the target language, and let Pine AI handle the rest. The translated content is generated and placed back into the desired cells, maintaining the original format. This eliminates the need to use external tools, streamlining multilingual workflows and enhancing productivity for data analysis or global collaboration.

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.

将电子表格转换为高质量的 PDF

12月 6, 2024
Spread.NET 18 提供高分辨率 PDF 导出，具有与 Excel 兼容的功能和高级渲染选项。

Spread.NET by MESCIUS is a versatile spreadsheet component for .NET applications, enabling developers to integrate Excel-compatible functionalities into Windows Forms, WPF and ASP.NET. With features like advanced data visualization, pivot tables, conditional formatting, and customizable formulas, Spread.NET handles large data sets efficiently and allows seamless Excel import/export. This tool is ideal for applications needing robust data analytics and reporting, such as financial software and business intelligence solutions, enhancing user experience with a familiar spreadsheet interface.

The Spread.NET 18 update enhances PDF export capabilities by delivering high-resolution outputs with improved image quality and rendering precision. This update aligns closely with Excel-compatible printing features, ensuring accurate representation of rich text, flat style modes, transparent shapes and header/footer images in PDF documents. Developers can now save individual sheets, entire workbooks or directly print to PDF, providing greater flexibility and efficiency. With these improvements, the PDF export functionality meets professional-grade standards, making it a reliable tool for creating polished, high-quality outputs directly from .NET spreadsheets.

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

用 XLSX 导出简化了数据共享

12月 3, 2024
将电子表格数据转换为广泛支持的 Microsoft Excel 文件格式，从而确保跨各种平台的兼容性和易用性

Spreadsheet component with XLSX export functionality allow users to output spreadsheet data into the industry standard Excel-compatible format. This feature is especially useful for applications where data needs to be analyzed, shared, or integrated into external workflows. By enabling XLSX export, users can download structured data directly from the web application in a format widely supported across platforms and software. The benefits of this functionality include maintaining data accuracy, preserving formatting, and supporting large datasets with advanced features like formulas, filters, and charts. Use cases for XLSX export range from financial dashboards and inventory management systems to data analytics platforms and collaborative tools, offering users the flexibility to work offline or share data in a familiar format.

Several React spreadsheet components offer XLSX export, including:

  • Telerik Spreadsheet React (part of KendoReact) lets you effortlessly export your spreadsheet data to XLSX format, ensuring seamless integration with Excel.
  • SpreadJS by MESCIUS allows you to output spreadsheet to XLSX format, enabling flexible data sharing and analysis across various platforms and tools.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers XLSX export, providing a convenient way to share data.

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

Compare React Spreadsheet Controls

用撤消和重做改进电子表格编辑

11月 25, 2024
为 WPF 电子表格应用程序用户提供轻松更正错误和恢复更改的能力。

Undo and redo functionality in a spreadsheet allows users to reverse or reapply actions made during editing, providing a straightforward way to correct mistakes or recover changes. The undo option enables users to step back through recent actions, such as data entry, formatting, or formula adjustments, while redo restores any actions reversed by the undo function. This capability provides a safety net, allowing users to recover from unintended modifications, thereby enhancing productivity as it minimizes errors and streamlines the editing process.

Several WPF spreadsheet components allow you to redo and undo editing changes, including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) lets users undo and redo changes to cells, formulas, and formatting, ensuring flexibility and error recovery.
  • Spread WPF (part of Spread.NET by MESCIUS) facilitates efficient editing and formatting with robust undo/redo capabilities, minimizing the risk of accidental data loss.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) allows you to undo and redo actions efficiently, offering a reliable way to manage iterative adjustments.
  • Syncfusion WPF Spreadsheet (part of Syncfusion Essential Studio Enterprise) offers undo/redo functionality to streamline data editing processes.

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

Compare WPF Spreadsheet Controls