Architecture News

스프레드시트 데이터 구성 및 분석을 향상하세요

10월 11, 2024
필터 및 그룹화와 함께 WinForms 스프레드시트 컨트롤을 사용하면 데이터 포인트를 분리하고 관련 데이터를 분류하여 데이터 세트를 구조화된 명확한 화면에서 볼 수 있습니다.

Data filtering and grouping allow spreadsheet users to efficiently organize and analyze information by categorizing and refining it. Filtering allows users to display only the data that meets specific criteria, reducing irrelevant information and focusing on key data points. Grouping, on the other hand, consolidates related rows or columns, facilitating hierarchical data organization and summarization. Together, these features enhance data manipulation capabilities by simplifying complex datasets, improving readability, and allowing for more efficient data analysis. This functionality supports productivity by providing a more structured view of data, making it easier for developers to interpret and work with extensive datasets.

Many .NET 8 WinForms spreadsheet controls contain data filtering and grouping including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) enables precise data filtering and grouping, allowing seamless organization and focused analysis within your spreadsheet applications.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) provides dynamic data filtering and grouping, enhancing data visibility and enabling efficient, hierarchical organization for streamlined data processing.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) offers robust data filtering and grouping capabilities, helping users to categorize and sort information for improved data analysis.
  • Infragistics WinForms Spreadsheet (part of Infragistics Ultimate UI for Windows Forms) facilitates intuitive data filtering and grouping, supporting efficient data structuring and improved insights through simplified data manipulation.

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

Compare .NET 8 WinForms Spreadsheet Controls

간소화된 데이터 통합으로 생산성을 개선하세요

10월 11, 2024
관계형 데이터베이스와 Excel 스프레드시트 모두에 액세스할 수 있는 통합 인터페이스를 제공하는 Microsoft Excel용 공급자가 UniDAC 10.3.0에 추가됩니다.

Universal Data Access Components (UniDAC) is a comprehensive database access library that provides developers with a unified interface for working with various database systems. It supports a wide range of databases, including popular options like Oracle, SQL Server, MySQL, PostgreSQL, and InterBase. UniDAC simplifies data access operations by offering a consistent API, reducing the need for platform-specific code and enhancing code portability across different database environments.

The UniDAC 10.3.0 release introduces a new provider for Microsoft Excel. This addition offers a unified interface to access both relational databases and Excel spreadsheets, making data integration more efficient and reducing development time. With this feature, data exchange between data sources is now possible, streamlining tasks such as importing, exporting, and manipulating data from Excel in a database-focused environment. This enhancement is useful for applications that rely on both spreadsheets and databases for data management.

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

Universal Data Access Components (UniDAC) is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. See our UniDAC licensing page for full details.

Learn more on our Universal Data Access Components (UniDAC) product page.

동적인 매개변수를 통해 즉각적인 알림을 맞춤설정하세요

10월 11, 2024
Scriptcase 9.11은 즉각적인 업데이트를 제공하여 모든 애플리케이션에서 커뮤니케이션을 단순화하고 사용자 참여를 강화합니다.

Scriptcase is a RAD platform that simplifies PHP web application development. Its drag-and-drop interface, code generation capabilities, and database integration make it a user-friendly tool for both experienced programmers and non-technical users. By streamlining the development process, Scriptcase accelerates the time to market, reduces coding effort, enhances productivity, lowers costs, and improves user experience.

The Scriptcase 9.11 release offers a new Notifications Module that is fully integrated with the Security Module. This allows users to send and receive personalized, real-time notifications across devices via a responsive menu. Each notification triggers a non-intrusive toast alert, ensuring users stay informed without disrupting usability. The module also includes a powerful notification macro, enabling developers to send customized notifications with dynamic parameters for efficient, real-time communication. This combination enhances user engagement, improves control, and simplifies the delivery of critical updates, providing a seamless and responsive notification system across all platforms.

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

Scriptcase is licensed per developer and is available as an Annual or Perpertual license with 1 year support and maintenance. See our Scriptcase licensing page for full details.

For more information, visit our Scriptcase product page.

멀티 뷰(Multi-View) 기능으로 차트를 혁신하세요

10월 11, 2024
Stimulsoft BI Server 2024.4.1은 단일 요소에서 여러 차트 화면을 볼 수 있어 데이터 명확성을 개선하고 대시보드 디자인을 간소화합니다.

Stimulsoft BI Server is a comprehensive client-server Business Intelligence solution designed for reporting and analytics. The front end offers powerful data visualization capabilities, while the back end handles data processing and storage. It can function as a standalone report server or be embedded into other systems. The software includes a range of features such as report creation and editing, secure storage, scheduling, and automated delivery to clients.

The Stimulsoft BI Server 2024.4.1 release introduces the ability to create multiple Views within a single dashboard chart element, allowing up to five different charts to be displayed in one location. With this enhancement, the view name can now serve as the element title, automatically updating as users switch between different views. This feature, which can be enabled via the 'Show Title' parameter, offers greater flexibility, reduces dashboard clutter, and improves data clarity by ensuring each chart view is clearly labeled, providing a more streamlined and intuitive user experience.

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

Stimulsoft BI Server is available as a perpetual license and is licensed per creator. A creator has an account on the server, has access from the client-side, registered as an editor, and uses the product to work with report templates and dashboards - create, edit, view, delete, etc. See our Stimulsoft BI Server licensing page for full details.

Stimulsoft BI Server is available in the following products:

JavaScript를 사용하여 URL의 Excel XLSX 파일을 읽을 수 있습니다

10월 11, 2024
MESCIUS의 SpreadJS를 사용하면 지정된 URL의 Excel 파일을 JavaScript 웹 애플리케이션으로 직접 가져올 수 있습니다.

SpreadJS by MESCIUS is a high-performance JavaScript spreadsheet component designed to seamlessly integrate Excel-like functionality into web applications. It empowers developers to deliver robust spreadsheet experiences within their applications, complete with features like data import/export, complex formulas, conditional formatting, and extensive customization options. SpreadJS caters to a wide range of use cases, from financial modeling and data analysis to project management and interactive dashboards, ultimately allowing developers to build feature-rich and user-friendly web applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz demonstrates how to leverage the SpreadJS JavaScript spreadsheet API to effortlessly import and read Excel files from designated URLs. Steps include:

  • Creating a JavaScript Spreadsheet application
  • Fetching XLSX from the URL and Returning the File as a Blob
  • Reading the Excel File Blob and Importing it into the JS Spreadsheet Instance

Detailed JavaScript and HTML code is included to help you along.

Read the complete blog and learn how to integrate a spreadsheet component into your web applications without the need for an external program.

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.

For more information, visit our SpreadJS product page.