相關(guān)文章（配置jacob開發(fā)環(huán)境）：https://blog.csdn.net/ZY_extreme/article/details/80007232

/**2018年4月20日 **/ import com.jacob.com.*; import com.jacob.activeX.*;public class ReadExcel {private static ActiveXComponent xl;private static Dispatch workbooks = null;private static Dispatch workbook = null;private static Dispatch sheet = null;private static String filename = null;private static boolean readonly = false;public static void main(String[] args) {String file = "E:\\frequently\\study\\ex.xlsx";OpenExcel(file, false);// false為不顯示打開ExcelSetValue("1","A1","Value","2");System.out.println(GetValue("基礎(chǔ)設(shè)施情況","G10"));CloseExcel(false);}// 打開Excel文檔private static void OpenExcel(String file, boolean f) {try {filename = file;xl = new ActiveXComponent("Excel.Application");xl.setProperty("Visible", new Variant(f));workbooks = xl.getProperty("Workbooks").toDispatch();workbook = Dispatch.invoke(workbooks, "Open", Dispatch.Method,new Object[] { filename, new Variant(false), new Variant(readonly) }, // 是否以只讀方式打開new int[1]).toDispatch();} catch (Exception e) {e.printStackTrace();}}// 關(guān)閉Excel文檔private static void CloseExcel(boolean f) {try {Dispatch.call(workbook, "Save");Dispatch.call(workbook, "Close", new Variant(f));} catch (Exception e) {e.printStackTrace();} finally {xl.invoke("Quit", new Variant[] {});}}// 寫入值--以編號讀寫sheetprivate static void SetValue(String sheetItem ,String position, String type, String value) {// sheet = Dispatch.get(workbook,"ActiveSheet").toDispatch();Dispatch sheets = Dispatch.get(workbook, "Sheets").toDispatch();// 以編號讀寫sheetsheet = Dispatch.invoke(sheets, "Item", Dispatch.Get, new Object[] { new String(sheetItem) }, new int[1]).toDispatch();Dispatch cell = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] { position }, new int[1]).toDispatch();Dispatch.put(cell, type, value);}// 讀取值--以名稱讀寫sheetprivate static String GetValue(String sheetItem,String position) {// sheet = Dispatch.get(workbook,"ActiveSheet").toDispatch();Dispatch sheets = Dispatch.get(workbook, "Sheets").toDispatch();// 以名稱讀寫sheetsheet = Dispatch.invoke(sheets, "Item", Dispatch.Get, new Object[] { new String(sheetItem) }, new int[1]).toDispatch();Dispatch cell = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] { position }, new int[1]).toDispatch();String value = Dispatch.get(cell, "Value").toString();return value;} }

總結(jié)

以上是生活随笔為你收集整理的jacob读写Excel的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。