关于开发HarmonyOS 鸿蒙Next应用下载xlsx文件

but1_2.setClickedListener(component -> { HiLog.info(label, “clicked”); System.out.println("----------------1");

Workbook book = new XSSFWorkbook(); //创建工作簿

System.out.println("----------------2");
Sheet sheet = book.createSheet(); //创建工作表
String[] title = {"列1","列2","列3","列4","列5"};

Row row = sheet.createRow(0); //创建行

int colNum = title.length;
for (int i = 0; i < colNum; i++) {
    sheet.setColumnWidth(i, 20 * 256);
    Cell cell1 = row.createCell(i);
    cell1.setCellValue(title[i]);
}
row = sheet.createRow(1);
row.setHeightInPoints(28f);

//创建单元格
Cell cell1 = row.createCell(0);
cell1.setCellValue("my1");
Cell cell2 = row.createCell(1);
cell2.setCellValue("my2");
Cell cell3 = row.createCell(2);
cell3.setCellValue("my3");
Cell cell4 = row.createCell(3);
cell4.setCellValue("my4");
Cell cell5 = row.createCell(4);
cell5.setCellValue("my5");
System.out.println("----------------3");

Context context = getContext(); // 数据文件存储路径：/data/data/{PackageName}/{AbilityName}/preferences。

//System.out.println("----------------4>>>"+context);

String mSDCardFolderPath = context.getPreferencesDir() + "/test";
//String mSDCardFolderPath = "我的平板";
//String mSDCardFolderPath ="/entry/resources/rawfile";
//String mSDCardFolderPath = "/data/data/com.example.try6_two/MainAbility/preferences/test";
File dir = new File(mSDCardFolderPath);

String excelPath = mSDCardFolderPath+"/test.xlsx";
//String excelPath = "我的平板/test.xlsx";
//String excelPath = "/entry/resources/rawfile/test.xlsx";
//String excelPath = "/data/data/com.example.try6_two/MainAbility/preferences/test/test.xlsx";

System.out.println("----------------excelPath1>>>"+excelPath);
//   /data/data/com.example.try6_two/MainAbility/preferences/test/test.xlsx
//判断文件是否存在
if (!dir.isFile()) {
    //不存在则创建
    dir.mkdir();
    System.out.println("----------------不存在则创建"+dir.isFile());
}
try {
    // 打开excel文件
    FileOutputStream fos = new FileOutputStream(excelPath);
    System.out.println("----------------one");
    book.write(fos);
    System.out.println("----------------two");
    fos.flush();
    System.out.println("----------------three");
    fos.close();
    System.out.println("----------------four");
    book.close();
    System.out.println("------------写入成功");
}
catch(Exception ex){
    ex.printStackTrace();
}

try {
    // 打开excel文件
    Workbook wb = new XSSFWorkbook(excelPath);
    System.out.println("----------------excelPath>>>"+excelPath);
    int sheetSize = wb.getNumberOfSheets();
    if (sheetSize == 0) {
        HiLog.info(label, "Excel中没有工作表");
        System.out.println("----------------Excel中没有工作表");
    }
    // 获取excel的第一个sheet
    Sheet readSheet = wb.getSheetAt(0);
    int rowTotal = readSheet.getLastRowNum();
    // 遍历单元格获取数据
    for (int i = 0; i < rowTotal; i++) {
        Row tempRow = readSheet.getRow(i);
        for (int j = 0; j < tempRow.getLastCellNum(); j++) {
            String content = tempRow.getCell(j).getStringCellValue();
            HiLog.info(label, content);
            System.out.println("----------------Excel中>>>" + content);
        }
    }
} catch (Exception e) {
    HiLog.error(label, "Exception" + e);
}

});