如何用java读取excel文件内容

如何用java读取excel文件内容

读取excel一般使用开源工具包来读取的。因为office文件是经过处理的，用流读到的都是乱码。 你可以自己从百度“java 去读excel”找些资料，一堆一堆的。而且都封装好了，用起来也方便。 我这也有代码。如果你找到的代码都不可用，我再发给你。

本例使用java来读取excel的内容并展出出结果，代码如下： 复制代码 代码如下: import java.io.bufferedinputstream; import java.io.file; import java.io.fileinputstream; import java.io.filenotfoundexception; import java.io.ioexception; import java.text.decimalformat; import java.text.simpledateformat; import java.util.arraylist; import java.util.arrays; import java.util.date; import java.util.list; import org.apache.poi.hssf.usermodel.hssfcell; import org.apache.poi.hssf.usermodel.hssfdateutil; 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.poifs.filesystem.poifsfilesystem; public class exceloperate { public static void main(string[] args) throws exception { file file = new file("exceldemo.xls"); string[][] result = getdata(file, 1); int rowlength = result.length; for(int i=0;i result = new arraylist(); int rowsize = 0; bufferedinputstream in = new bufferedinputstream(new fileinputstream( file)); // 打开hssfworkbook poifsfilesystem fs = new poifsfilesystem(in); hssfworkbook wb = new hssfworkbook(fs); hssfcell cell = null; for (int sheetindex = 0; sheetindex < wb.getnumberofsheets(); sheetindex++) { hssfsheet st = wb.getsheetat(sheetindex); // 第一行为标题，不取 for (int rowindex = ignorerows; rowindex <= st.getlastrownum(); rowindex++) { hssfrow row = st.getrow(rowindex); if (row == null) { continue; } int temprowsize = row.getlastcellnum() + 1; if (temprowsize > rowsize) { rowsize = temprowsize; } string[] values = new string[rowsize]; arrays.fill(values, ""); boolean hasvalue = false; for (short columnindex = 0; columnindex <= row.getlastcellnum(); columnindex++) { string value = ""; cell = row.getcell(columnindex); if (cell != null) { // 注意：一定要设成这个，否则可能会出现乱码 cell.setencoding(hssfcell.encoding_utf_16); switch (cell.getcelltype()) { case hssfcell.cell_type_string: value = cell.getstringcellvalue(); break; case hssfcell.cell_type_numeric: if (hssfdateutil.iscelldateformatted(cell)) { date date = cell.getdatecellvalue(); if (date != null) { value = new simpledateformat("yyyy-mm-dd") .format(date); } else { value = ""; } } else { value = new decimalformat("0").format(cell .getnumericcellvalue()); } break; case hssfcell.cell_type_formula: // 导入时如果为公式生成的数据则无值 if (!cell.getstringcellvalue().equals("")) { value = cell.getstringcellvalue(); } else { value = cell.getnumericcellvalue() + ""; } break; case hssfcell.cell_type_blank: break; case hssfcell.cell_type_error: value = ""; break; case hssfcell.cell_type_boolean: value = (cell.getbooleancellvalue() == true ? "y" : "n"); break; default: value = ""; } } if (columnindex == 0 && value.trim().equals("")) { break; } values[columnindex] = righttrim(value); hasvalue = true; } if (hasvalue) { result.add(values); } } } in.close(); string[][] returnarray = new string[result.size()][rowsize]; for (int i = 0; i < returnarray.length; i++) { returnarray[i] = (string[]) result.get(i); } return returnarray; } public static string righttrim(string str) { if (str == null) { return ""; } int length = str.length(); for (int i = length - 1; i >= 0; i--) { if (str.charat(i) != 0x20) { break; } length--; } return str.substring(0, length); } }