Guest User

Untitled

a guest
Sep 26th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. import com.jacob.com.*;
  2. import com.jacob.activeX.*;
  3.  
  4. public class Lesson001
  5. {
  6. public static void main(String[] args) {
  7. ActiveXComponent excelApp = new ActiveXComponent("Excel.Application");
  8. try {
  9. excelApp.setProperty("Visible", new Variant(true));
  10. excelApp.setProperty("DisplayAlerts", new Variant(false)); //警告メッセージをOFF
  11. Dispatch workbooks = Dispatch.get(excelApp, "Workbooks").toDispatch();
  12. Dispatch workbook = Dispatch.call(workbooks, "Open", args[0], new Variant(false), new Variant(true)).toDispatch(); //ブックを読み取り専用で開く
  13. Dispatch worksheets = Dispatch.get(workbook, "Worksheets").toDispatch();
  14. for (int i=1;i<=Dispatch.get(worksheets, "Count").getInt();i++)
  15. {
  16. Dispatch sheet = Dispatch.call(worksheets, "Item", i).toDispatch();
  17. Variant v = Dispatch.call(sheet, "Name");
  18. if (!v.isNull())
  19. System.out.println(v.toString());
  20. }
  21. Dispatch.call(workbook, "Close");
  22. } catch (Exception e) {
  23. e.printStackTrace();
  24. } finally {
  25. excelApp.invoke("Quit", new Variant[] {});
  26. ComThread.Release();
  27. }
  28. }
  29. }
Add Comment
Please, Sign In to add comment