Spreadsheets 뉴스

Java 앱에 Excel XLSX API 라이브러리를 추가하세요

10월 18, 2024
Document Solutions for Excel, Java Edition을 사용하면 Java 애플리케이션에서 Excel 통합 문서를 열고, 업데이트하고, 저장할 수 있습니다.

Document Solutions for Excel, Java Edition is a high-speed Java Excel spreadsheet API library that that enables you to programmatically create, edit, import, and export Excel XSLX spreadsheets from Java applications. Develop in Java for Windows, Linux, and Mac and deploy to the Cloud, including Azure, AWS, and AWS Lambda. The interface-based API is modeled on Excel's document object model, which means you can import, calculate, query, generate, and export any spreadsheet scenario, create full reports, sort/filter tables, sort/filter pivot tables, dashboard reports, add charts, sparklines, conditional formats, import and export Excel templates and also convert spreadsheets to PDF, HTML, or an Image type.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz takes you through the steps for adding an Excel API to your Java application, including:

  • Creating a Java Application Including the Java Excel API
  • Creating Excel Tables Using the ITable Interface, which includes...
    • Initializing Table Data
    • Adding the Excel Tables
    • Applying Table Formulas
    • Setting the Table's Row Height and Column Width
  • Saving the Java Excel Workbook

Detailed instruction and sample code are included.

Read the full blog to learn how to deploy spreadsheets at scale across Java applications.

Document Solutions for Excel, Java Edition 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. See our Document Solutions for Excel, Java Edition licensing page for full details.

Learn more on our Document Solutions for Excel, Java Edition product page.

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

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

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.

AI 프롬프트를 스프레드시트에 직접 생성하세요

10월 1, 2024
Jspreadsheet Pro는 ChatGPT API를 데이터 그리드에 통합하여 효율적인 응답 관리와 포괄적인 데이터 분석을 촉진합니다.

Jspreadsheet Pro is a flexible JavaScript-based spreadsheet solution that enables developers to create customizable, feature-rich data grids for web applications. It offers advanced formulas, data validation, and API integrations. Ideal for tasks like financial modeling, inventory management, and project tracking, it helps businesses efficiently manage and analyze data. Its backend server integration supports real-time data processing, enhancing workflows and boosting productivity across various industries.

Jspreadsheet Pro seamlessly incorporates ChatGPT API into data grids. This integration facilitates automated content generation, efficient response management, and comprehensive data analysis. For full functionality it requires the Jspreadsheet Server extension which enables front-end queries to communicate with the API via your back-end, delivering real-time data and insights to users.

Jspreadsheet Pro is licensed as an Annual or a Perpetual License with support and maintenance. We can supply any Jspreadsheet Pro license including new licenses, maintenance renewals, and upgrade licenses. See our Jspreadsheet Pro for full details.

For more information, visit our Jspreadsheet Pro product page.

셀 이미지를 정확하게 배치하여 세련된 프레젠테이션을 구현하세요

9월 26, 2024
Spread.NET v17.2는 사용자가 셀의 이미지 배치를 맞추거나, 채우거나, 사용자 지정할 수 있도록 지원하므로 스프레드시트를 유연하고 정확하게 표시할 수 있습니다.

Spread.NET by MESCIUS is a powerful tool for building Excel-like applications in your .NET projects. It lets you create interactive spreadsheets, grids, dashboards, and even forms within WinForms, ASP.NET, and WPF applications. With its rich feature set, including a robust calculation engine, formula support, and Excel compatibility, Spread.NET empowers developers to build data analysis tools, budgeting apps, scientific dashboards, and more, all within the familiar .NET environment.

The Spread.NET v17.2 release introduces greater cell image versatility and customization. With four new distinct sizing options—Fit, Fill, Original, and Custom—users gain precise control over how images are displayed within cells. The Fit mode maintains the image's aspect ratio while ensuring it fits within the cell, preventing distortion. The Fill option covers the entire cell, disregarding the aspect ratio for full coverage. Original preserves the image's natural size, even if it exceeds the cell's dimensions, while Custom allows users to set specific height and width parameters. These flexible sizing options enhance the presentation of images, offering tailored solutions to fit various content needs, whether it’s for data visualization, design, or reporting purposes. This feature significantly improves visual control, ensuring consistency and a professional appearance across documents.

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

Spread.NET is licensed per developer and is available as a Perpetual License with a 12 month support and maintenance subscription. We can supply any Spread.NET license including new licenses, maintenance renewals, and upgrade licenses. See our Spread.NET licensing page for full details.

For more information, visit our Spread.NET product page.