Spreadsheets 新聞

慶祝與 EPPlus 合作 3 周年

2月 11, 2025
自 2022 年以來，ComponentSource 和 EPPlus Software 一直合作，為全球開發人員提供強大的試算表元件。

ComponentSource and EPPlus Software have enjoyed a successful three-year partnership, dedicated to providing high-quality tools to developers around the world. This collaboration reflects their shared mission to empower developers with innovative solutions that boost productivity and support the creation of reliable, high-performance applications.

EPPlus Software is the creator of EPPlus, a widely used .NET library for managing Office Open XML spreadsheets. Offering advanced features such as styling, charts, formulas, and pivot tables, it simplifies data processing and reporting. By adopting EPPlus, organizations can streamline spreadsheet-driven workflows, improve accuracy, and reduce costs.

As a leading distributor of software components and development tools, ComponentSource has helped to expand EPPlus Software’s global reach. This collaboration has brought tangible benefits to the developer community, making cutting-edge spreadsheet tools readily available. As we celebrate this three-year milestone, we look forward to strengthening our partnership and continuing to deliver  innovative solutions that drive developer success on a global scale.

Learn more about EPPlus Software.

用試算表簡化資料管理

2月 6, 2025
用支援公式、格式設置等的互動式試算表元件，將類似於 Excel 的功能添加到您的應用程式中。

Modern spreadsheet components bring the power of Excel-like functionality to web applications, enabling users to create, edit, and manipulate data within an interactive grid. These components typically support formulas, formatting, data validation, and seamless integration with various data sources. Advanced features such as pivot tables, conditional formatting, and charting allow users to analyze and visualize data efficiently. Designed for performance and scalability, these spreadsheet controls cater to both enterprise applications and smaller projects that require robust data processing capabilities.

Several ASP.NET Core UI suites offer spreadsheet components including:

  • DevExpress ASP.NET and Blazor offers a high-performance spreadsheet component with extensive formula support, charting, and seamless document import/export capabilities.
  • Telerik UI for ASP.NET Core provides a feature-rich spreadsheet control with Excel-like filtering, and sorting, ensuring smooth data management within web applications.
  • Infragistics Ignite UI delivers a powerful spreadsheet component with support for formulas, and styling, optimized for high-performance applications.
  • Syncfusion Essential Studio Enterprise includes a robust spreadsheet control with built-in functions, data binding, and client- and server-side processing for better performance.

For an in-depth analysis of features and price, visit our ASP.NET Core UI suites comparison.

Compare ASP.NET Core UI Suites

使用 WinForms 導入和匯出 CSV 檔

2月 4, 2025
利用 MESCIUS 推出的 Spread.NET，透過 C# 或 VB 中集成的 Excel 試算表導入和匯出功能來增強您的 WinForms 項目。

Spread.NET helps you create spreadsheets, grids, dashboards, and forms. It includes a powerful calculation engine with 450+ functions and the ability to import and export Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to create analysis, budgeting, dashboard, data collection and management, scientific, and financial applications.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz guides you through the four essential steps to import and export Excel spreadsheets on your way to creating robust .NET WinForms spreadsheet applications with Spread.NET. These steps include:

  • Configure a .NET WinForms Spreadsheet Application
  • Import a CSV File into a .NET Spreadsheet
  • Convert a CSV File into an Excel XLSX File using C# or VB.NET
  • Export a .NET Spreadsheet Instance to a CSV File
  • Handle CSV Files with a UI Spreadsheet Ribbon Toolbar

Sample code is included in the blog and you can download the sample app in either C# or VB.

Read the full blog post to discover how to use the full capabilities of the Spread.NET WinForms component.

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.

用迷你圖增強試算表見解

1月 23, 2025
迷你圖提供簡潔的單元內視覺化效果，無需全尺寸圖表即可輕鬆發現趨勢和模式。

Sparklines are compact, embedded charts that provide a visual representation of data trends within individual spreadsheet cells. Unlike traditional charts, they do not require a separate charting area, making them ideal for summarizing data patterns, such as sales performance, stock trends, or operational metrics, in a space-efficient manner. These microcharts enhance readability and decision-making by offering a quick, at-a-glance view of trends without overwhelming users with excessive detail.

Several ASP.NET Core spreadsheet controls offer sparkline functionality including:

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

Compare ASP.NET Core Spreadsheet Controls

用圖像集成豐富試算表資料

1月 8, 2025
嵌入圖像增強了試算表資料的視覺化，從而為決策提供更清晰的見解和更豐富的背景。

Image support within a spreadsheet component allows developers to seamlessly integrate and manipulate images directly within the spreadsheet environment, enabling features such as inserting, resizing, positioning, and formatting images within cells or as background elements. By embedding images alongside numerical or textual data, users can enhance data visualization, streamline report generation, and provide richer context for decision-making, ultimately improving communication and enabling more effective data analysis within applications.

Several WinForms spreadsheet components support inserting images, including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) seamlessly integrates and manipulates images directly within your spreadsheets.
  • Spread.NET WinForms (part of Spread.NET by MESCIUS) enhances the visual impact of your spreadsheets with the ability to insert, resize and format images alongside your data.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) adds a new dimension to your data analysis by embedding images within your spreadsheets.
  • MindFusion.Spreadsheet for WinForms by MindFusion Group allows you to use images to create a clear and informative vision of your spreadsheet data.

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

Compare WinForms Spreadsheet Controls