XSSFWorkbook @Cluster 3 (workbook, xssfsheet, xssfworkbook)

---

SheetXSSFImplTest.java

creates the

43. XSSFWorkbook wb = new XSSFWorkbook();
44. XSSFSheet sheet = wb.createSheet();

---

ExcelReport.java

has our in - memory objects ) the record list is but this method is throws first .

41. XSSFWorkbook wb = new XSSFWorkbook();
44. XSSFSheet dataSheet = wb.createSheet("Data");
52. wb.write(fileOut);

---

XSSFExcelExtractorDecorator.java

sets the

195. XSSFWorkbook document = (XSSFWorkbook) extractor.getDocument();
197. for (int i = 0; i < document.getNumberOfSheets(); i++) {
198.     XSSFSheet sheet = document.getSheetAt(i);

---

XSSFExcelExtractorDecorator.java

initialize the data on a stream .

74. XSSFWorkbook document = (XSSFWorkbook) extractor.getDocument();
76. for (int i = 0; i < document.getNumberOfSheets(); i++) {
78.     XSSFSheet sheet = (XSSFSheet) document.getSheetAt(i);
79.     xhtml.element("h1", document.getSheetName(i));

---

ExcelFamilieBetreuungAU.java

setup is used to get the document ready .

40. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
41. XSSFSheet sheet = xssfWorkbook.createSheet("Familien");
44. XSSFFont font = xssfWorkbook.createFont();
48. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
53. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
177. xssfWorkbook.write(fileOutputStream);

---

ExcelBetreuerinBetreuungAU.java

setup is used to get the document ready .

38. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
39. XSSFSheet sheet = xssfWorkbook.createSheet("Betreuerinnen");
42. XSSFFont font = xssfWorkbook.createFont();
46. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
51. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
175. xssfWorkbook.write(fileOutputStream);

---

ExcelBetreuerinBetreuungAN.java

setup is used to get the document ready .

38. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
39. XSSFSheet sheet = xssfWorkbook.createSheet("Betreuerinnen");
42. XSSFFont font = xssfWorkbook.createFont();
46. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
51. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
175. xssfWorkbook.write(fileOutputStream);

---

ExcelFamilieBetreuung.java

setup is used to get the document ready .

42. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
43. XSSFSheet sheet = xssfWorkbook
47. XSSFFont font = xssfWorkbook.createFont();
51. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
56. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
229. xssfWorkbook.write(fileOutputStream);

---

ExcelBetreuerinnenAN.java

setup is used to get the document ready .

41. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
42. XSSFSheet sheet = xssfWorkbook.createSheet("Betreuerinnen");
45. XSSFFont font = xssfWorkbook.createFont();
49. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
54. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
222. xssfWorkbook.write(fileOutputStream);

---

ExcelBetreuerinnen.java

setup is used to get the document ready .

39. XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
40. XSSFSheet sheet = xssfWorkbook.createSheet("Betreuerinnen");
43. XSSFFont font = xssfWorkbook.createFont();
47. XSSFCellStyle headerStyle = xssfWorkbook.createCellStyle();
52. XSSFCellStyle dataStyle = xssfWorkbook.createCellStyle();
209. xssfWorkbook.write(fileOutputStream);

---

WorkbookXSSFImpl.java

test that we get the same value as excel and , for

63. private XSSFWorkbook workbook;
71.     workbook.createSheet();
85.     workbook.write(stream);        
89.     for (int i=0; i<workbook.getNumberOfSheets();i++) {
90.       workbook.getSheetAt(i).getColumnHelper().cleanColumns();
118.     for(int i = 0; i < workbook.getNumberOfNames(); i++) {
119.         XSSFName name = workbook.getNameAt(i);
137.     return workbook.getSheet(name) != null;
142.     int index = workbook.getSheetIndex(name);
144.         workbook.removeSheetAt(index);
162.     if(workbook.getName(name) != null) {
163.         workbook.removeName(name);
165.     Name xssfName = workbook.createName();
171.     workbook.removeName(name);
194.   XSSFSheet xssfSheet = workbook.createSheet(name);
223.     for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
224.         sheets.add(new SheetXSSFImpl(this, workbook.getSheetAt(i)));
230.     XSSFSheet xssfSheet = workbook.getSheet(name);
240.     XSSFSheet xssfSheet = workbook.getSheetAt(index);
252.     XSSFSheet xssfSheet = workbook.getSheet(setCellValue.getSheet().getName());

---