java解析Excel存储-对单元格内容判断

 

 

package testexcel;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.FileOutputStream;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFComment;

public class CreateXL {
    public static String xlsFile = "test.xls"; //产生的Excel文件的名称
    public static void main(String args[]) {
        try {
            HSSFWorkbook workbook = new HSSFWorkbook(); //产生工作簿对象
            HSSFSheet sheet = workbook.createSheet(); //产生工作表对象
//设置第一个工作表的名称为firstSheet
//为了工作表能支持中文，设置字符编码为UTF_16
            workbook.setSheetName(0, "firstSheet", HSSFWorkbook.ENCODING_UTF_16);
//产生一行
            HS