java

编程技术  /  houtizong 发布于 3年前   79

•How to create a new workbook
•How to create a sheet
•How to create cells
•How to create date cells
•Working with different types of cells
•Text Extraction
•Aligning cells
•Working with borders
•Fills and color
•Merging cells
•Working with fonts
•Custom colors
•Reading and writing
•Use newlines in cells.
•Create user defined data formats
•Fit Sheet to One Page
•Set print area for a sheet
•Set page numbers on the footer of a sheet
•Shift rows
•Set a sheet as selected
•Set the zoom magnification for a sheet
•Create split and freeze panes
•Repeating rows and columns
•Headers and Footers
•Drawing Shapes
•Styling Shapes
•Shapes and Graphics2d
•Outlining
•Images
•Named Ranges and Named Cells
•How to set cell comments
•How to adjust column width to fit the contents