Skip to content

Instantly share code, notes, and snippets.

@wytten
Created June 28, 2013 17:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wytten/5886446 to your computer and use it in GitHub Desktop.
Save wytten/5886446 to your computer and use it in GitHub Desktop.
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
Copy link
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
Copy link

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

@wytten
Copy link
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
Copy link

Thanks for the information

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