jacob读写Excel

相关文章（配置jacob开发环境）：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("基础设施情况","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();}}// 关闭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;} }

总结

以上是生活随笔为你收集整理的jacob读写Excel的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。