Uses of Class
cn.orionsec.kit.office.excel.writer.BaseExcelWriter

Packages that use BaseExcelWriter

Package	Description
cn.orionsec.kit.office.excel.writer

Uses of BaseExcelWriter in cn.orionsec.kit.office.excel.writer

Subclasses of BaseExcelWriter in cn.orionsec.kit.office.excel.writer

Modifier and Type	Class and Description
class	ExcelArrayWriter<T> excel array 写入器
class	ExcelBeanWriter<T> excel bean 写入器 不支持注解 如果要使用注解需要用 ExcelExport 导出
class	ExcelLambdaWriter<T> excel lambda 写入器
class	ExcelMapWriter<K,V> excel map 写入器

Methods in cn.orionsec.kit.office.excel.writer that return BaseExcelWriter

Modifier and Type	Method and Description
BaseExcelWriter<K,V>	BaseExcelWriter.addRow(V row) 添加行
BaseExcelWriter<K,V>	BaseExcelWriter.addRows(Collection<V> list) 添加行
BaseExcelWriter<K,V>	BaseExcelWriter.columnUseDefaultStyle() 列是否使用默认样式 需要在设置样式之前调用
BaseExcelWriter<K,V>	BaseExcelWriter.defaultValue(K k, Object value) 设置默认值
BaseExcelWriter<K,V>	BaseExcelWriter.displayFormulas() 不执行公式 会修改列宽单位
BaseExcelWriter<K,V>	BaseExcelWriter.displayGridLines() 不显示网格线
BaseExcelWriter<K,V>	BaseExcelWriter.displayRowColHeadings() 不显示行数和列数
BaseExcelWriter<K,V>	BaseExcelWriter.filter() 筛选列
BaseExcelWriter<K,V>	BaseExcelWriter.filter(int rowIndex) 筛选列
BaseExcelWriter<K,V>	BaseExcelWriter.filter(int rowIndex, int lastColumn) 筛选列
BaseExcelWriter<K,V>	BaseExcelWriter.footer(FooterOption option) 设置页脚
BaseExcelWriter<K,V>	BaseExcelWriter.freeze() 固定行
BaseExcelWriter<K,V>	BaseExcelWriter.freeze(int row) 固定行
BaseExcelWriter<K,V>	BaseExcelWriter.header(HeaderOption option) 设置页眉
BaseExcelWriter<K,V>	BaseExcelWriter.headerHeight(int height) 设置表头默认行高
BaseExcelWriter<K,V>	BaseExcelWriter.headers(String... headers) 添加表头
BaseExcelWriter<K,V>	BaseExcelWriter.headerStyle(int column, org.apache.poi.ss.usermodel.CellStyle style) 设置头 style
BaseExcelWriter<K,V>	BaseExcelWriter.headerUseRowStyle() 表头是否使用行样式
BaseExcelWriter<K,V>	BaseExcelWriter.height(int height) 设置默认行高
BaseExcelWriter<K,V>	BaseExcelWriter.hidden() 设置隐藏表格
BaseExcelWriter<K,V>	BaseExcelWriter.hidden(int column) 设置隐藏列
BaseExcelWriter<K,V>	BaseExcelWriter.merge(org.apache.poi.ss.util.CellRangeAddress region, boolean mergeBorder) 合并单元格
BaseExcelWriter<K,V>	BaseExcelWriter.merge(int row, int firstCol, int lastCol)
BaseExcelWriter<K,V>	BaseExcelWriter.merge(int row, int firstCol, int lastCol, boolean mergeBorder)
BaseExcelWriter<K,V>	BaseExcelWriter.merge(int firstRow, int lastRow, int firstCol, int lastCol)
BaseExcelWriter<K,V>	BaseExcelWriter.merge(int firstRow, int lastRow, int firstCol, int lastCol, boolean mergeBorder) 合并单元格
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k)
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k, ExcelFieldType type)
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k, ExcelFieldType type, Object defaultValue)
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k, ExcelFieldType type, String format)
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k, ExcelFieldType type, String format, Object defaultValue) 添加列配置
BaseExcelWriter<K,V>	BaseExcelWriter.option(int column, K k, Object defaultValue)
BaseExcelWriter<K,V>	BaseExcelWriter.option(K k, WriteFieldOption option)
BaseExcelWriter<K,V>	BaseExcelWriter.option(K k, WriteFieldOption option, Object defaultValue) 添加列配置
BaseExcelWriter<K,V>	BaseExcelWriter.print(PrintOption option) 设置打印属性
BaseExcelWriter<K,V>	BaseExcelWriter.protect(String password) 保护表格
BaseExcelWriter<K,V>	BaseExcelWriter.rowHeight(int height) 设数据行高
BaseExcelWriter<K,V>	BaseExcelWriter.selected() 设置选中
BaseExcelWriter<K,V>	BaseExcelWriter.skip() 跳过一行
BaseExcelWriter<K,V>	BaseExcelWriter.skip(int i) 跳过多行
BaseExcelWriter<K,V>	BaseExcelWriter.skipNullRows(boolean skip) 跳过空行
BaseExcelWriter<K,V>	BaseExcelWriter.style(int column, org.apache.poi.ss.usermodel.CellStyle style) 设置列 style
BaseExcelWriter<K,V>	BaseExcelWriter.style(int column, Function<V,Selector<V,org.apache.poi.ss.usermodel.CellStyle>> selector) 设置列样式选择器
BaseExcelWriter<K,V>	BaseExcelWriter.title(String title) 添加标题
BaseExcelWriter<K,V>	BaseExcelWriter.title(String title, int row) 添加标题
BaseExcelWriter<K,V>	BaseExcelWriter.title(String title, int row, int lastColumnIndex) 添加标题
BaseExcelWriter<K,V>	BaseExcelWriter.titleHeight(int height) 设置标题行高
BaseExcelWriter<K,V>	BaseExcelWriter.titleStyle(org.apache.poi.ss.usermodel.CellStyle style) 设置标题 style
BaseExcelWriter<K,V>	BaseExcelWriter.trim() 跳过首尾空格
BaseExcelWriter<K,V>	BaseExcelWriter.width(int width) 设置默认行宽
BaseExcelWriter<K,V>	BaseExcelWriter.width(int column, int width) 设置行宽