运行环境可参考 读取Excel文件内容
读取Excel单元表名称代码展示:
public static void main(String[] args) throws IOException {
String filePath = "E:\\Property\\WeChat\\WeChat Files\\Subverter7\\Files\\test.xlsx";
String filename = "test.xlsx";
InputStream fileStream = new FileInputStream(new File(filePath));
List<String> stringList = getExcelSheetName(filePath,fileStream);
for(String sheet:stringList){
System.out.println(sheet);
}
}
public static List<String> getExcelSheetName(String filename,InputStream fileStream)
{
List<String> sheetNames = new ArrayList<>();
try
{
Workbook workbook = null;
if(filename.toLowerCase().endsWith("xlsx"))
workbook = new XSSFWorkbook(fileStream);
else
if(filename.toLowerCase().endsWith("xls"))
workbook = new HSSFWorkbook(fileStream);
for(int i=0;i<workbook.getNumberOfSheets();i++)
{
sheetNames.add(workbook.getSheetAt(i).getSheetName());
}
fileStream.close();
}
catch(Exception e)
{
return null;
}
return sheetNames;
}