java读取txt文件中的json字符串数据，生成excel

package com.hwt.count.test;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.HSSFColor;
import net.sf.json.JSONObject;

public class Testaa {

	public static void main(String[] args) {
		try {
			String path = "C:/Users/dell/Desktop/test.txt";
			File file = new File(path);
			InputStreamReader isr = new InputStreamReader(new FileInputStream(file),"GBK");
			BufferedReader br = new BufferedReader(isr);
			String content = br.readLine() ;
			br.close();
			isr.close();
			content = content.substring(2, content.length()-2);
			content = content.replace("},{", ";");
			String[] arrContent = content.split(";");
			
			//设置列头名称和表体数据
			String[] rowsName = new String[]{"code_type","code","name"};
			List<Object[]> dataList = new ArrayList<Object[]>();
			
			for(String arrc : arrContent){
				JSONObject jsonObj = JSONObject.fromObject("{"+arrc+"}");
				String code = jsonObj.getString("code");
				String name = jsonObj.getString("name");
				Object[] obj = new Object[rowsName.length];
				obj[0] = "TYPE";
				obj[1] = code;
				obj[2] = name;
				dataList.add(obj);
			}
			//设置列头名称和表体数据
			HSSFWorkbook workbook = setWorkBookDate(dataList,rowsName);
			try {
				// 将workbook对象输出到文件test.xls
				FileOutputStream fos = new FileOutputStream("C:/Users/dell/Desktop/test.xls");
				workbook.write(fos);
				fos.flush(); // 缓冲
				fos.close(); // 关闭流
			}catch (Exception e1) {
				e1.printStackTrace();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private static HSSFWorkbook setWorkBookDate(List<Object[]>  dataList,String[] rowsName){
		
		//创建工作簿对象
		HSSFWorkbook workbook = new HSSFWorkbook();
		//创建工作表，设置当前页名称
		HSSFSheet sheet = workbook.createSheet("测试");
		//设置默认行高
		sheet.setDefaultRowHeight((short)350);
        // 获取表体样式对象
        HSSFCellStyle style = getCommonStyle(workbook);
        
		// 定义所需列数
		int columnNum = rowsName.length;
		//创建列头
		HSSFRow rowHead = sheet.createRow(0);  
		for(int n = 0;n < columnNum;n++){
			HSSFCell cellRow = rowHead.createCell(n,HSSFCell.CELL_TYPE_STRING);//创建列头对应个数的单元格				
			cellRow.setCellValue(rowsName[n]);//设置列头单元格的值						
			cellRow.setCellStyle(style);//设置列头单元格样式						
		}
		
		//将查询出的数据设置到sheet对应的单元格中
		for(int i=0;i<dataList.size();i++){
			Object[] obj =new Object[dataList.get(i).length];
			obj[0] = dataList.get(i)[0];
			obj[1] = dataList.get(i)[1];
			obj[2] = dataList.get(i)[2];
			HSSFRow row = sheet.createRow(i+1);//创建所需的行数
			for(int j = 0; j < obj.length; j++){
				HSSFCell cell = row.createCell(j,HSSFCell.CELL_TYPE_STRING);//设置单元格的数据类型   
				if(!"".equals(obj[j]) && obj[j] != null){
					cell.setCellValue(obj[j].toString());//设置单元格的值						
				}else{
					cell.setCellValue("");//设置单元格的值为空字符串
				}
				cell.setCellStyle(style);//设置单元格样式									
			}
		}
		//让列宽随着导出的列长自动适应
		for (int colNum = 0; colNum < columnNum; colNum++) {
            int columnWidth = sheet.getColumnWidth(colNum) / 256;
            for (int rowNum = 0; rowNum < sheet.getLastRowNum(); rowNum++) {
                HSSFRow currentRow;
                //当前行未被使用过
                if (sheet.getRow(rowNum) == null) {
                    currentRow = sheet.createRow(rowNum);
                } else {
                    currentRow = sheet.getRow(rowNum);
                }
                if (currentRow.getCell(colNum) != null) {
                    HSSFCell currentCell = currentRow.getCell(colNum);
                    if(currentCell != null && !"".equals(currentCell)){
                    	if (currentCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
                			int length = currentCell.getStringCellValue().getBytes().length;
                    		if (columnWidth < length) {
                    			columnWidth = length;
                    		}
                    	}
                    }
                }
            }
            if(colNum == 0){
            	//设置表体第一列的宽度
            	sheet.setColumnWidth(colNum, (columnWidth+4) * 400);
            }else{
            	//设置表体其他列的宽度
            	sheet.setColumnWidth(colNum, (columnWidth+4) * 400);
            }
        }
		return workbook;
	}

	public static HSSFCellStyle getCommonStyle(HSSFWorkbook workbook) {
	  // 设置字体
	  HSSFFont font = workbook.createFont();
	  //设置字体大小
	  font.setFontHeightInPoints((short)11);
	  //字体加粗
	  //font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
	  //设置字体名字 
	  font.setFontName("Courier New");
	  //设置样式; 
	  HSSFCellStyle style = workbook.createCellStyle();
	  //设置底边框; 
	  style.setBorderBottom(HSSFCellStyle.BORDER_THIN);
	  //设置底边框颜色;  
	  style.setBottomBorderColor(HSSFColor.BLACK.index);
	  //设置左边框;   
	  style.setBorderLeft(HSSFCellStyle.BORDER_THIN);
	  //设置左边框颜色; 
	  style.setLeftBorderColor(HSSFColor.BLACK.index);
	  //设置右边框; 
	  style.setBorderRight(HSSFCellStyle.BORDER_THIN);
	  //设置右边框颜色; 
	  style.setRightBorderColor(HSSFColor.BLACK.index);
	  //设置顶边框; 
	  style.setBorderTop(HSSFCellStyle.BORDER_THIN);
	  //设置顶边框颜色;  
	  style.setTopBorderColor(HSSFColor.BLACK.index);
	  //在样式用应用设置的字体;  
	  style.setFont(font);
	  //设置自动换行; 
	  style.setWrapText(false);
	  //设置水平对齐的样式为居中对齐;  
	  style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
	  //设置垂直对齐的样式为居中对齐; 
	  style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
	  return style;
	}

}