AligningCells |
Shows how various alignment options work.
|
BarAndLineChart |
|
BarChart |
Line chart example.
|
BigGridDemo |
Demonstrates a workaround you can use to generate large workbooks and avoid OutOfMemory exception.
|
BigGridDemo.SpreadsheetWriter |
Writes spreadsheet data in a Writer.
|
CalendarDemo |
A monthly calendar created using Apache POI.
|
CellComments |
Demonstrates how to work with excel cell comments.
|
CreateCell |
Illustrates how to create cell and set values of different types.
|
CreatePivotTable |
|
CreatePivotTable2 |
|
CreateTable |
Demonstrates how to create a simple table using Apache POI.
|
CreateUserDefinedDataFormats |
How to set user-defined date formats
|
CustomXMLMapping |
Print all custom XML mappings registered in the given workbook
|
EmbeddedObjects |
Demonstrates how you can extract embedded data from a .xlsx file
|
ExcelChartWithTargetLine |
This example is based on original contributions by Axel Richter
Note from original author:
This only works for Excel since OpenOffice or LibreOffice Calc is not able having series having literal numeric values set.
|
FillsAndColors |
Fills and Colors
|
FitSheetToOnePage |
|
HeadersAndFooters |
|
HyperlinkExample |
Demonstrates how to create hyperlinks.
|
IterateCells |
Iterate over rows and cells
|
LineChart |
Line chart example.
|
LoadPasswordProtectedXlsx |
An example that loads a password protected workbook and counts the sheets.
|
MergingCells |
An example of how to merge regions of cells.
|
NewLinesInCells |
How to use newlines in cells
|
Outlining |
|
ScatterChart |
Illustrates how to create a simple scatter chart.
|
SelectedSheet |
|
ShiftRows |
How to shift rows up or down
|
SplitAndFreezePanes |
How to set split and freeze panes
|
WorkbookProperties |
How to set extended and custom properties
|
WorkingWithBorders |
Working with borders
|
WorkingWithFonts |
Working with Fonts
|
WorkingWithPageSetup |
Demonstrates various settings available in the Page Setup dialog
|
WorkingWithPictures |
Demonstrates how to insert pictures in a SpreadsheetML document
|
WorkingWithRichText |
Demonstrates how to work with rich text
|