Spreadsheets 뉴스

Excel 통합 문서에 강력한 AI 기능을 추가하세요

5월 21, 2024
Pine AI Excel Add-In v1.4.2는 확장된 입력 기능을 제공하며, 보다 자세한 프롬프트로 Excel 수식 및 VBA 코드를 생성할 수 있습니다.

Pine AI Excel Add-In, developed by Pinexl, leverages OpenAI's ChatGPT to provide AI-powered functionalities within Microsoft Excel. This VBA-based add-in caters to both beginner and advanced users by offering formula generation, error correction, and explanation alongside VBA code generation, repair, and description. Pine AI's ability to comprehend user intent and directly analyze data within spreadsheets streamlines data manipulation and automation tasks for Excel users.

The Pine AI v1.4.2 update significantly expands its capabilities for handling complex data and tasks within Excel. The maximum number of characters you can input has been significantly raised for core features, allowing you to tackle more intricate formulas and explanations with the AI Assistant, Formula Explainer, Formula Check, Formula Generator, and VBA Generator. This update expands Pine AI's capabilities, making it an even more powerful tool for developers who want to supercharge their Excel workflow.

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

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.

하이퍼링크로 스프레드시트 탐색을 단순화하세요

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 내보내기로 데이터 공유를 간소화합니다

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.