Spreadsheetsのニュース

画像統合によるスプレッドシートデータをエンリッチ

1月 8, 2025
画像を埋め込むと、スプレッドシートデータの視覚化が強化され、意思決定のためのより明確な洞察とより豊かなコンテキストを提供

英語で読み続ける:

Image support within a spreadsheet component allows developers to seamlessly integrate and manipulate images directly within the spreadsheet environment, enabling features such as inserting, resizing, positioning, and formatting images within cells or as background elements. By embedding images alongside numerical or textual data, users can enhance data visualization, streamline report generation, and provide richer context for decision-making, ultimately improving communication and enabling more effective data analysis within applications.

Several WinForms spreadsheet components support inserting images, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) seamlessly integrates and manipulates images directly within your spreadsheets.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) enhances the visual impact of your spreadsheets with the ability to insert, resize and format images alongside your data.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) adds a new dimension to your data analysis by embedding images within your spreadsheets.
  • MindFusion.Spreadsheet for WinForms by MindFusion Group allows you to use images to create a clear and informative vision of your spreadsheet data.

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

Compare WinForms Spreadsheet Controls

スピル範囲自動化でフォーミュラを簡素化

1月 7, 2025
DevExpress Office File APIは、スピル範囲のサポートを追加し、スプレッドシートワークフローを合理化し、データ操作効率を向上

英語で読み続ける:

The DevExpress Office File API is a robust library designed to simplify the creation, editing, and processing of popular office document formats, including Word, Excel, PowerPoint, and PDF. It allows developers to integrate advanced document management features into their applications without relying on external software like Microsoft Office. Key features include document generation, data import/export, template customization, and seamless integration with modern platforms. The API supports advanced formatting, encryption, and digital signatures, ensuring secure and professional-grade output. Ideal for enterprise applications, it streamlines workflows for reporting, data analysis, and document automation, saving time and enhancing productivity for developers and end-users alike.

The DevExpress Office File API v24.2 update introduces support for dynamic array formulas, enabling developers to enhance spreadsheet functionality with automated formula calculations that dynamically spill into adjacent cells. This update simplifies data manipulation by allowing efficient recalculations, importing, and exporting of Excel documents with dynamic array formulas. Developers gain precise control through APIs that manage dynamic array formulas programmatically, identify spill ranges, and customize behavior to suit specific application needs. This capability not only streamlines complex data workflows but also ensures seamless compatibility with modern Excel features, offering greater flexibility and efficiency in application development.

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

DevExpress Office File API is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our DevExpress Office File API licensing page for full details.

DevExpress Office File API is available individually or in the following products:

AIを活用した分析でスプレッドシートを強化

12月 23, 2024
Pine AI細胞分析ツールを使用すると、ワークブックのデータを分析し、リクエストを指定して、結果をセルに直接取得できます。

英語で読み続ける:

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.

Pine AI's data analysis functionality has been separated into two tools; Range Analysis and Cell Analysis. The Range Analysis tool is the data analysis function of the preceding Data Analysis tool, allowing you to evaluate and summarize a range of cells. The Pine AI Cell Analysis tool allows you to analyze individual cells, make requests on that data, and have the findings returned directly to another cell in the same or a new worksheet within your current active workbook. Use Pine AI Cell Analysis to extract strings from text, obtain additional information based on cell values, and even translate cell content into any language.

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.

新しいDataChartsアドオンでチャート作成を簡素化

12月 19, 2024
SpreadJS v18では、チャートを外部データにバインドするための新しいオプションのアドオンが導入され、動的で柔軟なスプレッドシートの視覚化が可能になります。

英語で読み続ける:

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. To extend its capabilities, SpreadJS offers a variety of optional add-ons, such as tools for reporting, charting, and data management. 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.

SpreadJS v18 introduces the DataCharts Add-On, a powerful new feature that lets you bind charts directly to external data managed by the Data Manager, eliminating the need to embed data within the workbook. This innovation streamlines workflows by reducing redundancy, simplifying updates, and enabling dynamic charting for both standalone spreadsheets and reports. For users of the ReportSheets Add-On, the DataCharts Add-On is seamlessly integrated, enhancing report creation with interactive, data-driven visuals. Developers seeking a flexible solution for external data visualization in other contexts can license the DataCharts Add-On separately, making it ideal for projects that demand adaptable, visually engaging charts.

For more information 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.

シナリオ自動化によるWhat-If分析の強化

12月 16, 2024
Document Solutions for Excel v8.0.0では、シナリオを使用したwhat-if分析のプログラムによるサポートが導入され、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: