1. | Introduction |
2. | JExcel Overview |
3. | Excel Automation Basics |
3.1. | Creating a New Application |
3.2. | Creating a New Workbook |
3.3. | Opening an Existing Workbook |
3.4. | Saving a Workbook |
3.5. | Obtaining and Modifying Workbook Additional Information |
3.6. | Managing Worksheets |
3.7. | Working with Workbook Windows |
3.8. | Working with a List of Recently Opened Files |
4. | Event Listening and Handling |
4.1. | Application Events |
4.2. | Workbook Events |
4.2.1. | Listening to Workbook Events |
4.2.2. | Handling Workbook Events |
4.3. | Worksheet Events |
4.3.1. | Listening to Worksheet Events |
4.3.2. | Handling Worksheet Events |
5. | Working with Cells |
5.1. | Referencing Cells |
5.2. | Setting New Values |
5.3. | Obtaining Existing Values |
6. | Working with Ranges |
6.1. | Referencing Ranges |
6.2. | Converting a Cell to a Range and Vice Versa |
6.3. | Finding Values in Ranges |
6.4. | Sorting a Range |
6.5. | Obtaining Ranges Intersection |
6.6. | Merging and Unmerging Cells of a Range |
7. | Customizing Cells and Ranges |
7.1. | Changing a Number Format |
7.2. | Customizing Text Alignment and Orientation |
7.2.1. | Changing Text Alignment |
7.2.2. | Changing Text Orientation |
7.3. | Customizing Text Font |
7.4. | Changing Background Pattern and Color in Cells |
7.5. | Border Customization |
8. | Integrating a Workbook into a Java Swing Application |
8.1. | Opening and Saving an Embedded Workbook |
8.2. | Printing an Embedded Workbook |
8.3. | Displaying a Workbook in Static Mode |
8.4. | Listening to JWorkbook Events |
9. | Working with Native Peers and Thread Issues |
10. | Support |
10.1. | Reporting Problems |
10.2. | Troubleshooting |
11. | Where to Get a New Version |