.NETのニュース

.NET 8スプレッドシートでのデータ管理の強化

8月 30, 2024
.NET 8スプレッドシートアプリケーションに検索と置換の機能を追加すると、生産性と一貫性が向上し、エラーを軽減

Find and replace is a useful feature found in spreadsheet applications that allows users to quickly locate specific values, i.e. text, numbers, or formulas, identifying all instances of that search term within a spreadsheet and then being able to replace them with a new value. By automating the process of manually searching for and modifying each occurrence individually, find and replace enhances productivity, reduces the likelihood of human error, and ensures consistency throughout the spreadsheet. This functionality is especially beneficial for tasks that involve managing large volumes of data, updating outdated information, correcting mistakes, or standardizing data formats.

Several .NET 8 spreadsheet components allow you to find and replace, including:

  • DevExpress WinForms Spreadsheet enhances data management in .NET 8, facilitating find and replace operations via the user interface or directly in code.
  • Telerik WPF Spreadsheet (part of Telerik UI for WPF) allows you to efficiently locate and replace content using find and replace in .NET 8 spreadsheet applications.
  • IronXL by Iron Software is a library that supports .NET 8 and offers several cell range functions including find and replace for Microsoft Excel spreadsheets.
  • MindFusion.Spreadsheet for WPF can provide spreadsheet applications in .NET 8 with intuitive find-and-replace capabilities for consistent and accurate data manipulation.

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

Compare .NET 8 Spreadsheet Components

図形のハイパーリンクでWord文書を向上

8月 28, 2024
Word 7.2のドキュメントソリューションは、プログラムによってハイパーリンクプロパティを図形に追加することで、対話型のWord文書を作成可能

Document Solutions for Word by MESCIUS is a comprehensive software development toolkit designed to facilitate the creation, manipulation, and management of Microsoft Word documents within various applications. It offers a robust API that provides developers with granular control over document structure, formatting, and content, enabling the integration of Word document functionality into custom applications. Key features include support for advanced formatting options, document automation, and compatibility with various Word document formats.

The Document Solutions for Word 7.2 release enables developers to enhance the interactivity of Word documents by programmatically adding hyperlink properties to shapes. You can now seamlessly link shapes to specific URLs, documents, or email addresses. By leveraging these properties, developers can create dynamic and engaging Word documents that respond to user actions, providing a more interactive and immersive experience.

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

Document Solutions for Word 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. Visit our Document Solutions for Word licensing page to see more information regarding licenses.

Document Solutions for Word is available to buy in the following products:

Excel関数をWebアプリケーションに実装

8月 28, 2024
LEADTOOLS Excel Web Editorを使用して、XLS/XLSXファイルをプログラムでロードおよび保存

LEADTOOLS Document SDK is ideal for developing document and document imaging applications. Features include PDF viewing, comprehensive annotation and markup, specialized bitonal image displaying, and image processing. Other features include performance and memory optimizations for bitonal images, document image cleanup, including inverted text, border, hole-punch, and line removal, and scanning with LEADTOOLS Fast TWAIN and WIA. The LEADTOOLS Excel SDK - included in the Document SDK - gives developers the power to load, create, edit, and save Excel sheets programmatically.

In this blog post (the second in a 3-part series on the Excel SDK), LEADTOOLS Associate Marketing Web Developer Ryan Fritz shows you how to use the new Excel Web Editor to load an XLS/XLSX file, implement a common Excel function, and then save the updated file.

Read the complete blog and learn how to give your web applications this powerful and useful capability.

LEADTOOLS Document 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 SDK licensing page for full details.

Learn more on our LEADTOOLS Document SDK product page.

ぼかしとピクセル化で画像の創造性を向上

8月 27, 2024
Document Solutions for Imaging 7.2は、強力な新しいぼかしツールとピクセル化ツールを使用して、画像に芸術的な効果を加えること可能

Document Solutions for Imaging by MESCIUS is a comprehensive software development toolkit designed to facilitate the manipulation and management of image files within various applications. It offers a robust API that provides developers with granular control over image properties, formats, and rendering, enabling the integration of image processing functionality into custom applications. Key features include support for a wide range of image formats, image editing operations, and optimization techniques for efficient image handling.

The Document Solutions for Imaging 7.2 release introduces enhanced image processing capabilities with the addition of new Blur and Pixelate functionality. These tools can be applied to selected areas, allowing developers to precisely control image manipulation and maintain the integrity of the remaining image content. This feature empowers developers to create visually appealing image-based applications.

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

Document Solutions for Imaging is licensed per developer and is available in several license options for differing distribution needs. Team licenses are available for multiple developers within the same organization. Visit our Document Solutions for Imaging licensing page to see the full details.

Document Solutions for Imaging is available to buy in the following products:

AIで強化した数式を使って、スプレッドシートをアップグレード

8月 23, 2024
AIを使って定義した数式を、DevExpress WinForms Spreadsheetで高度に計算

DevExpress DXperience is a comprehensive software development suite designed to enhance productivity and streamline the creation of high-performance applications across various platforms. It offers a wide range of tools and components for developers working with .NET frameworks including Windows Forms, WPF, ASP.NET, and Blazor as well as JavaScript, Angular, React, Vue, and jQuery. The suite includes powerful UI controls, data visualization tools, reporting capabilities, and cross-platform libraries that enable developers to build modern, responsive, and visually appealing applications efficiently.

In this blog post, DevExpress's Maria Nikulina shows you how to integrate OpenAI services with the DevExpress WinForms Spreadsheet Control (included with DXperience) to implement user-defined formulas for advanced calculations. These formulas let you automate repetitive tasks, efficiently analyze data, and execute advanced calculations not possible with built-in functions.

Steps include:

  • Setting up the DevExpress WinForms Spreadsheet Control
  • Setting up the OpenAI Client
  • Creating a User-Defined Function
  • Registering the Custom Function
  • Using the Custom Function within the Spreadsheet

Detailed sample code is included.

Read the complete blog to learn how to take Excel formula calculations to a whole new level by integrating AI services.

DevExpress DXperience is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our DevExpress DXperience licensing page for full details.

The DevExpress WinForms Spreadsheet Control is available to buy in the following products: