Spreadsheets 뉴스

.NET 스프레드시트 앱에서 피벗 테이블을 계산하세요

7월 2, 2024
EPPlus v7.2.0에 피벗 테이블에서 데이터를 계산하고 가져오는 기능에 대한 지원이 추가되어 .NET 개발자가 프로그램에서 직접 데이터를 생성할 수 있습니다.

EPPlus is a powerful and versatile .NET library for managing and manipulating Microsoft Excel files using the Office Open XML (OOXML) format. It is a lightweight and efficient library that is easy to use and can be integrated into a wide range of applications. It allows developers to create, read and modify spreadsheets without dependencies on any other library. Features include pivot tables, styling, VBA/Form controls, conditional formatting, charts, tables, formula calculation, data validation, pictures/shapes, and more.

The EPPlus v7.2.0 update adds support for calculating and fetching data from pivot tables, allowing .NET developers to enhance the data analysis capabilities of their applications. This feature allows developers to dynamically summarize, analyze, and present large datasets by creating and manipulating pivot tables programmatically. It includes the ability to define calculations (sum, average, etc.) for rows and columns, format values as percentages or differences, and apply various filters (captions, numbers, dates, etc.) and sorting options. This streamlines data analysis workflows and fosters greater control over the final spreadsheet output, empowering developers to deliver more powerful data-driven solutions.

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

EPPlus is licensed per developer and is available as both perpetual licenses and subscription based licenses with periods of 1 year and 2 years, which include support and upgrades. See our EPPlus licensing page for full details.

For more information, see our EPPlus product page.

조건부 서식으로 인사이트를 강조 표시하세요

6월 19, 2024
조건부 서식을 지원하는 ASP.NET Core 스프레드시트 컨트롤을 사용하면 데이터, 중요한 문제, 패턴, 추세를 더 쉽게 분석할 수 있습니다.

Conditional formatting in a spreadsheet component allows you to dynamically alter the visual appearance of cells based on predefined rules. This functionality enhances data readability by highlighting specific values or trends within your spreadsheet. By visually differentiating critical information, conditional formatting empowers developers to create more user-friendly and informative data presentations within their ASP.NET applications.

Several ASP.NET Core Assembly Spreadsheet Controls offer Conditional Formatting including:

  • DevExpress ASP.NET Core Spreadsheet (part of DevExpress for ASP.NET) integrates conditional formatting for visually distinct data.
  • Telerik Spread Processing (part of Telerik UI for ASP.NET Core) provides developers with programmatic control of conditional formatting for tailored user experiences.
  • IronXL by Iron Software simplifies data interpretation with conditional formatting features that elevate spreadsheet clarity.
  • Infragistics ASP.NET Core Spreadsheet (part of Infragistics Ignite UI) integrates user-defined conditional formatting rules to enhance data readability in web applications.

For an in-depth analysis of features and price, visit our comparison of ASP.NET Core Assembly Spreadsheet Controls.

Compare ASP.NET Core Assembly Spreadsheet Controls

Python 프로젝트에 Excel 기능을 통합하세요

6월 18, 2024
IronXL for Python via .NET은 Python 개발자가 스프레드시트 기능을 애플리케이션에 통합할 수 있도록 지원하는 Excel 라이브러리입니다.

IronXL for Python via .NET by Iron Software is a Python Excel library designed to enable Python developers to manipulate, read and generate Microsoft Excel files easily by leveraging the .NET framework. It allows them to integrate Excel functionality into Python applications without requiring Microsoft Office or Excel Interop to be installed on the server or client machines. This standalone solution provides a comprehensive API for reading, creating, and editing Excel files (XLS, XLSX, XLSM, CSV, TSV, etc.) directly from Python code.

IronXL offers a compelling alternative for developers seeking an efficient and versatile solution for spreadsheet manipulation in Python environments. It facilitates the automation of report generation, data analysis, and financial modeling, all within a familiar Excel format but executed through Python scripts. It simplifies complex tasks like data import/export, formatting control, and chart generation, making it ideal for automating spreadsheet-related workflows across various industries, from data analysis and reporting to financial modeling and content generation. The use cases for IronXL span various industries including finance, research, education, and healthcare, where users need to merge, split, and export data while maintaining the integrity and formatting of their spreadsheets.

IronXL for Python via .NET is licensed based on the number of developers, organization locations and projects, and is available as a perpetual license with one free year of product updates and support services. See our IronXL for Python via .NET licensing page for full details.

For more information, see our IronXL for Python via .NET product page.

스프레드시트에서 중요한 정보를 계속 볼 수 있도록 고정하세요

6월 7, 2024
고정 창(freeze pane) 지원을 통해 대량의 데이터를 스크롤하는 동안 필수적인 행 또는 열을 참고로 확인할 수 있어 데이터 분석 경험이 개선됩니다.

Spreadsheet controls with freeze pane support enable developers to lock specific rows or columns in place while allowing the rest of the data to scroll freely. This feature enhances the user experience by keeping headers or key reference data visible at all times, thus improving navigation and readability in large datasets. It is particularly beneficial for applications where users need to compare data across extensive spreadsheets, ensuring that critical information remains accessible without disrupting the workflow. This functionality contributes to a more efficient and user-friendly interface, reducing the cognitive load on users and facilitating better data analysis.

Several JavaScript spreadsheet controls offer freeze pane support including:

  • Telerik Spreadsheet jQuery (part of Kendo UI and Telerik DevCraft) allows you to keep headers visible while scrolling, enhancing data navigation and user experience.
  • SpreadJS by MESCIUS, facilitates fixed rows or columns for seamless data comparison and improved spreadsheet navigation in large datasets.
  • Jspreadsheet Pro lets you freeze panes to maintain visibility of crucial headers or columns, streamlining data management and analysis.
  • Infragistics Spreadsheet jQuery (part of Infragistics Professional) enables users to lock key rows or columns, ensuring important data stays visible during extensive scrolling.

For an in-depth analysis of features and price, visit our comparison of Compare JavaScript Spreadsheet Controls.

Compare JavaScript Spreadsheet Controls

수식과 함수를 이용하여 간단하게 계산하세요

5월 31, 2024
수식과 함수를 지원하는 React 스프레드시트 컨트롤을 사용하면 브라우저 내에서 직접 실시간 동적 데이터 분석 및 조작이 가능합니다.

React spreadsheet controls with formula and function capabilities bring the power of spreadsheets to modern web applications. These components allow users to enter data, manipulate it using built-in formulas (like SUM or AVERAGE) or custom functions, and see the results dynamically update within the web interface. This empowers developers to create interactive data analysis tools, financial calculators, or even planning dashboards directly within their React applications.

Several React spreadsheet controls offer formula and function support including:

  • Telerik Spreadsheet React (part of KendoReact) enables complex formula calculations and function execution directly within cells for dynamic, interactive data analysis.
  • Wijmo FlexSheet (part of Wijmo from MESCIUS) offers extensive formula support, allowing users to perform comprehensive calculations and data manipulation within spreadsheets.
  • Jspreadsheet Pro provides robust formula capabilities, facilitating advanced mathematical, logical, and text functions for enhanced data processing in the browser.
  • Infragistics Spreadsheet React (part of Infragistics Ignite UI) supports a wide range of functions and formulas, enabling real-time calculations and sophisticated data analysis.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers extensive formula and function support, allowing easy data manipulation.

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

Compare React Spreadsheet Controls