Skip to content

Instantly share code, notes, and snippets.

@wytten
Created June 28, 2013 17:26
Show Gist options
  • Select an option

  • Save wytten/5886446 to your computer and use it in GitHub Desktop.

Select an option

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

wytten commented Jun 1, 2020

Copy link
Copy Markdown
Author

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
Copy Markdown

Thanks for the information

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