Putting result of Java program into Excel cell

Question

I simply want to put the result of a Java program into an Excel cell. Let's assume the result is 5, then my code in main() would look like this:

    XSSFWorkbook wb = C:\Users\Username\Desktop\java-programs\results.xlsm;
    XSSFSheet ExcelSheet = wb.getSheet("numbers");
    XSSFRow row = ExcelSheet.getRow(0);
    XSSFCell cell = row.getCell(0);
    cell.setCellValue(5);

However, this code doesn't compile.

I read some examples on this topic but the code given simply refers to the Excel sheet as (e.g.) "sheet" and then goes on with sheet.getRow(some number). The examples don't explain how I tell Java which workbook to write to.

Possible duplicate of Writing to a particular cell location using Apache POI Excel — fabian
– fabian, Commented Oct 7, 2015 at 14:41
it gives several error messages ... for example: "; expected" and "illegal character '\' " — steady_progress
– steady_progress, Commented Oct 7, 2015 at 14:47

ergonaut · Accepted Answer · 2015-10-07 15:57:31Z

1

Your first line is incorrect.. try this:

 String fileName = "C:/Users/Username/Desktop/java-programs/results.xlsm";
 FileInputStream fileIn = new FileInputStream(fileName);
 Workbook wb = WorkbookFactory.create(fileIn);

 // update the workbook
 wb.getSheet("numbers").getRow(0).getCell(0).setCellValue(5);

 fileIn.close();

 FileOutputStream fileOut = new FileOutputStream(fileName);
 wb.write(fileOut);
 fileOut.close();

edited Oct 7, 2015 at 15:57

answered Oct 7, 2015 at 14:57

ergonaut

7,0671 gold badge21 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

steady_progress Over a year ago

With the code "XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(new File("C:\\Users\\Username\\Desktop\\java-programs\\results.xlsm")));" at the beginning, it now compiles ... I can even run the program without getting an error message .... Alas, the number "5" is not printed into the excel sheet ... nothing is happening there

ergonaut Over a year ago

Did you write it out with a FileOutputStream?

steady_progress Over a year ago

if I use FileOutputStream, I get the following error message when running the file: "The process cannot access the file because it is being used by another process"

steady_progress Over a year ago

The code I added to the previous code was the following: FileOutputStream fileOut = new FileOutputStream("C:\\Users\\Username\\Desktop\\java-programs\\results.xlsm"); wb.write(fileOut); fileOut.close();

ergonaut Over a year ago

fileIn.close(), then create fileOut.

|

Collectives™ on Stack Overflow

Putting result of Java program into Excel cell

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related