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 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 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 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 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
You can’t perform that action at this time.