Skip to content

Latest commit

 

History

History
52 lines (32 loc) · 1.75 KB

README.md

File metadata and controls

52 lines (32 loc) · 1.75 KB
Raw

Java-Excel-COM-Bridge (2.1)

A library that properly communicates with an excel com object to load, open, modify, get values from, and save any Excel acceptable file. Uses jacob, which is already implemented.

How to use This Bridge:

  • Setting Up, Library is in ~/distribution

            1. Use Java-Excel-COM-Bridge.jar as library either in project or classpath. 
        2. import main.bridge.ExcelWorker;

  • Initialize

                 Loader load = new Loader();
             ExcelWorker worker = new ExcelWorker();

  • Load Workbook (Use any excel supported file here)

                 worker.load(new File("C:\\Workbook.xlsx"));
             //Load with excel window visible 
             worker.load(new File("C:\\Workbook.xlsx"), true);

  • Set Sheet

                 // You must select a work sheet to operate on
             worker.setSheet(3); //Third sheet
             worker.setSheet("Sheet Sample"); //Sheet Titled "Sheet Sample"

  • Use the sheet

                 worker.setCellValue("This is A3", "A3");
             worker.setCellValue(192.03,1,1);
             Object cellVal = worker.getCellValue("D5");
             Object cellVal = worker.getCellValue(5,3);

  • Save the Sheet

                 worker.saveAs(new File("C:\\newWorkbook.xlsx");
             //Either
             worker.save();

  • Destroy the memory

                 load.shutdown();
             //Jacob has to be destoryed manually or else there are lingering
             //Excel processes which leak memory