java xlsm_在Java中使用POI框架读取xlsm文件时出错

第一下载这些JAR并将它们添加到构建路径中：

XMLBeans的-2.3.0.jar

POI-OOXML-架构 - 3.7.jar

POI-OOXML-3.9.jar

POI-3.9.jar

的dom4j-1.6.1.jar

现在你可以试试这段代码。它会读取XLSX和XLSM文件：

import java.io.File;

import java.util.Iterator;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.WorkbookFactory;

public class ReadMacroExcel {

public static void main(String[] args) {

try {

//Create a file from the xlsx/xls file

File f=new File("F:\\project realated file\\micro.xlsm");

//Create Workbook instance holding reference to .xlsx file

org.apache.poi.ss.usermodel.Workbook workbook = WorkbookFactory.create(f);

System.out.println(workbook);

//printing number of sheet avilable in workbook

int numberOfS