package?csvtoexcel;


import?java.io.BufferedReader;
import?java.io.FileOutputStream;
import?java.io.FileReader;
import?java.io.IOException;

import?org.apache.poi.hssf.usermodel.HSSFCell;
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.xssf.usermodel.XSSFCell;
import?org.apache.poi.xssf.usermodel.XSSFRow;
import?org.apache.poi.xssf.usermodel.XSSFSheet;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;


public?class?CsvToExcelUtil?{

	/**
	?*?生成后綴為xls的Excel文件
	?*?@param?csv?要轉(zhuǎn)換的csv文件路徑
	?*?@param?excel?要生成的Excel文件的位置及文件名
	?*?@param?flag?分割規(guī)則（0按逗號(hào)分割）
	?*?@throws?IOException
	?*/
	public?final?static?void?ToExcel（String?csv?String?excel?int?flag）
			throws?IOException?{
		HSSFWorkbook?wb?=?new?HSSFWorkbook（）;
		HSSFSheet?sheet?=?wb.createSheet（“Sheet1“）;

		BufferedReader?r?=?null;

		try?{
			r?=?new?BufferedReader（new?FileReader（csv））;

			int?i?=?0;

			while?（true）?{
				String?ln?=?r.readLine（）;

				if?（ln?==?null）
					break;

				HSSFRow?row?=?sheet.createRow（（short）?i++）;
				int?j?=?0;
				String[]?str_arr;

				if?（flag?==?0）?{
					str_arr?=?ln.split（““）;
				}?else
					str_arr?=?ln.split（“?“）;

				for?（j?=?0;?j?					HSSFCell?cell?=?row.createCell（（short）?j）;
					cell.setCellValue（str_arr[j]）;
				}
			}
		}?finally?{
			if?（r?!=?null）
				r.close（）;
		}

		FileOutputStream?fileOut?=?null;

		try?{
			fileOut?=?new?FileOutputStream（excel）;
			wb.write（fileOut）;
		}?finally?{
			if?（fileOut?!=?null）
				fileOut.close（）;
		}
	}
	/**
	?*?生成后綴為xlsx的Excel文件
	?*?@param?csv?要轉(zhuǎn)換的csv文件路徑
	?*?@param?excel?要生成的Excel文件的位置及文件名
	?*?@param?flag?分割規(guī)則（0按逗號(hào)分割）
	?*?@throws?IOException
	?*/
	public?final?static?void?ToExcelX（String?csv?String?excel?int?flag）
			throws?IOException?{
		XSSFWorkbook?wb?=?new?XSSFWorkbook（）;
		XSSFSheet?sheet?=?wb.createSheet（“Sheet1“）;

		BufferedReader?r?=?null;

		try?{
			r?=?new?BufferedReader（new?FileReader（csv））;

			int?i?=?0;

			while?（true）?{
				String?ln?=?r.readLine（）;

				if?（ln?==?null）
					break;

				XSSFRow?row?=?sheet.createRow（（short）?i++）;
				int?j?=?0;
				String[]?str_arr;

				if?（flag?==?0）?{
					str_arr?=?ln.split（““）;
				}?else
					str_arr?=?ln.split（“\t“）;

				for?（j?=?0;?j?					XSSFCell?cell?=?row.createCell（（short）?j）;
					cell.setCellValue（str_arr[j]）;
				}
			}
		}?finally?{
			if?（r?!=?null）
				r.close（）;
		}

		FileOutputStream?fileOut?=?null;

		try?{
			fileOut?=?new?FileOutputStream（excel）;
			wb.write（fileOut）;
		}?finally?{
			if?（fileOut?!=?null）
				fileOut.close（）;
		}
	}

	public?static?void?main（String[]?args）?throws?IOException?{
		ToExcel（“D:/Workspaces/csvtoexcel/src/kingdee_20121001000000_132939879689_534_t_AcctBal.csv“?“c:/x.xls“?0）;
		ToExcelX（“D:/Workspaces/c

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????956??2016-09-21?19:16??csvtoexcel\.classpath

?????文件????????386??2016-09-21?14:38??csvtoexcel\.project

?????文件????????598??2016-09-21?14:38??csvtoexcel\.settings\org.eclipse.jdt.core.prefs

?????文件???????3896??2016-09-21?19:32??csvtoexcel\bin\csvtoexcel\CsvToExcelUtil.class

?????文件????????195??2016-09-21?15:04??csvtoexcel\bin\kingdee_20121001000000_132939879689_1_customer_base_info.csv

?????文件??????93873??2016-09-21?17:24??csvtoexcel\bin\kingdee_20121001000000_132939879689_534_t_AcctBal.csv

?????文件?????313898??2016-09-21?19:15??csvtoexcel\lib\dom4j-1.6.1.jar

?????文件??????28592??2016-09-21?19:15??csvtoexcel\lib\geronimo-stax-api_1.0_spec-1.0.jar

?????文件??????13417??2016-09-21?14:39??csvtoexcel\lib\javacsv.jar

?????文件?????680408??2016-09-21?14:49??csvtoexcel\lib\jxl.jar

?????文件????1675036??2016-09-21?19:15??csvtoexcel\lib\poi-3.7-20101029.jar

?????文件?????264108??2016-09-21?19:15??csvtoexcel\lib\poi-examples-3.7-20101029.jar

?????文件?????498259??2016-09-21?19:15??csvtoexcel\lib\poi-ooxml-3.7-20101029.jar

?????文件????3967696??2016-09-21?19:15??csvtoexcel\lib\poi-ooxml-schemas-3.7-20101029.jar

?????文件?????840218??2016-09-21?19:15??csvtoexcel\lib\poi-scratchpad-3.7-20101029.jar

?????文件????2666695??2016-09-21?19:15??csvtoexcel\lib\xmlbeans-2.3.0.jar

?????文件???????3247??2016-09-21?19:32??csvtoexcel\src\csvtoexcel\CsvToExcelUtil.java

?????文件????????195??2016-09-21?15:04??csvtoexcel\src\kingdee_20121001000000_132939879689_1_customer_base_info.csv

?????文件??????93873??2016-09-21?17:24??csvtoexcel\src\kingdee_20121001000000_132939879689_534_t_AcctBal.csv

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\bin\csvtoexcel

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\src\csvtoexcel

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\.settings

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\bin

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\lib

?????目錄??????????0??2016-09-21?19:53??csvtoexcel\src

?????目錄??????????0??2016-09-21?19:53??csvtoexcel

-----------?---------??----------?-----??----

?????????????11145546????????????????????26