.NETのニュース

.NET WPFで複数選択 UI を有効化

3月 22, 2024
チェックされたコンボボックスデータエディタコントロールにより、エンドユーザーはドロップダウンリストから複数のオプションを簡単に選択可能

Checked combobox controls are data editor user interface elements that allow users to select multiple options from a dropdown list while visually indicating their choices through checkboxes. These controls provide developers with a convenient way to implement multi-select functionality within their applications, enhancing the user experience by offering intuitive selection methods. By integrating checked combobox controls, developers can streamline data entry processes, improve usability, and increase productivity within their software applications, ultimately leading to more efficient and user-friendly interfaces.

Many .NET WPF Data Editor collections contain checked combobox components including:

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

Compare .NET WPF Data Editors

ヒートマップでデータ関係を可視化

3月 22, 2024
ユーザーは、色の強度を使用してデータセット内の大きさを表す2つの変数の傾向を簡単に識別可能

A heatmap is a data visualization tool that uses color intensity to represent magnitude within a dataset. This allows for quick identification of patterns and trends across two variables, depicted on the map's axes. Heatmaps are valuable for analyzing geographic data, user website interaction, and any other scenario where you need to visually grasp the distribution of data points.

Several Blazor chart controls offer Heatmaps including:

  • ComponentOne Charts for Blazor (part of ComponentOne Studio Blazor Edition by MESCIUS) empowers Blazor apps with interactive heatmaps for data exploration.
  • FusionCharts Blazor Suite XT provides a rich set of heatmap chart types for versatile data presentation.
  • Syncfusion Blazor Chart (part of Syncfusion Essential Studio Enterprise) offers comprehensive heatmaps with customization options for clear data visualization.
  • Infragistics Blazor Charts (part of Infragistics Ignite UI) facilitates creating heatmaps with conditional formatting to highlight specific data ranges.

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

Compare Blazor Chart Controls

アプリに高度な計算機能を追加

3月 22, 2024
Document Solutions for Excel APIは、組み込みのExcel関数による高度なデータ分析で.NETアプリケーションを強化

Document Solutions for Excel, .NET Edition (DsExcel, previously GcExcel) is a high-speed, small-footprint, server-side spreadsheet API that requires no dependencies on Excel. With full .NET support, you can generate, load, modify, and convert spreadsheets in .NET, .NET Framework, .NET Core, Mono, and Xamarin. Apps using the spreadsheet API can be deployed to cloud, Windows, Mac, or Linux. Its powerful calculation engine and breadth of features means you'll never have to compromise design or requirements. The interface-based API is modeled on Microsoft Excel's document object model which means you can import, calculate, query, generate, and export any spreadsheet scenario.

Formulas and functions play an important role in data analysis. Microsoft Excel provides a range of functions that simplify the extraction of key metrics during data analysis. In this pair of blog posts from MESCIUS, Software Engineer Prabhat Sharma demonstrates how to use DsExcel to implement Excel functions and other Excel-like functionalities.

Part 1 of the blog shows you how to drill into sales data and integrate the following functions:

  • LOOKUP and Reference Functions
  • FILTER Function
  • TRANSPOSE Function

Part 2 of the blog digs into monthly budget data to show you how to use:

  • SUBTOTAL
  • CHOOSEROWS/CHOOSECOLS
  • SUMIF/AVERAGEIF
  • PMT/PPMT/IPMT
  • IF combined with AND/OR

Document Solutions for Excel is licensed per developer for either one distribution location or unlimited distribution locations. Licenses are perpetual, and include a one year subscription for all software releases (including hotfixes and major releases) plus Platinum Support. See our Document Solutions for Excel, .NET Edition licensing page for full details.

Learn more about Document Solutions for Excel, .NET Edition.

スプレッドシートをプログラムで操作

3月 21, 2024
LEADTOOLS v23では、評価の高いDocument SDKテクノロジーに基づいて構築された新しいExcel APIとExcel Web Editorを追加

LEADTOOLS Document Suite is a comprehensive set of powerful document imaging SDKs designed to facilitate document processing and management tasks within software applications. It offers developers advanced capabilities for tasks such as OCR (Optical Character Recognition), barcode recognition, PDF manipulation, document conversion, annotation, and more. Leveraging this suite, developers can seamlessly integrate sophisticated document functionality into their software solutions, enabling efficient handling of various document formats and improving productivity in document-centric workflows.

The LEADTOOLS Document Suite SDK v23 update ushers in a new era of streamlined document management and enhanced productivity. The integration of the Excel API and Excel Web Editor empowers developers to seamlessly manipulate Microsoft Excel documents directly within their applications, regardless of platform. The Excel API offers programmatic control over Excel files, enabling efficient extraction, modification, and creation, while the Excel Web Editor fosters real-time collaborative editing within web applications. These powerful additions not only streamline document workflows but also equip developers with a comprehensive suite of Excel editing functionalities within the LEADTOOLS Document Suite ecosystem.

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

LEADTOOLS Document Suite SDK is licensed as Development Licenses, for developers to use the SDKs, and Deployment Licenses, for the right to distribute end user solutions. See our LEADTOOLS Document Suite SDK licensing page for full details.

Learn more on our LEADTOOLS Document Suite SDK product page.

データ検証を.NET 8スプレッドシートに追加

3月 21, 2024
データ検証ツールが組み込まれたスプレッドシートアプリケーションを開発して、エラーの防止、データ品質の維持、データ分析の合理化を実現

Data validation is a crucial feature for maintaining the integrity of data within a spreadsheet. It restricts the type of data or the values that users can enter into a cell. For example, a cell can be configured to only accept dates or numbers within a certain range. This minimizes input errors and ensures that data adheres to specified parameters, which is particularly important in scenarios where spreadsheets are used for data entry by multiple users or when the data feeds into critical business processes.

Several .NET 8 spreadsheet products offer data validation, including:

  • DevExpress Office File API (Spreadsheet Document API) is a high performance API for managing spreadsheet data in Microsoft Excel documents, supporting .NET 8 and offering data validation functionality.
  • Telerik Spread Processing (part of the Telerik UI product range) is a document processing library that supports .NET 8 and streamlines spreadsheet management, enabling data validation to ensure compliant input.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) provides data validation features to ensure data accuracy in desktop .NET 8 spreadsheet applications.
  • IronXL by Iron Software is a C# library for working with Excel files, without requiring Microsoft Office or Excel Interop, that supports .NET 8 and offers data validation for controlling data types and values in Excel files.

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

Compare .NET 8 Spreadsheet Controls