java将excel2003转string

来源:互联网 发布:视频播放cms 编辑:程序博客网 时间:2024/06/05 20:43

/**
* 读取xls文件内容
*
* @param file 想要读取的文件对象
* @return 返回文件内容
*/
public static String xls2String(File file)
{
String result = “”;
try
{
FileInputStream fis = new FileInputStream(file);
StringBuilder sb = new StringBuilder();
jxl.Workbook rwb = Workbook.getWorkbook(fis);
Sheet[] sheet = rwb.getSheets();
for (int i = 0; i < sheet.length; i++)
{
Sheet rs = rwb.getSheet(i);
for (int j = 0; j < rs.getRows(); j++)
{
Cell[] cells = rs.getRow(j);
for (int k = 0; k < cells.length; k++)
sb.append(cells[k].getContents());
}
}
fis.close();
result += sb.toString();
}
catch (Exception e)
{
e.printStackTrace();
}
return result;
}

0 0
原创粉丝点击