需要导入的jar包
具体实现
public class ColumnToString {
public static void main(String[] args) {
new ColumnToString().read();
}
public void read() {
File file = new File("Excel 文件位置(C:\myExcel.xlsx)");
InputStream inputStream = null;
Workbook workbook = null;
try {
inputStream = new FileInputStream(file);
workbook = WorkbookFactory.create(inputStream);
inputStream.close();
//工作表对象
Sheet sheet = workbook.getSheetAt(0);
//总行数
int rowLength = sheet.getLastRowNum()+1;
//根据第一行，获取总列数
Row row = sheet.getRow(0);
//总列数
int colLength = row.getLastCellNum();
//得到指定的单元格
Cell cell = row.getCell(0);
System.out.println("行数：" + rowLength + ",列数：" + colLength);
ArrayList list = new ArrayList();
// 从第二行开始读取
for (int i = 1; i < rowLength; i++) {
row = sheet.getRow(i);
// 获取第二列的内容
cell = row.getCell(1);
if(cell != null){
String temp = cell.getStringCellValue();
if(temp != "EW_N" && !list.contains(temp)){
list.add(temp);
}
}
}
String result = ListToString(list);
System.out.println(list.size());
System.out.println(result);
} catch (Exception e) {
e.printStackTrace();
}
}
// List 集合转换为String
public String ListToString(ArrayList list){
StringBuffer sb = new StringBuffer();
sb.append("(");
for(int i = 0; i < list.size(); i++){
// 最后一个元素不用加逗号
if(i == list.size() - 1){
sb.append("'"+list.get(i)+"'"+"rn");
}else{
sb.append("'"+list.get(i)+"'" + ","+"rn");
}
}
sb.append(");");
return sb.toString();
}
}
