Spreadsheets 뉴스

C# .NET에서 XLSX를 PDF, 이미지, JSON 또는 HTML로 내보낼 수 있습니다

8월 2, 2024
Document Solutions for Excel, .NET Edition의 강력한 기능을 활용하여 프로그래밍 방식으로 Excel 보고서를 여러 형식으로 내보낼 수 있습니다.

Document Solutions for Excel, .NET Edition is a high-speed, small-footprint, server-side spreadsheet API that requires no dependencies on Excel. The interface-based API is modeled on Excel's document object model which means you can import, calculate, query, generate, and export any spreadsheet scenario. Using DsExcel, you can programmatically create Excel reports, sorted and filtered tables, sorted and filtered pivot tables, dashboard, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an image format.

In this blog post, MESCIUS Software Engineer Prabhat Sharma demonstrates the exporting capabilities of the DsExcel API including exporting Excel XLSX to formats such as PDF, image, JSON, and HTML. Source code is included for each step, showing you how to use Document Solutions to export reports in each format.

Read the complete blog and learn how to make your data more accessible and versatile.

Document Solutions for Excel, .NET Edition 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.

Learn more on our Document Solutions for Excel, .NET Edition product page.

셀 내용에 대한 추가 정보를 제공하세요

7월 26, 2024
주석을 활용하면 스프레드시트를 복잡하게 만들 수 있는 보충 정보, 컨텍스트, 설명을 간단하게 제공할 수 있습니다.

Spreadsheet cell comments/tooltips, provide a way to display additional information on hover over a specific cell. This enhances the user experience by offering context beyond the cell's main value. Common use cases include displaying formulas used for calculations, extended data not suitable for the main view, or data validation rules. They improve spreadsheet clarity and reduce the need for separate documentation or cluttered cell content.

Several .NET WPF Spreadsheet controls offer cell comments/tooltips including:

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

Compare .NET WPF Spreadsheet Controls

VBA 코드가 포함된 XLSM 파일을 관리하세요

7월 17, 2024
Excel을 사용할 필요 없이 .NET 스프레드시트 애플리케이션에서 Microsoft Excel 매크로 및 VBA(Visual Basic for Applications) 코드를 유지 관리할 수 있습니다.

.NET spreadsheet components with VBA code and macro support empower developers to integrate existing Excel automation functionalities within their applications. This unlocks the benefits of the .NET framework, enhancing performance, security, and scalability of spreadsheet operations. Developers can access, modify, and save embedded VBA scripts, ensuring seamless operation in environments that support VBA execution. This fosters continued automation and functionality even when legacy systems or non-VBA-enabled environments are involved, while also enabling code updates, debugging, and preparation for code-execution-friendly settings.

Several .NET spreadsheet components offer VBA code/macro support, including:

  • Aspose.Cells for .NET is an Excel spreadsheet programming API that allows you to modify macros and VBA code in the template file to streamline spreadsheet tasks in .NET apps.
  • Document Solutions for Excel, .NET Edition by MESCIUS allows users to load and save macro-enabled XLSM files.
  • EPPlus is a .NET library for managing Office Open XML spreadsheets. It is capable of creating, reading, deleting, and modifying VBA code.
  • Infragistics Excel Framework (part of Infragistics Ultimate UI for Windows Forms) supports workbooks in XLSM format with VBA code, enhancing .NET application development.

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

Compare .NET Spreadsheet Components

사용자가 워크시트 간에 쉽게 전환할 수 있도록 지원하세요

7월 8, 2024
탭을 사용하면 스프레드시트 사용자가 데이터 세트 간에 빠르게 이동할 수 있으며, 여러 데이터 섹션을 시각적으로 명확하게 구분할 수 있습니다.

Worksheet tabs act as a visual and interactive index, enabling users to seamlessly navigate between distinct sections within a single workbook. This efficient organization facilitates data comparison and analysis. The clear visual distinction between tabs reduces cognitive load and enhances comprehension, making it easier for users to grasp the overall structure and navigate the information within the workbook.

Several React Spreadsheet controls offer support for tabs including:

  • Telerik Spreadsheet React (part of KendoReact) enables users to effortlessly navigate between spreadsheets through designated tabs.
  • SpreadJS by MESCIUS empowers developers with tabbed navigation for efficient data organization within their React applications.
  • Infragistics Spreadsheet React enables users to effortlessly navigate between spreadsheets through designated tabs.
  • Syncfusion Spreadsheet JavaScript provides tab-based navigation for a familiar and user-friendly experience when working with multiple sheets.

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

Compare React Spreadsheet Controls

계산하는 동안 스프레드시트의 응답성을 유지하세요

7월 3, 2024
가장 복잡한 데이터를 처리하는 도중에도 스프레드시트 성능을 유지하는 데 도움이 되는 증분 계산이 SpreadJS 17.1.0에 도입되었습니다.

SpreadJS by MESCIUS is a JavaScript library offering a comprehensive spreadsheet solution for enterprise web applications. It delivers an Excel-like user experience with features like data tables, extensive charting, formatting options, and a powerful formula engine supporting over 500 functions. SpreadJS integrates with popular frameworks like React, Angular, and Vue.js, enabling developers to build high-performance, customizable spreadsheet functionalities within their web applications.

The SpreadJS v17.1 release enables incremental computation, which breaks down the entire calculation into pieces during execution. This enables responsiveness to user actions when the calculation task is large, preventing the UI from being unresponsive when a workbook has many formulas. Developers will only need to set the incrementalCalculation attribute of the Workbook class to true. This computation procedure is also displayed in the status bar.

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

Learn more on our SpreadJS product page.