Spreadsheets 뉴스

XLSX 파일을 Vue .js 애플리케이션으로 가져오세요

1월 8, 2024
XLSX 가져오기를 지원하는 스프레드시트 컨트롤을 사용하여 Vue.js 앱에 Microsoft Excel 파일 처리 기능을 추가할 수 있습니다.

The ability to import XLSX files is a common feature in spreadsheet software, allowing users to open and work with files created in other applications like Microsoft Excel. These versatile controls streamline data integration and boost efficiency by effortlessly populating spreadsheets with pre-existing data, saving valuable time and eliminating error-prone manual entry. This ensures compatibility and ease of data transfer, enabling users to bring in complex datasets with various formatting and formulas intact, which is essential for interoperability and collaboration. Vue.js spreadsheet components eliminate the drudgery of manual data entry and revolutionize the way you manage information within your applications.

Several Vue.js spreadsheet controls support XLSX file import, including:

  • Wijmo FlexSheet (part of Wijmo) by MESCIUS fully supports the import of XLSX files via its FlexGrid component for Vue, which is capable of retaining the styles and formatting of the document.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) offers all the common Excel features including the ability to import XLSX files and other Excel file formats.
  • Jspreadsheet Pro is a lightweight JavaScript library compatible with Vue that provides import/export functionality for the XLSX file format, as well as many other advanced spreadsheet-like controls.

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

Compare Vue.js Spreadsheet Controls

.NET 스프레드시트에 Excel과 유사한 리본 추가하기

1월 2, 2024
Spread.NET 17에는 상황에 맞는 탭, 단추 및 메뉴를 스프레드시트 앱에 추가할 수 있는 새로운 리본 컨트롤이 제공됩니다.

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 release adds a new Ribbon control to modernize your spreadsheet's look and feel. Inspired by Excel, this intuitive interface organizes commands into clear, contextual tabs and groups, making it easy for users to find the tools they need. This modern upgrade not only boosts productivity but also brings a familiar feel to your spreadsheets, streamlining the entire user experience.

To see a full list of what's new in version 17, 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.

JavaScript로 Gantt 스케줄링 앱을 생성할 수 있습니다

12월 27, 2023
Gantt 차트 동작 및 스프레드시트 UI가 있는 데이터 바인딩된 DataTable 뷰를 제공하는 선택적 GanttSheet 추가 기능이 SpreadJS 17에 도입되었습니다.

SpreadJS by MESCIUS is a powerful JavaScript library that lets you build Excel-like spreadsheets within your web applications. It offers tables, charts, formulas, pivot tables, and more, all running within the browser. It works with major frameworks like Angular, React, and Vue, and offers Excel file import and export. SpreadJS empowers developers to create interactive dashboards, analyze data, and streamline workflows, all within the familiar spreadsheet interface.

The SpreadJS 17 release introduces the optional GanttSheet Add-On, a full Gantt implementation that works inside of SpreadJS. It seamlessly integrates with your existing spreadsheets, transforming them into clear and concise Gantt charts. This allows you to visualize tasks, dependencies, and progress at a glance, identifying potential bottlenecks and adjust schedules proactively. GanttSheet offers a flexible and intuitive may to manage tasks, sort data, customize calendar settings, and even import/export plans for smooth collaboration.

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

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 GanttSheet Add-On is available at an additional cost, and requires a SpreadJS license. See our SpreadJS licensing page for full details.

For more information, visit our SpreadJS product page.

WinForms 앱에서 스프레드시트를 CSV로 내보내기

12월 21, 2023
CSV로 내보내면 범용 호환성이 보장되고 플랫폼과 애플리케이션 간에 데이터 공유가 간소화됩니다.

The ability to export to comma-separated values (CSV) from a spreadsheet control enhances interoperability and data accessibility. It seamlessly translates spreadsheet data into the ubiquitous CSV format, fostering effortless integration with a vast ecosystem of analytical tools, databases, and third-party applications. This democratizes your data, empowering users to leverage existing workflows and external expertise, enriching analysis, and maximizing the reach and impact of your data-driven insights.

Several WinForms spreadsheet components provide CSV export functionality, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) supports precision-tuned CSV exports with customizable formatting, separators, and macros.
  • Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio) offers flexible CSV export with support for custom delimiters, headers, and intelligent filters.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) provides CSV export with support for selected ranges and high performance even with large datasets.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) allows you to craft complex multi-sheet exports with cell mapping, macros, and conditional formatting for enhanced clarity.

For an in-depth analysis of features and price, visit our WinForms Spreadsheet Component comparison.

Compare WinForms Spreadsheet Components

Angular 스프레드시트 앱에서 데이터 필터링 및 그룹화

12월 19, 2023
데이터 필터링 및 그룹화를 통해 스프레드시트 사용자가 대규모 데이터 세트를 쉽고 효율적으로 관리하고 분석할 수 있습니다.

Data filtering and grouping are key spreadsheet features that allow users to manage and analyze large datasets efficiently. Filtering enables users to hide data that does not meet certain criteria, making it easier to focus on relevant information. Grouping clusters related data together, which can then be summarized with functions such as sum, average, and count. These features are vital for working with extensive spreadsheets, enabling users to simplify their view, and gain insights from specific subsets of data.

Several Angular Spreadsheet components provide data filtering and grouping support including:

  • Jspreadsheet Pro supports navigating large datasets with ease using multi-level filtering and summarize key trends with dynamic group summaries.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio) allows you to gain insights and enhance understanding with nested grouping.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) lets you simplify data exploration with drag-and-drop grouping and aggregate functions for instant summaries.
  • SpreadJS by MESCIUS supports crafting precise filters using advanced formulas and grouping data by multiple criteria for deeper analysis.

For an in-depth analysis of features and price, visit our Angular Spreadsheet Component comparison.

Compare Angular Spreadsheet Components