org.turro.financials.sheets.ReportSheet Class Reference

Public Member Functions
	ReportSheet (File sheetFile, Date date, RegisterView view)
InputStream	getExcel () throws IOException, BiffException, WriteException

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 53 of file ReportSheet.java.

Constructor & Destructor Documentation

ReportSheet()

org.turro.financials.sheets.ReportSheet.ReportSheet	(	File	sheetFile,
		Date	date,
		RegisterView	view
	)

Definition at line 63 of file ReportSheet.java.

                                                                   {
    this.sheetFile = sheetFile;
    this.date = date;
    this.view = view;
    this.year = new CheckDate(date).getYear();
    dao = new FinancialsPU();
  }

Member Function Documentation

getExcel()

InputStream org.turro.financials.sheets.ReportSheet.getExcel

(

)

throws IOException, BiffException, WriteException

Definition at line 71 of file ReportSheet.java.

                                                                                  {
    clearCells = new ArrayList<WritableCell>();
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    WorkbookSettings wsWrite = new WorkbookSettings();
    wsWrite.setEncoding("UTF-8");
    WorkbookSettings wsRead = new WorkbookSettings();
    wsRead.setEncoding("ISO-8859-1");
    WritableWorkbook workbook = Workbook.createWorkbook(baos, Workbook.getWorkbook(sheetFile, wsRead), wsWrite);
    for(WritableSheet sheet : workbook.getSheets()) {
      for(int row = 0; row < sheet.getRows(); row++) {
        for(int col = 0; col < sheet.getColumns(); col++) {
          processCell(sheet, row, col);
        }
      }
      for(WritableCell cell : clearCells) {
        sheet.addCell(new Label(cell.getColumn(), cell.getRow(), ""));
      }
      clearCells.clear();
    }
    workbook.write();
    workbook.close();
    baos.close();
    return new ByteArrayInputStream(baos.toByteArray());
  }

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• ReportSheet.java