XSSFWorkbook源码类
pom配置
org.apache.poi
poi-ooxml
4.1.2
源码类
public class XSSFWorkbook extends POIXMLdocument implements Workbook
构造方法
public XSSFWorkbook()
public XSSFWorkbook(XSSFWorkbookType workbookType)
public XSSFWorkbook(OPCPackage pkg)
public XSSFWorkbook(InputStream is)
public XSSFWorkbook(File file)
public XSSFWorkbook(String path)
XSSFWorkbook getWorkbook = new XSSFWorkbook("文件路径");
通过构造方法进行实例化，获取XSSFWorkbook类对象;
再通过对象调用以下方法↓
普通方法
//创建
public XSSFSheet createSheet()
public XSSFSheet createSheet(String sheetname)
//得到活动sheet下标
public int getActiveSheetIndex()
//根据下标或名字的到sheet对象
public XSSFSheet getSheetAt(int index)
public XSSFSheet getSheet(String name)
//根据sheet对象或名字得到sheet下标
public int getSheetIndex(Sheet sheet)
public int getSheetIndex(String name)
//根据sheet下标的到sheet名字
public String getSheetName(int sheetlx)
//得到excel文件类型
public XSSFWorkbookType getWorkbookType()
//克隆
public XSSFSheet cloneSheet(int sheetNum)
//删除
public void removeSheetAt(int index)
