.NETのニュース

.NETアプリケーションでスプレッドシートデータ分析を高速化

9月 5, 2024
EPPlus v7.3.0では、より複雑な統計演算や数学演算を可能にする新機能が追加され、数式計算機能が向上

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.3.0 update introduces four new functions that are supported in formula calculations, enhancing the library's capability for data analysis within Microsoft Excel spreadsheets. The GROWTH function enables exponential growth calculations, while DPRODUCT allows the multiplication of values in a field of a list or database based on specified criteria. The DSTDEV and DSTDEVP functions calculate the standard deviation of values in a field within a list or database, but they differ in their scope. DSTDEV is for samples, while DSTDEVP is used for entire populations. These functions allow developers to perform more complex statistical and mathematical operations directly within spreadsheet documents, significantly improving the efficiency of data-driven applications.

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

ユーザーがPDFに直接コメントを追加可能

9月 5, 2024
付箋の注釈を使用すると、ユーザーはPDFファイルの特定のセクションにコメントしたり、質問したりして、チームメンバーとコミュニケーションをとることが可能

Sticky note annotations are digital notes that can be attached to specific parts of a document or webpage. They allow users to highlight text, add comments, or ask questions directly on the content they are viewing. This feature is particularly useful for collaboration, as it enables multiple people to contribute to the same document and easily see each other's thoughts and insights. Sticky note annotations can also be used for personal reference, helping users to remember important points or track their progress through a document.

Several ASP.NET Core PDF viewer controls offer support for sticky note annotations including:

  • Document Solutions for PDF by MESCIUS empowers users to add comments and reminders directly on PDFs with digital sticky notes.
  • ImageGear for .NET by Accusoft allows for attaching interactive sticky notes to PDFs, streamlining information sharing and review.
  • Syncfusion ASP.NET Core PDF facilitates in-document annotation using digital sticky notes for collaborative editing and feedback.

For an in-depth analysis of features and price, visit our ASP.NET Core PDF viewer controls comparison.

Compare ASP.NET Core PDF Viewer Controls

ユーザーによる印刷出力の制御を許可

9月 4, 2024
.NET WPFの印刷とプレビューコントロールを使用すると、ユーザーはアプリケーションから印刷する前に、ページレイアウト、余白、およびその他の設定を調整可能

Print & Preview .NET WPF controls provide a comprehensive solution for printing and previewing content within your WPF applications. These controls offer a user-friendly interface for users to review their content before committing to printing, ensuring accuracy and preventing costly errors. Additionally, they support various printing options, including page orientation, margins, and scaling, allowing developers to customize the printing experience to meet specific requirements.

Many .NET WPF UI Suites contain Print & Preview controls including:

For an in-depth analysis of features and price, visit our comparison of .NET WPF UI Suites.

Compare .NET WPF UI Suites

ダイアログ・フォームを使用してレポートパラメータを設定

9月 3, 2024
直感的なフォームを備えた.NETコンポーネントを使用してレポートアプリを作成し、ユーザーがデータを選択し、分析用のレポート出力をカスタマイズ可能

Dialog forms for parameters in .NET reporting components offer a user-friendly interface for defining and modifying report parameters. By providing intuitive input fields, drop-down menus, and browsing options, these forms simplify the report creation process and reduce the likelihood of errors. This is particularly beneficial for non-technical users, who can easily generate customized reports without requiring extensive knowledge of report syntax or data structures. Example use cases include creating sales reports based on specific product categories or time periods, generating financial statements with customizable filters, and producing personalized customer reports based on individual preferences.

Several .NET reporting components allow you to create dialog forms for parameters, including:

  • DevExpress Reports (Multi-Platform) (part of DevExpress Reporting) empowers users to define report parameters through intuitive dialog forms, streamlining report generation.
  • ActiveReports.NET by MESCIUS simplifies report creation with user-friendly parameter dialogs, enabling selection from defined options.
  • Telerik Reporting facilitates interactive report parameter definition via dialog forms, enhancing the user experience.
  • Stimulsoft Reports.Net allows users to effortlessly set report parameters with clear and concise dialog forms.

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

Compare .NET Reporting Components

データの傾向やパターンを表示

8月 30, 2024
折れ線グラフを使用して、進化するデータポイントを視覚的に表現し、特定の期間に値がどのように変化するかを直感的に理解可能

Line charts are visual representations of data points connected by lines, often used to illustrate trends, patterns, or changes over time. They are particularly effective for displaying continuous data sets, such as stock prices, temperature variations, or sales figures. By connecting data points, line charts provide a clear and intuitive understanding of how values evolve over a specific period. This visual representation aids in identifying trends, making comparisons, and predicting future outcomes.

Several Blazor chart controls offer line charts including:

  • DevExpress Blazor Chart (part of DevExpress ASP.NET and Blazor) lets you create customizable line charts for data visualization.
  • ComponentOne Charts for Blazor (part of ComponentOne Blazor Edition by MESCIUS) allows you to design interactive line charts with ease.
  • Telerik Blazor Chart (part of Telerik UI for Blazor) facilitates the creation of visually appealing line charts with various customization options.
  • Syncfusion Blazor Chart (part of Syncfusion Essential Studio Enterprise) provides a high-performance line chart component for Blazor applications.

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

Compare Blazor Chart Controls