首页 > 代码库 > SXSSFWorkbook用于海量数据Excel导出类
SXSSFWorkbook用于海量数据Excel导出类
public SXSSFWorkbook(XSSFWorkbook workbook) /* Construct a workbook from a template. 下列三种模式可以用此构造方法 There are three use-cases to use SXSSFWorkbook(XSSFWorkbook) : 追加sheet到已有XSSFWorkbook工作区后 Append new sheets to existing workbooks. You can open existing workbook from a file or create on the fly with XSSF. 追加row到已有的sheet,追加的row必须大于已有sheet的最大row后 Append rows to existing sheets. The row number MUST be greater than max(rownum) in the template sheet. 获得已有sheet元素 Use existing workbook as a template and re-use global objects such as cell styles, formats, images, etc. 三种可以混合 All three use cases can work in a combination. 不支持的 What is not supported: 通过初始化cells和rows,通过些构造方法,使用getRow和getCell方法将返回 Access initial cells and rows in the template. After constructing SXSSFWorkbook(XSSFWorkbook) all internal windows are empty and SXSSFSheet@getRow and SXSSFRow#getCell return null. 覆盖已存在的cells和rows将导致文件不可读 Override existing cells and rows. The API silently allows that but the output file is invalid and Excel cannot read it. Parameters: workbook - the template workbook */
http://poi.apache.org/apidocs/org/apache/poi/xssf/streaming/SXSSFWorkbook.html
SXSSFWorkbook用于海量数据Excel导出类
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。