Live SpreadsheetGear API Samples
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
Charting
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.
Workbook
Samples demonstrating IWorkbook API.
- Saving
Shapes
Add pictures, textboxes and autoshapes to worksheets.
Worksheet Samples
Samples demonstrating IWorksheet API.
Page Setup and Printing Samples
Demonstrates various APIs relating to configuring Page Setup for printing.
Quick-Fill