上传excel文件

最新推荐文章于 2025-03-03 11:38:36 发布

原创最新推荐文章于 2025-03-03 11:38:36 发布 · 548 阅读

1 ·

CC 4.0 BY-SA版权

java 同时被 2 个专栏收录

23 篇文章

订阅专栏

POI

3 篇文章

订阅专栏

页面：

<html>
<head>
<title>Upload File</title>
</head>
<body>
<form action="file/uploadExcel.json" method="post" enctype="multipart/form-data">
param0<input type="text" name="param"/> <br/>
param1<input type="text" name="param1"/> <br/>
param name<input type="text" name="param2"/> <br/>
param name<input type="text" name="param3"/> <br/>
param name<input type="text" name="param4"/> <br/>
<input type="file" name="file"/><br/>
<input type="submit" value="save"/>
</form>
</body>
</html>

后台：

jar包：spring-web-4.1.3.RELEASE.jar、poi-ooxml-3.9.jar、spring-context、poi-3.9.jar

package pyl.com.user;

import java.io.InputStream;
import java.util.Map;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
@Controller
@RequestMapping("/file")
public class FileController {
/**
* 上传
* @param file
* @param map
* @throws Exception
*/
@RequestMapping("/uploadExcel")
public void uploadExcel(@RequestParam("file") MultipartFile file,
@RequestParam Map<String, String> map) throws Exception {
InputStream in = file.getInputStream();
Workbook wb = WorkbookFactory.create(in);
Sheet sheet = wb.getSheet("中文sheet");
int lastRowNum = sheet.getLastRowNum();
Row row = null;
Cell cell = null;
for (int i = 0; i < lastRowNum; i++) {
row = sheet.getRow(1);
short cellNum = row.getLastCellNum();
StringBuffer sb = new StringBuffer();
for (int j = 0; j < cellNum; j++) {
cell = row.getCell(j);
String cellValue = getCellValue(cell);
sb.append(cellValue).append(",");
}
System.out.println("第" + (i + 1) + "行的数据是：" + sb.toString());
}
}
/**
* 获取cell的
*
* @param cell
* @return
*/
public static String getCellValue(Cell cell) {
String strCell = "";
if (cell != null) {
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
strCell = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_FORMULA:
// cell.getCellFormula();//获取公式字符串
try {// 获取计算后的值
strCell = cell.getNumericCellValue() + "";
} catch (Exception e) {
strCell = cell.getRichStringCellValue() + "";
}
break;
case Cell.CELL_TYPE_NUMERIC:
strCell = String.valueOf(cell.getNumericCellValue());
break;
case Cell.CELL_TYPE_BOOLEAN:
strCell = String.valueOf(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_BLANK:
strCell = "";
break;
default:
strCell = "";
break;
}
}
if (strCell.equals("") || strCell == null) {
strCell = "";
}
return strCell.trim();
}
}