excelinterface.java

来自「很好的java excle组件」· Java 代码 · 共 32 行

package com.tools;

import java.util.ArrayList;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 * Excel接口
 * @author Aquarius
 *
 */
public interface ExcelInterface {

	/**创建工作薄*/
	public HSSFWorkbook createWorkBook();
	/**创建工作表*/
	public HSSFSheet createSheet(HSSFWorkbook workbook,int sheetIndex,String sheetName);
	/**合并单元格*/
	public void mergeCell(HSSFSheet sheet,int rowFrom,short colFrom,int rowTo,short colTo);
	/**填充标题*/
	public void fillTitle(HSSFSheet sheet,String title,int rowIndex,
			short colIndex);
	/**填充列名*/
	public void fillColName(HSSFSheet sheet,ArrayList<String> colData,int rowIndex);
	
	/**填充数据*/
	public void fillCellData(HSSFSheet sheet,ArrayList<Map<String,String>> data,ArrayList<String> colNameList,int rowIndex);
	
}