Excel開發人員選項開啟
1.點選檔案
2. 點選項
3. 自訂功能區 ->主要索引標籤->開發人員 打勾
4. 點選開發人員可以看到VBA功能選項
Android SQL https://blog.tarswork.com/post/android-storage-using-sqlite/ Android Excel read https://blog.csdn.net/u010198148/article/details/65044639 https://medium.com/geekculture/creating-an-excel-in-android-cd9c22198619 buildscript { repositories { google() mavenCentral() } ... } implementation 'org.apache.poi:poi:5.2.2' implementation 'org.apache.poi:poi-ooxml:5.2.2' excel bug fix import org.apache.poi.ss.usermodel.DataFormatter; FileInputStream fis = new FileInputStream (workbookName); Workbook workbook = WorkbookFactory.create(fis); Sheet sheet = workbook.getSheet(sheetName); DataFormatter formatter = new DataFormatter (); String val = formatter.formatCellValue(sheet.getRow(row).getCell(col)); list.add(val); //Adding value to list
留言
張貼留言