]> gerrit.simantics Code Review - simantics/interop.git/blobdiff - org.simantics.excel.poi/src/org/simantics/excel/poi/parser/streaming/SheetImpl.java
Excel parsing interface
[simantics/interop.git] / org.simantics.excel.poi / src / org / simantics / excel / poi / parser / streaming / SheetImpl.java
diff --git a/org.simantics.excel.poi/src/org/simantics/excel/poi/parser/streaming/SheetImpl.java b/org.simantics.excel.poi/src/org/simantics/excel/poi/parser/streaming/SheetImpl.java
new file mode 100644 (file)
index 0000000..f45fd21
--- /dev/null
@@ -0,0 +1,675 @@
+package org.simantics.excel.poi.parser.streaming;\r
+\r
+import java.util.Collection;\r
+import java.util.Iterator;\r
+import java.util.List;\r
+import java.util.Map;\r
+\r
+import org.apache.poi.hssf.util.PaneInformation;\r
+import org.apache.poi.ss.usermodel.AutoFilter;\r
+import org.apache.poi.ss.usermodel.Cell;\r
+import org.apache.poi.ss.usermodel.CellRange;\r
+import org.apache.poi.ss.usermodel.CellStyle;\r
+import org.apache.poi.ss.usermodel.Comment;\r
+import org.apache.poi.ss.usermodel.DataValidation;\r
+import org.apache.poi.ss.usermodel.DataValidationHelper;\r
+import org.apache.poi.ss.usermodel.Drawing;\r
+import org.apache.poi.ss.usermodel.Footer;\r
+import org.apache.poi.ss.usermodel.Header;\r
+import org.apache.poi.ss.usermodel.Hyperlink;\r
+import org.apache.poi.ss.usermodel.PrintSetup;\r
+import org.apache.poi.ss.usermodel.Row;\r
+import org.apache.poi.ss.usermodel.Sheet;\r
+import org.apache.poi.ss.usermodel.SheetConditionalFormatting;\r
+import org.apache.poi.ss.usermodel.Workbook;\r
+import org.apache.poi.ss.util.CellAddress;\r
+import org.apache.poi.ss.util.CellRangeAddress;\r
+\r
+public class SheetImpl implements Sheet{\r
+       \r
+       private String name;\r
+       private int index;\r
+       private String id;\r
+       \r
+       public SheetImpl(String name, int index, String id) {\r
+               this.name = name;\r
+               this.index = index;\r
+               this.id = id;\r
+       }\r
+       \r
+       public int getIndex() {\r
+               return index;\r
+       }\r
+       \r
+       public String getId() {\r
+               return id;\r
+       }\r
+       \r
+       @Override\r
+       public int getFirstRowNum() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public int getLastRowNum() {\r
+               return 0;\r
+       }\r
+       \r
+       @Override\r
+       public Row getRow(int rownum) {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public int getPhysicalNumberOfRows() {\r
+               return 0;\r
+       }\r
+       \r
+       @Override\r
+       public Workbook getWorkbook() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public String getSheetName() {\r
+               return name;\r
+       }\r
+       \r
+       \r
+       \r
+       @Override\r
+       public int addMergedRegion(CellRangeAddress region) {\r
+               return 0;\r
+       }\r
+       \r
+       @Override\r
+       public void addValidationData(DataValidation dataValidation) {\r
+               \r
+       }\r
+       \r
+       public void autoSizeColumn(int column) {};\r
+       \r
+       @Override\r
+       public void autoSizeColumn(int column, boolean useMergedCells) {\r
+               \r
+       }\r
+       \r
+       public org.apache.poi.ss.usermodel.Drawing createDrawingPatriarch() {\r
+               return null;\r
+       };\r
+       \r
+       @Override\r
+       public void createFreezePane(int colSplit, int rowSplit) {\r
+               \r
+       }\r
+       \r
+       @Override\r
+       public void createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow) {\r
+               \r
+       }\r
+       \r
+       @Override\r
+       public Row createRow(int rownum) {\r
+               return null;\r
+       }\r
+       \r
+       @Override\r
+       public void createSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane) {\r
+               \r
+       }\r
+       \r
+       @Override\r
+       public boolean getAutobreaks() {\r
+               return false;\r
+       }\r
+       \r
+       @Override\r
+       public Comment getCellComment(int row, int column) {\r
+               return null;\r
+       }\r
+       \r
+       public int[] getColumnBreaks() {\r
+               return null;\r
+       };\r
+       \r
+       @Override\r
+       public CellStyle getColumnStyle(int column) {\r
+               return null;\r
+       }\r
+       \r
+       @Override\r
+       public int getColumnWidth(int columnIndex) {\r
+               return 0;\r
+       }\r
+       \r
+       @Override\r
+       public DataValidationHelper getDataValidationHelper() {\r
+               return null;\r
+       }\r
+       \r
+       public int getDefaultColumnWidth() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public Iterator<Row> iterator() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void removeRow(Row row) {\r
+               \r
+       }\r
+\r
+       \r
+\r
+       \r
+\r
+       @Override\r
+       public void setColumnHidden(int columnIndex, boolean hidden) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isColumnHidden(int columnIndex) {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setRightToLeft(boolean value) {\r
+       \r
+       }\r
+\r
+       @Override\r
+       public boolean isRightToLeft() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setColumnWidth(int columnIndex, int width) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setDefaultColumnWidth(int width) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public short getDefaultRowHeight() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public float getDefaultRowHeightInPoints() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public void setDefaultRowHeight(short height) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setDefaultRowHeightInPoints(float height) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setVerticallyCenter(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setHorizontallyCenter(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean getHorizontallyCenter() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public boolean getVerticallyCenter() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void removeMergedRegion(int index) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public int getNumMergedRegions() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public CellRangeAddress getMergedRegion(int index) {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Iterator<Row> rowIterator() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void setForceFormulaRecalculation(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean getForceFormulaRecalculation() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setAutobreaks(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setDisplayGuts(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setDisplayZeros(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isDisplayZeros() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setFitToPage(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setRowSumsBelow(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setRowSumsRight(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean getDisplayGuts() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public boolean getFitToPage() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public boolean getRowSumsBelow() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public boolean getRowSumsRight() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public boolean isPrintGridlines() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setPrintGridlines(boolean show) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public PrintSetup getPrintSetup() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Header getHeader() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Footer getFooter() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void setSelected(boolean value) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public double getMargin(short margin) {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public void setMargin(short margin, double size) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean getProtect() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void protectSheet(String password) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean getScenarioProtect() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setZoom(int numerator, int denominator) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public short getTopRow() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public short getLeftCol() {\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public void showInPane(int toprow, int leftcol) {\r
+               \r
+       }\r
+\r
+//     @Override\r
+//     public void showInPane(short toprow, short leftcol) {\r
+//             \r
+//     }\r
+\r
+       @Override\r
+       public void shiftRows(int startRow, int endRow, int n) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public PaneInformation getPaneInformation() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void setDisplayGridlines(boolean show) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isDisplayGridlines() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setDisplayFormulas(boolean show) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isDisplayFormulas() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setDisplayRowColHeadings(boolean show) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isDisplayRowColHeadings() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void setRowBreak(int row) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isRowBroken(int row) {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void removeRowBreak(int row) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public int[] getRowBreaks() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void setColumnBreak(int column) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public boolean isColumnBroken(int column) {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void removeColumnBreak(int column) {\r
+                       }\r
+\r
+       @Override\r
+       public void setColumnGroupCollapsed(int columnNumber, boolean collapsed) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void groupColumn(int fromColumn, int toColumn) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void ungroupColumn(int fromColumn, int toColumn) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void groupRow(int fromRow, int toRow) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void ungroupRow(int fromRow, int toRow) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setRowGroupCollapsed(int row, boolean collapse) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setDefaultColumnStyle(int column, CellStyle style) {\r
+               \r
+       }\r
+\r
+       \r
+\r
+       @Override\r
+       public boolean isSelected() {\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public CellRange<? extends Cell> setArrayFormula(String formula, CellRangeAddress range) {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public CellRange<? extends Cell> removeArrayFormula(Cell cell) {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public AutoFilter setAutoFilter(CellRangeAddress range) {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public SheetConditionalFormatting getSheetConditionalFormatting() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public CellRangeAddress getRepeatingRows() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public CellRangeAddress getRepeatingColumns() {\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public void setRepeatingRows(CellRangeAddress rowRangeRef) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setRepeatingColumns(CellRangeAddress columnRangeRef) {\r
+               \r
+       }\r
+\r
+       @Override\r
+       public int addMergedRegionUnsafe(CellRangeAddress arg0) {\r
+               // TODO Auto-generated method stub\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public CellAddress getActiveCell() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Comment getCellComment(CellAddress arg0) {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Map<CellAddress, ? extends Comment> getCellComments() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public int getColumnOutlineLevel(int arg0) {\r
+               // TODO Auto-generated method stub\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public float getColumnWidthInPixels(int arg0) {\r
+               // TODO Auto-generated method stub\r
+               return 0;\r
+       }\r
+\r
+       @Override\r
+       public List<? extends DataValidation> getDataValidations() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Drawing getDrawingPatriarch() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Hyperlink getHyperlink(CellAddress arg0) {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public Hyperlink getHyperlink(int arg0, int arg1) {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public List<? extends Hyperlink> getHyperlinkList() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public List<CellRangeAddress> getMergedRegions() {\r
+               // TODO Auto-generated method stub\r
+               return null;\r
+       }\r
+\r
+       @Override\r
+       public boolean isPrintRowAndColumnHeadings() {\r
+               // TODO Auto-generated method stub\r
+               return false;\r
+       }\r
+\r
+       @Override\r
+       public void removeMergedRegions(Collection<Integer> arg0) {\r
+               // TODO Auto-generated method stub\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setActiveCell(CellAddress arg0) {\r
+               // TODO Auto-generated method stub\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setPrintRowAndColumnHeadings(boolean arg0) {\r
+               // TODO Auto-generated method stub\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void setZoom(int arg0) {\r
+               // TODO Auto-generated method stub\r
+               \r
+       }\r
+\r
+       @Override\r
+       public void validateMergedRegions() {\r
+               // TODO Auto-generated method stub\r
+               \r
+       };\r
+       \r
+       \r
+\r
+       \r
+}\r