|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectutil.ExcelWriter
Defines the class used for saving pictures and information to an Excel file.
Field Summary | |
private jxl.write.WritableSheet |
graphSheet
|
private jxl.write.WritableFont |
headerFont
|
private jxl.write.WritableCellFormat |
headerFormat
|
private jxl.write.WritableFont |
plainTextFont
|
private jxl.write.WritableCellFormat |
plainTextFormat
|
private jxl.write.WritableCellFormat |
reqHeaderFormat
|
private jxl.write.WritableFont |
reqXFont
|
private jxl.write.WritableCellFormat |
reqXFormat
|
private jxl.write.WritableSheet |
tableSheet
|
private jxl.write.WritableWorkbook |
workbook
|
Constructor Summary | |
ExcelWriter(java.io.File file)
Creates an ExcelWriter, prepares the Excel workbook to save to and sets the formatting. |
Method Summary | |
void |
writeAndCloseWorkbook()
Flushes the write cache and closes the file. |
void |
writeGraph(java.awt.Image image,
java.lang.String sheetName)
Saves the graph from GraphWindow to a file and to the Excel sheet. |
void |
writeTable(javax.swing.JTable rootCauseTable,
javax.swing.JTable requirementsTable,
java.lang.String sheetName)
Writes the checked rows in the tables in root-cause window to the Excel file. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
private jxl.write.WritableWorkbook workbook
private jxl.write.WritableSheet tableSheet
private jxl.write.WritableSheet graphSheet
private jxl.write.WritableFont reqXFont
private jxl.write.WritableFont headerFont
private jxl.write.WritableFont plainTextFont
private jxl.write.WritableCellFormat reqXFormat
private jxl.write.WritableCellFormat headerFormat
private jxl.write.WritableCellFormat plainTextFormat
private jxl.write.WritableCellFormat reqHeaderFormat
Constructor Detail |
public ExcelWriter(java.io.File file)
file
- the file to save toMethod Detail |
public void writeTable(javax.swing.JTable rootCauseTable, javax.swing.JTable requirementsTable, java.lang.String sheetName)
rootCauseTable
- the table containing root-causes and improvement
suggestions (the left table)requirementsTable
- the table where requirements are added as
columns and linked to root-causessheetName
- the desired sheet name in the workbookpublic void writeGraph(java.awt.Image image, java.lang.String sheetName)
image
- the image to be savedsheetName
- the sheet name to save the graph inpublic void writeAndCloseWorkbook()
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |