23 读取excel
2024-03-26 08:47:31
/**
index mappingname originalname datatype family
0 task_id taskIndexCode STRING info
1 task_type resourceDescType INT32 info
2 camera_index_code cameraIndexCode STRING info
3 camera_address resourceLocation STRING info
* @param path
* @return
* @throws IOException
*/
public static List<String> readHbaseXlsx(String path) throws IOException { InputStream is = new FileInputStream(path); XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is); List<String> jsonList = new ArrayList<>(); int sheetNum = xssfWorkbook.getNumberOfSheets(); // Read the Sheet
for (int numSheet = ; numSheet < sheetNum; numSheet++) { XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet); if (xssfSheet == null) { continue;
}
// Read the Row
for (int rowNum = ; rowNum <= xssfSheet.getLastRowNum(); rowNum++) { XSSFRow xssfRow = xssfSheet.getRow(rowNum); if (xssfRow != null) { XSSFCell indexCell = xssfRow.getCell(); if (indexCell == null) continue; XSSFCell mappingnameCell = xssfRow.getCell(); XSSFCell originalnameCell= xssfRow.getCell(); XSSFCell datatypeCell = xssfRow.getCell(); XSSFCell familyCell = xssfRow.getCell(); String index=indexCell.getStringCellValue();
String originalname;
try {
originalname=originalnameCell.getStringCellValue();
}catch (NullPointerException e){
originalname="";
}
if(null==originalname){
originalname="";
}
String mappingname=mappingnameCell.getStringCellValue();
String datatype=datatypeCell.getStringCellValue();
String family=familyCell.getStringCellValue(); String json=index+","+originalname+","+mappingname+","+datatype+","+family;
jsonList.add(json); }
} xssfWorkbook.cloneSheet(numSheet);
} is.close(); return jsonList;
}
/**
index mappingname originalname datatype family
0 task_id taskIndexCode STRING info
1 task_type resourceDescType INT32 info
2 camera_index_code cameraIndexCode STRING info
3 camera_address resourceLocation STRING info
* @param path
* @return
* @throws IOException
*/
public static List<String> readEsXlsx(String path) throws IOException { InputStream is = new FileInputStream(path); XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is); List<String> jsonList = new ArrayList<>(); int sheetNum = xssfWorkbook.getNumberOfSheets(); // Read the Sheet
for (int numSheet = ; numSheet < sheetNum; numSheet++) { XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(numSheet); if (xssfSheet == null) { continue;
}
// Read the Row
for (int rowNum = ; rowNum <= xssfSheet.getLastRowNum(); rowNum++) { XSSFRow xssfRow = xssfSheet.getRow(rowNum); if (xssfRow != null) { XSSFCell indexCell = xssfRow.getCell(); if (indexCell == null) continue; XSSFCell mappingnameCell = xssfRow.getCell(); XSSFCell originalnameCell= xssfRow.getCell(); XSSFCell datatypeCell = xssfRow.getCell(); String index=indexCell.getStringCellValue();
String originalname;
try {
originalname=originalnameCell.getStringCellValue();
}catch (NullPointerException e){
originalname="";
}
if(null==originalname){
originalname="";
}
String mappingname=mappingnameCell.getStringCellValue();
String datatype=datatypeCell.getStringCellValue(); String json=index+","+originalname+","+mappingname+","+datatype;
jsonList.add(json); }
} xssfWorkbook.cloneSheet(numSheet);
} is.close(); return jsonList;
} /**
* @param xssfRow excel cell
* @return 单元格数据
* @Method Description 2010excel单元格的数据,单元格数据分为：Boolean、numeric、string
*/
private static Object getValue(XSSFCell xssfRow) { if (xssfRow.getCellType() == xssfRow.CELL_TYPE_BOOLEAN) { return xssfRow.getBooleanCellValue(); } else if (xssfRow.getCellType() == xssfRow.CELL_TYPE_NUMERIC) { return xssfRow.getNumericCellValue(); } else { return xssfRow.getStringCellValue(); }
}
写字符串到文件中
public static Boolean writeStringToFile(String filePath,String str){
Boolean success=true;
if(!new File(filePath).exists()){
try {
new File(filePath).createNewFile();
} catch (IOException e) {
e.printStackTrace();
}
}else{
new File(filePath).delete();
try {
new File(filePath).createNewFile();
} catch (IOException e) {
e.printStackTrace();
}
}
FileWriter fileWriter = null;
try {
fileWriter=new FileWriter(filePath);
} catch (IOException e) {
e.printStackTrace();
}
if(null!=fileWriter) {
try {
fileWriter.write(str);
} catch (IOException e) {
e.printStackTrace();
}finally {
try {
fileWriter.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
return success;
}
最新文章
- PHP js使用ajax异步处理方式请求PHP，解决数组中文乱码
- sql 对一张表进行按照不同条件进行多次统计
- OD: Heap Overflow (XP SP2 - 2003) & DWORD SHOOT via Chunk Resize
- C#的DLL注册为COM，Delphi来调用
- Bluez SPP实现代码分析(转)
- Python列表list对象方法总结
- buildroot构建项目（二）--- u-boot 2017.11 建立 2440 开发板
- 所有Windows7下游戏的全屏问题
- texlive测试是否安装成功
- Javascript面向对象编程（三）：非构造函数的继承（对象的深拷贝与浅拷贝）
- .net(C#)常见面试题
- week05 05restful api
- Linux下 jenkins 的 使用
- 洛谷P4138 挂饰 背包
- P4053 [JSOI2007]建筑抢修
- 最新版CocoaPods的安装和使用以及版本升级遇到的问题
- 【R】用 ggplot2 绘制漂亮的分级统计地图
- C# 文件读写系列三
- springboot配置kafka生产者和消费者详解
- Ubuntu下安装使用Xfce4