Spreadsheetsのニュース

ハイパーリンクでスプレッドシートのナビゲーションを簡素化

5月 13, 2024
ハイパーリンクをサポートするReactスプレッドシートコンポーネントを選択すると、セル内のクリック可能なリンクでユーザーエクスペリエンスが向上し、効率的なナビゲーションが可能

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

PinexlがComponentSourceに参加

5月 9, 2024
ComponentSourceはPinexlと提携して、分析とデータの視覚化にAIを活用するMicrosoft Excel向けのアドインを提供

ComponentSource, a leading global provider of software components and development tools, has announced a new partnership with Pinexl, a company that specializes in creating premium Microsoft Excel-based tools that cater to both small and large businesses. These tools are designed to offer powerful insights while maintaining an intuitive interface, making them accessible for all levels of technical proficiency. Pinexl's products stand out for their professional, minimalist visualizations and the simplicity they bring to complex data analysis tasks. This collaboration aims to bring sophisticated data visualization and analytics capabilities to a wider audience.

Pine AI Excel Add-In is an AI-powered add-in that leverages ChatGPT technology to boost your Excel productivity. It can generate custom formulas, write VBA code, and even describe existing formulas in plain English. This alleviates the need for extensive formula knowledge and streamlines complex tasks, making it ideal for both Excel beginners and advanced users seeking to optimize their workflow.

Pine BI Excel Add-In is a premium add-in designed to revolutionize data visualization. With just a click, you can transform your spreadsheets into modern, dynamic dashboards, complete with advanced charts. Pine BI empowers you to create clear and impactful reports, enhancing communication and data storytelling for any data-driven task.

Through this strategic partnership, ComponentSource enhances its extensive offering of Add-ins for Microsoft Office, further cementing its position as a trusted provider of reliable and efficient solutions for developers, backed by guaranteed support.

For more information, explore the Pinexl product range.

XLSX Exportでデータ共有をシンプルに

5月 8, 2024
スプレッドシートアプリケーションから使い慣れた広く使用されている形式にデータを簡単にエクスポートして、追加の分析や操作を行うことが可能。

Spreadsheet components with XLSX export functionality allow developers to seamlessly save spreadsheet data and formatting from their application as a Microsoft Excel compatible file. This functionality provides significant benefits such as increased data portability for users who can then open and edit the spreadsheets in Excel, and improved collaboration as data can be easily shared and worked on across different platforms.

Several WPF spreadsheet controls offer the ability to export XLSX files including:

  • DevExpress WPF Spreadsheet (part of DevExpress WPF) empowers you to export spreadsheets to customizable XLSX files.
  • Spread WPF (part of Spread.NET by MESCIUS) enables seamless data visualization and export to editable XLSX spreadsheets.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) offers an intuitive API for exporting data directly to XLSX format.
  • Infragistics WPF Spreadsheet (part of Infragistics Ultimate UI for WPF) facilitates exporting data to XLSX files, preserving formatting for easy analysis.

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

Compare WPF Spreadsheet Controls

Apple NumbersグラフをExcelに統合

5月 7, 2024
Aspose.Cells 24.4を使用すると、Apple Numbersで作成されたグラフをExcel XLSXにエクスポートできるため、開発者のクロスプラットフォーム互換性が向上します。

Aspose.Cells is a software development toolkit that empowers developers to work with spreadsheets directly within their applications. It provides functionalities like creating, editing, converting, and rendering spreadsheets in various formats (including Excel, CSV, and PDF) without requiring Microsoft Excel to be installed. This allows developers to seamlessly integrate spreadsheet manipulation into their programs, enhancing their capabilities.

The Aspose.Cells for C++ and Aspose.Cells for Python via .NET 24.4 releases add support for exporting charts from Apple Numbers files to XLSX. This allows developers to seamlessly integrate chart data created in Numbers into Excel spreadsheets, streamlining workflows and data exchange between macOS and Windows environments.

To see a full list of what's new in Aspose.Cells version 24.4, see our C++ and Python via .NET release notes.

Aspose.Cells is offered as Developer Small Business, Developer OEM, Site Small Business, and Site OEM licenses catering to a range of business needs. Licenses are perpetual, and include 1 year of support and maintenance. Subscription renewals are also available. See our Aspose.Cells licensing pages for C++ and Python via .NET for full details.

Aspose.Cells for C++ is available to buy in the following products: Aspose.Cells for C++, Aspose.Cells Product Family, Aspose.Total for C++, and Aspose.Total Product Family.

Aspose.Cells for Python via .NET is available to buy in the following products: Aspose.Cells for Python via .NET, Aspose.Cells Product Family, Aspose.Total for Python via .NET, and Aspose.Total Product Family.

他のワークシートからスプレッドシートデータへのアクセス

4月 30, 2024
ワークシート間の計算により、複雑な操作の簡素化、データ分析の有効性の強化、情報に基づいた意思決定が容易になります。

Cross-worksheet calculations involve using formulas within spreadsheet applications to reference and manipulate data across multiple worksheets within the same workbook. This allows you to consolidate and analyze information from various sections of your spreadsheet without consolidating it into a single worksheet. The ability to carry out such calculations simplifies complex operations enhances the efficiency and effectiveness of data organization and analysis.

Several React spreadsheet components support cross-worksheet calculations, including:

  • Telerik Spreadsheet React (part of KendoReact) offers your applications seamless cross-worksheet formula support, enhancing productivity by enabling consolidated analysis across your spreadsheets.
  • Wijmo FlexSheet (part of Wijmo by MESCIUS) supports nearly 100 formulas and facilitates dynamic inter-sheet operations, allowing users to efficiently perform calculations and manage data across worksheets within your React applications.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) provides your React projects with cross-worksheet formula capabilities so you can leverage data from various sheets for comprehensive analysis and dynamic calculations.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) features a powerful React spreadsheet component with built-in cross-worksheet formula functionalities, enabling you to efficiently combine and analyze data from separate sheets.

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

Compare React Spreadsheet Components