py4ApachePOI.py

from py4j.java_gateway import JavaGateway


class py4ApachePOI(object):
  def __init__(self):
    self.gateway = None
    self.process = None
    self.gateway = JavaGateway()

  def openFile(self, fileName):
    self.gateway.entry_point.openFile(fileName)

  def writeFile(self, fileName):
    self.gateway.entry_point.writeFile(fileName)

  def createWorkbook(self):
    self.gateway.entry_point.createWorkbook()

  def createSheet(self, sheetName):
    self.gateway.entry_point.createSheet(sheetName)

  def getSheetIndex(self, sheetName):
    return self.gateway.entry_point.getSheetIndex(sheetName)

  def getNumberOfSheets(self):
    return self.gateway.entry_point.getNumberOfSheets()

  def getSheetName(self, sheetIndex):
    return self.gateway.entry_point.getSheetName(sheetIndex)

  def setCellValue(self, sheetIndex, rowIndex, columnIndex, value):
    self.gateway.entry_point.setCellValue(sheetIndex, rowIndex, columnIndex, value)

  def getCellValue(self, sheetIndex, rowIndex, columnIndex):
    return self.gateway.entry_point.getCellValue(sheetIndex, rowIndex, columnIndex)

  def getFirstRowNum(self, sheetIndex):
    return self.gateway.entry_point.getFirstRowNum(sheetIndex)

  def getLastRowNum(self, sheetIndex):
    return self.gateway.entry_point.getLastRowNum(sheetIndex)

  def getFirstCellNum(self, sheetIndex, rowIndex):
    return self.gateway.entry_point.getFirstCellNum(sheetIndex, rowIndex)

  def getLastCellNum(self, sheetIndex, rowIndex):
    return self.gateway.entry_point.getLastCellNum(sheetIndex, rowIndex)

  def setFillForegroundColor(self, sheetIndex, rowIndex, columnIndex, stringBg):
    self.gateway.entry_point.setFillForegroundColor(sheetIndex, rowIndex, columnIndex, stringBg)

  def setCellFormula(self, sheetIndex, rowIndex, columnIndex, stringFormula):
    self.gateway.entry_point.setCellFormula(sheetIndex, rowIndex, columnIndex, stringFormula)

  def removeSheetAt(self, sheetIndex):
    self.gateway.entry_point.removeSheetAt(sheetIndex)

  def setDateCellValue(self, sheetIndex, rowIndex, columnIndex, value):
    self.gateway.entry_point.setDateCellValue(sheetIndex, rowIndex, columnIndex, value)

  def getRowJsonData(self, sheetIndex, startRowIndex, offset):
    return self.gateway.entry_point.getRowJsonData(sheetIndex, startRowIndex, offset)

  def setRowJsonData(self, sheetIndex, rowJsonData):
    return self.gateway.entry_point.setRowJsonData(sheetIndex, rowJsonData)

  def addImage(self, sheetName, rowIndex, columnIndex, imgName, imgType, columnWidth, rowHeight):
    self.gateway.entry_point.addImage(sheetName, rowIndex, columnIndex, imgName, imgType, columnWidth, rowHeight)

  def getImageData(self, sheetIndex, path, imgNamePrefix):
    return self.gateway.entry_point.getImageData(sheetIndex, path, imgNamePrefix)

  def getColumnWidth(self, sheetIndex, columnIndex):
    return self.gateway.entry_point.getColumnWidth(sheetIndex, columnIndex)

  def setColumnWidth(self, sheetIndex, columnIndex, columnWidth):
    self.gateway.entry_point.setColumnWidth(sheetIndex, columnIndex, columnWidth)

  def getRowHeight(self, sheetIndex, rowIndex):
    return self.gateway.entry_point.getRowHeight(sheetIndex, rowIndex)

  def setHeight(self, sheetIndex, rowIndex, rowHeight):
    self.gateway.entry_point.setHeight(sheetIndex, rowIndex, rowHeight)

  def kill(self):
    pass


def main():
  print ("py4Apache main")

if __name__ == "__main__":
    main()