Architecture News

앱에 고급 계산 기능을 추가하세요

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.

프록시를 통한 Greenplum 성능 향상

3월 22, 2024
Heimdall Database Proxy for Greenplum은 애플리케이션과 Greenplum 사이에 배포되어 쿼리 응답 시간을 최적화합니다.

Heimdall Database Proxy intelligently manages connections for improved response times and database scale. Features include query caching, read/write splitting and connection pooling.

The new Heimdall Database Proxy for Greenplum offers developers enhanced optimization capabilities tailored for Greenplum databases. Greenplum is an open-source, massively parallel processing (MPP) database designed for large-scale data warehousing and analytics. With seamless integration, Heimdall Database Proxy for Greenplum improves query performance, reduces latency, and streamlines database operations. Advanced caching and intelligent query routing ensure faster execution and efficient resource utilization, enhancing application responsiveness and scalability. Comprehensive monitoring tools enable quick identification and resolution of performance issues. Overall, this edition simplifies database management, allowing developers to focus on building robust applications confidently.

Heimdall Database Proxy for Greenplum is licensed on an annual subscription basis, priced per Greenplum CPU core. The initial license fee covers up to 90 Greenplum CPU cores, additional CPU core licenses can be added as required. See our Heimdall Database Proxy licensing page for full details.

Learn more on our Heimdall Database Proxy product page.

스프레드시트를 프로그래밍 방식으로 조작할 수 있습니다

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

사용자가 그리드 모양을 맞춤설정할 수 있도록 지원합니다

3월 21, 2024
사용자 지정 가능한 테마를 통해 사용자가 그리드의 디자인을 맞춤설정할 수 있으므로 보다 매력적이고 사용자 친화적인 경험을 제공할 수 있습니다.

Customizable themes allow users to easily modify the visual appearance of a grid. This typically encompasses aspects like background colors, font styles, cell borders, and hover effects. These themes offer numerous benefits including improving the grid's readability and user experience by aligning it with the application's overall design aesthetic, enhancing data visualization by using color-coding or conditional formatting, and supporting accessibility needs by incorporating high-contrast themes.

Several Vue.js grid controls offer customizable theme support, including:

  • DevExtreme HTML5 JavaScript Data Grid (part of DevExtreme Complete by DevExpress) empowers you to design grids with custom themes for a seamless user experience.
  • Kendo UI for Vue Grid (part of Kendo UI by Telerik) enables customization of grid themes, tailoring the look and feel to perfectly match your application.
  • DataViewsJS by MESCIUS facilitates the creation of visually appealing grids with custom themes, enhancing interactivity with your data.
  • ZingGrid allows you to craft unique grid presentations through customizable themes, ensuring a distinctive visual style.
  • SmartClient Grid by Isomorphic Software facilitates the development of feature-rich grids with customizable themes, providing a solution for complex data visualization.

For an in-depth analysis of features and price, visit our comparison of Vue.js Grid controls.

Compare Vue.js Grid Controls