Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Create an Excel spreadsheet from Groovy (Java) using Apache POI 3.9
def export = {
// create a new file
FileOutputStream out = new FileOutputStream("workbook.xls");
// create a new workbook
Workbook wb = new HSSFWorkbook();
// create a new sheet
Sheet s = wb.createSheet();
int rownum = 0
for (ClaimDocumentReferenceDTO ref : docRefs) {
// create a row
Row r = s.createRow(rownum++)
for (int cellnum=0; cellnum <10; cellnum++) {
Cell c = r.createCell(cellnum);
c.setCellValue( "Test" );
}
}
wb.write(out);
out.close();
}
@wytten

This comment has been minimized.

Copy link
Owner Author

@wytten wytten commented Jun 28, 2013

I also found a good article titled "Turn your JAVA Beans into a POI Excel Spreadsheet" at http://www.dominotricks.com/?p=115

@pabloeglez

This comment has been minimized.

Copy link

@pabloeglez pabloeglez commented Jun 1, 2020

Please can you check, That page can’t be found (http://www.dominotricks.com/?p=115)

@wytten

This comment has been minimized.

Copy link
Owner Author

@wytten wytten commented Jun 1, 2020

Here is my own version of Jeff Byrd's code that previously existed on that website:
https://gist.github.com/wytten/32be05889f84673d6187561699eeb253

@pabloeglez

This comment has been minimized.

Copy link

@pabloeglez pabloeglez commented Jun 1, 2020

Thanks for the information

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment