Quick Guide
User Manual:
Open the PDF directly: View PDF
Page Count: 25
- 1 Busy Developers' Guide to Features
- 1.1 Index of Features
- 1.2 Features
- 1.2.1 New Workbook
- 1.2.2 New Sheet
- 1.2.3 Creating Cells
- 1.2.4 Creating Date Cells
- 1.2.5 Working with different types of cells
- 1.2.6 Demonstrates various alignment options
- 1.2.7 Working with borders
- 1.2.8 Iterate over rows and cells
- 1.2.9 Iterate over rows and cells using Java 1.5 foreach loops - OOXML Branch Only
- 1.2.10 Text Extraction
- 1.2.11 Fills and colors
- 1.2.12 Merging cells
- 1.2.13 Working with fonts
- 1.2.14 Custom colors
- 1.2.15 Reading and Rewriting Workbooks
- 1.2.16 Using newlines in cells
- 1.2.17 Data Formats
- 1.2.18 Fit Sheet to One Page
- 1.2.19 Set Print Area
- 1.2.20 Set Page Numbers on Footer
- 1.2.21 Using the Convenience Functions
- 1.2.22 Shift rows up or down on a sheet
- 1.2.23 Set a sheet as selected
- 1.2.24 Set the zoom magnification
- 1.2.25 Splits and freeze panes
- 1.2.26 Repeating rows and columns
- 1.2.27 Headers and Footers
- 1.2.28 Drawing Shapes
- 1.2.29 Styling Shapes
- 1.2.30 Shapes and Graphics2d
- 1.2.31 Outlining
- 2 Images
- 3 Named Ranges and Named Cells
- 4 Cell Comments
- 5 Adjust column width to fit the contents
- 6 How to read hyperlinks
- 7 How to create hyperlinks