1 package org.simantics.excel.poi.parser.streaming;
\r
3 import java.util.Collection;
\r
4 import java.util.Iterator;
\r
5 import java.util.List;
\r
6 import java.util.Map;
\r
8 import org.apache.poi.hssf.util.PaneInformation;
\r
9 import org.apache.poi.ss.usermodel.AutoFilter;
\r
10 import org.apache.poi.ss.usermodel.Cell;
\r
11 import org.apache.poi.ss.usermodel.CellRange;
\r
12 import org.apache.poi.ss.usermodel.CellStyle;
\r
13 import org.apache.poi.ss.usermodel.Comment;
\r
14 import org.apache.poi.ss.usermodel.DataValidation;
\r
15 import org.apache.poi.ss.usermodel.DataValidationHelper;
\r
16 import org.apache.poi.ss.usermodel.Drawing;
\r
17 import org.apache.poi.ss.usermodel.Footer;
\r
18 import org.apache.poi.ss.usermodel.Header;
\r
19 import org.apache.poi.ss.usermodel.Hyperlink;
\r
20 import org.apache.poi.ss.usermodel.PrintSetup;
\r
21 import org.apache.poi.ss.usermodel.Row;
\r
22 import org.apache.poi.ss.usermodel.Sheet;
\r
23 import org.apache.poi.ss.usermodel.SheetConditionalFormatting;
\r
24 import org.apache.poi.ss.usermodel.Workbook;
\r
25 import org.apache.poi.ss.util.CellAddress;
\r
26 import org.apache.poi.ss.util.CellRangeAddress;
\r
28 public class SheetImpl implements Sheet{
\r
30 private String name;
\r
34 public SheetImpl(String name, int index, String id) {
\r
40 public int getIndex() {
\r
44 public String getId() {
\r
49 public int getFirstRowNum() {
\r
54 public int getLastRowNum() {
\r
59 public Row getRow(int rownum) {
\r
64 public int getPhysicalNumberOfRows() {
\r
69 public Workbook getWorkbook() {
\r
74 public String getSheetName() {
\r
81 public int addMergedRegion(CellRangeAddress region) {
\r
86 public void addValidationData(DataValidation dataValidation) {
\r
90 public void autoSizeColumn(int column) {};
\r
93 public void autoSizeColumn(int column, boolean useMergedCells) {
\r
97 public org.apache.poi.ss.usermodel.Drawing createDrawingPatriarch() {
\r
102 public void createFreezePane(int colSplit, int rowSplit) {
\r
107 public void createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow) {
\r
112 public Row createRow(int rownum) {
\r
117 public void createSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane) {
\r
122 public boolean getAutobreaks() {
\r
127 public Comment getCellComment(int row, int column) {
\r
131 public int[] getColumnBreaks() {
\r
136 public CellStyle getColumnStyle(int column) {
\r
141 public int getColumnWidth(int columnIndex) {
\r
146 public DataValidationHelper getDataValidationHelper() {
\r
150 public int getDefaultColumnWidth() {
\r
155 public Iterator<Row> iterator() {
\r
160 public void removeRow(Row row) {
\r
169 public void setColumnHidden(int columnIndex, boolean hidden) {
\r
174 public boolean isColumnHidden(int columnIndex) {
\r
179 public void setRightToLeft(boolean value) {
\r
184 public boolean isRightToLeft() {
\r
189 public void setColumnWidth(int columnIndex, int width) {
\r
194 public void setDefaultColumnWidth(int width) {
\r
199 public short getDefaultRowHeight() {
\r
204 public float getDefaultRowHeightInPoints() {
\r
209 public void setDefaultRowHeight(short height) {
\r
214 public void setDefaultRowHeightInPoints(float height) {
\r
219 public void setVerticallyCenter(boolean value) {
\r
224 public void setHorizontallyCenter(boolean value) {
\r
229 public boolean getHorizontallyCenter() {
\r
234 public boolean getVerticallyCenter() {
\r
239 public void removeMergedRegion(int index) {
\r
244 public int getNumMergedRegions() {
\r
249 public CellRangeAddress getMergedRegion(int index) {
\r
254 public Iterator<Row> rowIterator() {
\r
259 public void setForceFormulaRecalculation(boolean value) {
\r
264 public boolean getForceFormulaRecalculation() {
\r
269 public void setAutobreaks(boolean value) {
\r
274 public void setDisplayGuts(boolean value) {
\r
279 public void setDisplayZeros(boolean value) {
\r
284 public boolean isDisplayZeros() {
\r
289 public void setFitToPage(boolean value) {
\r
294 public void setRowSumsBelow(boolean value) {
\r
299 public void setRowSumsRight(boolean value) {
\r
304 public boolean getDisplayGuts() {
\r
309 public boolean getFitToPage() {
\r
314 public boolean getRowSumsBelow() {
\r
319 public boolean getRowSumsRight() {
\r
324 public boolean isPrintGridlines() {
\r
329 public void setPrintGridlines(boolean show) {
\r
334 public PrintSetup getPrintSetup() {
\r
339 public Header getHeader() {
\r
344 public Footer getFooter() {
\r
349 public void setSelected(boolean value) {
\r
354 public double getMargin(short margin) {
\r
359 public void setMargin(short margin, double size) {
\r
364 public boolean getProtect() {
\r
369 public void protectSheet(String password) {
\r
374 public boolean getScenarioProtect() {
\r
379 public void setZoom(int numerator, int denominator) {
\r
384 public short getTopRow() {
\r
389 public short getLeftCol() {
\r
394 public void showInPane(int toprow, int leftcol) {
\r
399 // public void showInPane(short toprow, short leftcol) {
\r
404 public void shiftRows(int startRow, int endRow, int n) {
\r
409 public void shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight) {
\r
414 public PaneInformation getPaneInformation() {
\r
419 public void setDisplayGridlines(boolean show) {
\r
424 public boolean isDisplayGridlines() {
\r
429 public void setDisplayFormulas(boolean show) {
\r
434 public boolean isDisplayFormulas() {
\r
439 public void setDisplayRowColHeadings(boolean show) {
\r
444 public boolean isDisplayRowColHeadings() {
\r
449 public void setRowBreak(int row) {
\r
454 public boolean isRowBroken(int row) {
\r
459 public void removeRowBreak(int row) {
\r
464 public int[] getRowBreaks() {
\r
469 public void setColumnBreak(int column) {
\r
474 public boolean isColumnBroken(int column) {
\r
479 public void removeColumnBreak(int column) {
\r
483 public void setColumnGroupCollapsed(int columnNumber, boolean collapsed) {
\r
488 public void groupColumn(int fromColumn, int toColumn) {
\r
493 public void ungroupColumn(int fromColumn, int toColumn) {
\r
498 public void groupRow(int fromRow, int toRow) {
\r
503 public void ungroupRow(int fromRow, int toRow) {
\r
508 public void setRowGroupCollapsed(int row, boolean collapse) {
\r
513 public void setDefaultColumnStyle(int column, CellStyle style) {
\r
520 public boolean isSelected() {
\r
525 public CellRange<? extends Cell> setArrayFormula(String formula, CellRangeAddress range) {
\r
530 public CellRange<? extends Cell> removeArrayFormula(Cell cell) {
\r
535 public AutoFilter setAutoFilter(CellRangeAddress range) {
\r
540 public SheetConditionalFormatting getSheetConditionalFormatting() {
\r
545 public CellRangeAddress getRepeatingRows() {
\r
550 public CellRangeAddress getRepeatingColumns() {
\r
555 public void setRepeatingRows(CellRangeAddress rowRangeRef) {
\r
560 public void setRepeatingColumns(CellRangeAddress columnRangeRef) {
\r
565 public int addMergedRegionUnsafe(CellRangeAddress arg0) {
\r
566 // TODO Auto-generated method stub
\r
571 public CellAddress getActiveCell() {
\r
572 // TODO Auto-generated method stub
\r
577 public Comment getCellComment(CellAddress arg0) {
\r
578 // TODO Auto-generated method stub
\r
583 public Map<CellAddress, ? extends Comment> getCellComments() {
\r
584 // TODO Auto-generated method stub
\r
589 public int getColumnOutlineLevel(int arg0) {
\r
590 // TODO Auto-generated method stub
\r
595 public float getColumnWidthInPixels(int arg0) {
\r
596 // TODO Auto-generated method stub
\r
601 public List<? extends DataValidation> getDataValidations() {
\r
602 // TODO Auto-generated method stub
\r
607 public Drawing getDrawingPatriarch() {
\r
608 // TODO Auto-generated method stub
\r
613 public Hyperlink getHyperlink(CellAddress arg0) {
\r
614 // TODO Auto-generated method stub
\r
619 public Hyperlink getHyperlink(int arg0, int arg1) {
\r
620 // TODO Auto-generated method stub
\r
625 public List<? extends Hyperlink> getHyperlinkList() {
\r
626 // TODO Auto-generated method stub
\r
631 public List<CellRangeAddress> getMergedRegions() {
\r
632 // TODO Auto-generated method stub
\r
637 public boolean isPrintRowAndColumnHeadings() {
\r
638 // TODO Auto-generated method stub
\r
643 public void removeMergedRegions(Collection<Integer> arg0) {
\r
644 // TODO Auto-generated method stub
\r
649 public void setActiveCell(CellAddress arg0) {
\r
650 // TODO Auto-generated method stub
\r
655 public void setPrintRowAndColumnHeadings(boolean arg0) {
\r
656 // TODO Auto-generated method stub
\r
661 public void setZoom(int arg0) {
\r
662 // TODO Auto-generated method stub
\r
667 public void validateMergedRegions() {
\r
668 // TODO Auto-generated method stub
\r