Live SpreadsheetGear C# API Samples
Excel-compatible samples for .NET and ASP.NET Core
These concise C# .NET samples serve as a practical reference for developers searching for a C# Excel library that can create Excel-compatible workbooks, modify worksheets, format ranges, work with formulas and named ranges, generate charts, shapes and much more—all without any dependencies on Microsoft Excel. They are executed live in real time, demonstrating how quickly and easily SpreadsheetGear can manage a wide variety of Excel workbook-manipulating tasks.
The SpreadsheetGear Engine for .NET product is used to both execute the samples as well as generate Excel-compatible workbook output, typically Open XML (.xlsx) files. For image-based output, the samples use the SpreadsheetGear.Drawing.Image class included in SpreadsheetGear for Windows, enabling high‑quality rendering of ranges, charts, and other shapes.
Under the hood, all samples execute inside a lightweight Azure Function App hosted on Microsoft Azure, providing a fast, scalable and cloud‑based environment that SpreadsheetGear can fully leverage.
Excel-Compatible C# Range Samples
Add a variety of formatting, comments, grouping, hyperlinks, protection, validation, values, and merge, find, replace, filter, sort, goal seek, or fill data.
- Conditional Formats
- Formatting and Other Cell Features
- Values and Formulas
- Operations
Excel-Compatible C# Charting Samples
Richly formatted workbooks with fast and complete calculations are the heart and soul of a spreadsheet, but the ability to make good decisions is greatly enhanced by the ability to visualize data. Enhance your users' understanding of their data by taking advantage of SpreadsheetGear's comprehensive Excel compatible charting support.
Excel-Compatible C# Workbook Samples
Samples demonstrating IWorkbook API.
- Saving
- Opening
- Styles
- Miscellaneous
Excel-Compatible C# Shape Samples
Add pictures, textboxes and autoshapes to worksheets.
Excel-Compatible C# Worksheet Samples
Samples demonstrating IWorksheet API.
Excel-Compatible C# Page Setup and Printing Samples
Demonstrates various APIs relating to configuring Page Setup for printing.
Quick-Fill