Spreadsheets 新聞

使用 C# 添加 .NET 試算表功能區欄

2月 19, 2024
用類似 Excel 的功能區提高使用者工作效率並增強您 .NET 應用的 UI，該功能區提供上下文行為、命令執行等。

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. You can develop in Visual Studio using VB or C# for WinForms, ASP.NET, and WPF. Spread.NET ensures maximum performance for your enterprise apps and its modular architecture lets you add only the features you need, reducing unnecessary bloat.

In this blog post, MESCIUS Product Marketing Specialist Mackenzie Albitz shows you how to add a spreadsheet ribbon bar control to a .NET 8 WinForms app using C#. Steps include:

  • Creating a WinForms .NET 8 app
  • Adding a .NET Spreadsheet Component to the Form
  • Attaching a Ribbon Bar Control to the .NET Spreadsheet Instance
  • Programmatically Customizing the .NET Spreadsheet Ribbon Bar Control

Read the complete blog and unlock the powerful capabilities of the Spread.NET 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.

將 CSV 資料導入 WinForms 試算表

2月 8, 2024
CSV 格式的逗號分隔結構促進了通用相容性，允許程式之間的無縫傳輸。

Integrating CSV import functionality in a spreadsheet streamlines data management by offering several key benefits. It simplifies transferring structured data from external sources, like databases or web scraped information, directly into the spreadsheet for analysis. This eliminates manual data entry errors and saves time. The straightforward CSV format ensures broad compatibility with various data sources, enhancing flexibility.

Several WinForms spreadsheet controls offer the ability to import CSV files including:

  • DevExpress WinForms Spreadsheet (part of DevExpress WinForms) allows you to effortlessly import CSV data, preserving formatting and recognizing data types.
  • Telerik WinForms Spreadsheet (part of Telerik UI for WinForms) enables you to seamlessly integrate CSV data, leveraging visual tools for mapping and data cleansing.
  • Aspose.Cells for .NET provides a robust and versatile solution for importing CSV files from streams, strings, or directly from disk.
  • Syncfusion WinForms Spreadsheet (part of Syncfusion Essential Studio Enterprise) leveraging built-in parsing to facilitate seamless integration of CSV data into your app.

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

Compare WinForms Spreadsheet Controls

用 Excel 動態函數構建依賴清單

2月 6, 2024
瞭解如何使用 C#.NET 在 MESCIUS Document Solutions for Excel 中使用級聯下拉列表，從而允許一個清單根據另一個清單進行更改。

Document Solutions for Excel, .NET Edition (DsExcel) by MESCIUS is a powerful server-side spreadsheet API designed for .NET environments. It allows you to create, load, modify, and convert Excel files without requiring Microsoft Excel itself. Document Solutions for Excel boasts a high-speed, low-footprint design, meaning efficient performance and streamlined integration into your applications. The intuitive interface mirrors Excel's object model, simplifying development for tasks like generating reports, manipulating data, and visualizing information with charts and formatting.

Spreadsheets often require dynamic relationships between dropdowns. Imagine choosing a customer from one dropdown, automatically triggering another dropdown to display only their relevant order IDs. This "cascading" functionality streamlines data navigation and fosters deeper analysis, allowing you to drill down into specific order details with ease.

In this blog post, MESCIUS Product Specialist Paarisha Rana demonstrates how to use DsExcel to create master and dependent dropdown lists programmatically. Steps include:

  • Initializing the Workbook and getting the Worksheet
  • Getting the unique list of customer names
  • Creating the master dropdown
  • Fetching the unique order IDs and populating the dependent dropdown
  • Populating the Worksheet with the order data

Read the complete blog and get started leveraging Excel's powerful capabilities in your own applications using Document Solutions for Excel.

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.

突出顯示符合特定條件的資料

2月 2, 2024
條件格式直觀地突出顯示了關鍵的試算表資料點、趨勢和異常情況，從而加快了分析和決策速度。

Conditional formatting in spreadsheets automates the visual highlighting of cells or ranges based on predefined criteria. This functionality aids data analysis by rapidly drawing attention to specific values, ranges, or text entries. By employing color scales, gradients, or text changes, conditional formatting helps users identify patterns, exceptions, and trends within large datasets, streamlining the interpretation and communication of key insights.

Several JavaScript spreadsheet controls offer conditional formatting including:

  • Telerik Spreadsheet jQuery (part of Kendo UI) allows customizable cell formatting, including number, date/time, styles, and conditional formatting by setting a color and a condition to the format string.
  • SpreadJS by MESCIUS (formerly GrapeCity) supports conditional formatting in cells with several conditional rule types to choose from such as average, cell value, duplicate, formula, specific text and more.
  • Infragistics Spreadsheet Angular (part of Infragistics Ignite UI) allows you to conditionally format the background and font settings of cells in a worksheet based on predefined criteria such as average, blank, value, or date.
  • Syncfusion Spreadsheet JavaScript (part of Syncfusion Essential Studio Enterprise) lets you highlight a cell or a range of cells with a certain color based on applied conditions, and showcases data with data bars, color scales, and icon sets.

For an in-depth analysis of features and price, visit our comparison of JavaScript spreadsheets.

Compare JavaScript Spreadsheets

在 .NET 中將試算表導出為 PDF

1月 26, 2024
將試算表資料轉換為 PDF 可確保跨平臺查看的一致性，使其成為共用和存檔的理想選擇。

PDF export functionality allows users to convert spreadsheets into PDF format, preserving the layout and formatting of the data. By seamlessly translating your data into a universally accessible format, you ensure colleagues, clients, and stakeholders can readily view and interpret your work without needing proprietary software. Choose from flexible options like exporting specific sheets, customizing page layouts, and enhancing accessibility for optimal visual presentation and impact. Whether for reports, invoices, or internal analyses, PDF export empowers a professional workflow with streamlined data dissemination.

Several .NET Spreadsheet components include support for exporting as PDF files, including:

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

Compare .NET Spreadsheet Components