Independentsoft
Home
Purchase
Support
Company
Contact
JSpreadsheet
> Tutorial
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
Find text
Replace text
Find and replace options
Bulk fill worksheet
Insert cell comment
Import / Export
Import CSV data
Export worksheet to CSV
Save workbook as HTML
Save to stream or byte array
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
Validate workbook
Evaluation version (version 3.0.620)
Download 30 days evaluation version (zip file)
Need help? Ask our developers:
Name*
Email*
Message*