How to call an Excel VBA Macro from Java Code?

by

I don’t really understand your overall approach to generate Excel sheet from the data in a database. Normally, I’d use Apache POI as proposed by Vivek.

However, if you really need to call an Excel macro in a sheet, then you need two things:

First, you need a JAVA-to-COM bridge like JACOB, COM4J or a similar tool. It is sufficient if it supports automation interfaces. It doesn’t need to have full COM support.

Second, using the JAVA-to-COM bridge, you should start Excel, load the Excel sheet, run the macro, save it and close Excel. So you have to call the equivalent of:

Set Wb = Application.Workbooks.Open FileName
Application.Run MacroName
Wb.Save
Application.Quit

More Related Contents:

  1. How to read and write excel file
  2. Converting JSON to XLS/CSV in Java [closed]
  3. How can I read numeric strings in Excel cells as string (not numbers)?
  4. CSV file with “ID” as first item is corrupt in Excel
  5. Best language to parse extremely large Excel 2007 files [closed]
  6. How to read Excel cell having Date with Apache POI?
  7. JSP generating Excel spreadsheet (XLS) to download
  8. Read XLSX file in Java [closed]
  9. Embed files into Excel using Apache POI
  10. Apache POI – FileInputStream works, File object fails (NullPointerException)
  11. Apache POI add a Series name into LineChart
  12. Apache poi Excel line chart points
  13. How to set axis’ labels in a Line Chart using Apache Poi
  14. Removing a row from an Excel sheet with Apache POI HSSF
  15. Apache POI autoSizeColumn Resizes Incorrectly
  16. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  17. How to read data from XLS (Excel) file [Java, Android]
  18. Password Protected Excel File
  19. Converting number representing a date in Excel to a Java Date object
  20. Create Bar Chart in Excel with Apache POI
  21. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  22. Exception when writing to the xlsx document several times using apache poi 3.7
  23. Apache-POI sorting rows in excel
  24. Java POI : How to read Excel cell value and not the formula computing it?
  25. Apache POI evaluate formula
  26. Embed files into XSSF sheets in Excel, using Apache POI
  27. Apache POI Line Chart colors
  28. Java POI the supplied data appears to be in the Office 2007+ XML
  29. Exporting SQL query result to csv or Excel
  30. Make column read-only using apache poi

Leave a Comment