本帖最后由 Ellia.Duan 于 2023-1-30 18:03 编辑
// 本地打开此文件,对应位置数值是2,但用gcexcel计算结果是1。
Workbook workbook = new Workbook();
workbook.open("C:\\Users\\hanjiansong\\Desktop\\下载\\复现文件.xlsm");
String sheetName = "赔付结构=>";
String rangeAddress = "M27";
IWorksheet worksheet = workbook.getWorksheets().get(sheetName);
IRange range = worksheet.getRange(rangeAddress);
System.out.println(range.getValue());
复现文件.zip
(5.18 MB, 下载次数: 228)
|
|