Getting started

• Simple workbook
• Display cell values - Solution I
• Display cell values - Solution II
• Cell value types
• Load workbook from file
• Load from XLS (BIFF8)
• Document properties
• Multiple sheets
• Clone sheet
• Find hidden worksheet

Cells and data

• Sum cells
• Working with formulas
• Rich text in cells
• Get rich inline text
• Merge cells
• Name a range
• Enumerate defined names
• Replace placeholders
• Bulk fill worksheet
• Insert cell comment

Import / Export

• Import CSV data
• Export worksheet to CSV

Cell formatting and styling

• Set cell format
• Set cell border
• Set cell fill color
• Set cell color
• Cell alignment
• Font styling
• Number formats
• Superscript text

Data operations

• Sort data
• AutoFilter
• Data validation
• Data validation - dropdown list
• Conditional formatting
• Conditional formatting - color scale
• Grouping

Protection

• Protect worksheet
• Workbook protection

Tables, hyperlinks and objects

• Create table
• Create pivot table
• Create cell link
• Create hyperlink
• Insert image
• Insert background image
• Insert text box
• Insert combo box
• Insert line

Page layout and printing

• Set page size and margins
• Set page size
• Freeze panes
• Set column width
• Set row height
• Set print area
• Page breaks
• Set worksheet header

Charts

• Create bar chart
• Create pie chart
• Create 3D pie chart

Windows Forms sample

• MySpreadsheet

Name* Email* Message*

© Copyright 2026 Independentsoft