Return Type

Method

Description

variant

cellData( row, column )

Read the set data of cells by entering rows and columns.

color

cellFillColor( row, column )

Return the background color of cells by entering rows and columns.

color

cellLineColor( row, column )

Return the line color of cells by entering rows and columns.

str

cellText( row, column )

Read the text displayed on cells.

color

cellTextColor( row, column )

Return the text color by entering rows and columns.

clearGridData()

Delete the data set by setGridData.

clearText( startRow, rowCount, startColumn, columnCount )

Remove the text of that cell by selecting the cell area.

int

columnCount()

Read the number of columns.

connect( eventName, func )

Register an event handler of the text table widget.

int

currentPage()

Return the current page.

moveNextPage()

Print the next data based on the current page.

movePrevPage()

Print the previous data based on the current page.

int

rowCount()

Read the number of rows.

list[str]

rowTexts( row )

Read all of text from the selected row.

setCellData( row, column )

Set the data of cells by entering rows and columns.

setCellFillColor( row, column, color )

Set the background color of cells by entering rows and columns.

setCellLineColor( row, column, color )

Set the line color of cells by entering rows and columns.

setCellText( row, column, text )

Set the text of cells by entering rows and columns.

setCellTextColor( row, column, color )

Set the text color of cells by entering rows and columns.

setCellClickable( row, column, clickable )

Set whether the cell is clickable by entering rows and columns.

setCellStyle( row, column, style )

Set the style of cells by entering rows and columns.

setClickable( clickable )

Set whether all of cell is clickable.

setDisplaySelection( enable )

Set whether the cell is selectable.

setGridData( startRow,startColumn,rowCount,columnCount , datas)

Print the data on the selected location. If the number of data exceeded the number of rows, it is able to refer through pages.

int

totalPage()

Return the size of the total pages.

  str cellText( row, column )

  Read the text displayed on the cell.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       text = obj.cellText(0, 1)  # Read the text on (0,1).

       print text

  Output)

      PV Energy

  list[str] rowTexts( row )

  Read the text of the selected row as a list.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       print obj.rowTexts(2)  # Read the text of the second row as a list.

  Output)

      (u'2', u'35', u'36', u'37')

  int rowCount()

   Read the number of rows.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       print obj.rowCount()  # Read the number of rows.

  Output)

      10

  int columnCount()

   Read the number of columns.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       print obj.columnCount()  # Read the number of columns.

  Output)

      4

  setCellText( row , column , text  )

   Set the text of cells by entering rows and columns.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellText(1, 1, '77')  # Set '77' to the (1,1)

  clearText( startRow:Start row, rowCount:The number of rows to remove , startColumn:Start column, columnCount:The number of columns to remove )

   Remove the text of cells by selecting the cell area.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.clearText(1, 4, 1, 3)  # Remove the text by selecting the cell area.

  setCellTextColor( row:Rows, column:Columns, color:Colors )

  setCellTextColor sets the color of the text displayed on cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  ㆍ color: Enter the text color using the QColor object.

  QColor object has to be set RGB color values and transparency values. Each value is an Integer number between 0 to 255.

  QColor object is used as follows.

  ㆍ Function

          QColor(red,green,blue,transparency)

  ㆍ Use example

          - Red: QColor(255,0,0,255)

          - Green: QColor(0,255,0,128)

          - Bluet: QColor(0,0,255,255)

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellTextColor(1, 1, QColor(255,0,0,255))  # Change the text color of (1,1) to QColor(255,0,0,255).

  setCellFillColor( row:Rows, column:Columns, color:Colors )

  setCellFilColor sets the background color of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  ㆍ color: Enter the color using the QColor object.

  QColor object has to be set RGB color values and transparency values. Each value is an Integer number between 0 to 255.

   QColor object is used as follows.

  ㆍ Function

          QColor(red,green,blue,transparency)

  ㆍ Use example

          - Red: QColor(255,0,0,255)

          - Green: QColor(0,255,0,128)

          - Blue: QColor(0,0,255,255)

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellFillColor(1, 1, QColor(0,255,0,128))  # Change the background color of (1,1) to QColor(0,255,0,128).

  setCellLineColor( row:Rows, column:Columns, color:Colors )

  setCellLineColor sets the line color of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  ㆍ color: Enter the line color using the QColor object.

  QColor object has to be set RGB color values and transparency values. Each value is an Integet number between 0 to 255.

  QColor object is used as follows.

  ㆍ Function

          QColor(red,green,blue,transparency)

  ㆍ Use example

          - Red: QColor(255,0,0,255)

          - Green: QColor(0,255,0,128)

          - Blue: QColor(0,0,255,255)

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellLineColor(1, 1, QColor(0,0,255,255))  # Change the line color of (1,1) to QColor(0,0,255,255).

  color cellTextColor( row:Rows, column:Columns )

  cellTextColor returns the text color of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  Example)

       obj = canvas.getObject('Text Table')  # Obtains the text table widget object.

       obj.cellTextColor(1, 1)  # Return the text color of (1,1).

  color cellFillColor( row:Rows, column:Columns )

  cellFillColor returns the background color of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.cellFillColor(1, 1)  # Return the background color of (1,1).

  color cellLineColor( row:Rows, column:Columns )

  cellLineColor returns the line color of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.cellLineColor(1, 1)  # Return the line color of (1,1).

  setDisplaySelection( enable:0 or 1 )

  setDisplaySelection sets whether the cell is selectable.

  ㆍ enable: Enter 0 or 1.

          - If 1 is entered, the cell is selectable.

          - If 0 is entered, the cell is not selectable.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setDisplaySelection(1)  # Set the cell being selectable.

  setCellStyle( row:Rows, column:Columns, style:The style of cells )

  setCellStyle sets the style of cells by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  ㆍ style: Set the style of cells.

          - Button: The cell is changed into button style, and activate clicks.

          - None: The cell is changed into normal style, and deactivate clicks.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellStyle(0, 0, obj.Button)  # Set the cell (0,0) to the button style.

Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellStyle(0, 0, obj.None)  # Set the cell (0,0) to the normal style.

   setCellClickable( row:Rows, column:Columns , clickable:0 or 1 )

  setCellClickable sets whether the cell is clickable by entering rows and columns.

  ㆍ row: Enter rows.

  ㆍ column: Enter columns.

  ㆍ clickable: Enter 0 or 1.

          - If 1 is entered, the cell is clickable.

          - If 0 is entered, the cell is not clickable.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellClickable(2, 3, 1)  # Set the cell (2,3) being clickable.

  setClickable( clickable:0 or 1 )

  setClickable sets whether all of the cell is clickable.

  ㆍ clickable: Enter 0 or 1.

          - If 1 is entered, all of the cell is clickable.

          - If 0 is entered, none of the cell is clickable.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setClickable(1)  # Set all of cell is clickable.

Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setClickable(0)  # Set none of cell is clickable.

  connect( eventName:Event handler name, func:Receiving function )

  Receive an event of the text table widget.

        ㆍ Text table widget occurs events in those cases.

                1) If the cell is clicked.

                2) If the cell is double clicked.

  Example)

       def handleCellSelected(row, column):  # Define handleCellSelected method.

              print 'cell selected'

       def handleCellDoubleClicked(row, column):  # Define handleCellDoubleClicked method.

              print 'cell selected'

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.connect('currentChanged(int, int)', handleCellSelected)  # handleCellSelected is recalled when selecting the cell of the text table widget.

       obj.connect('cellDoubleClicked(int, int)', handleCellDoubleClicked)  # handleCellDoubleClicked is recalled when double clicking the text table widget.

  setGridData( startRow:Start row ,startColumn:Start column ,rowCount:The number of rows, columnCount:The number of columns ,data:Data )

  It is used to print data that exceeded the number of columns. If data exceeds the number of columns, it can refer the data through pages.

  Example) Print data on the red area.

       datas = list()

       # Save the printed data to the list.

       for v in range(0,24):

            columnDatas = list()

            columnDatas.append('%.2d:00' % v)

            columnDatas.append(v)

            columnDatas.append(v)

            columnDatas.append(v)

            datas.append(columnDatas)

       table =canvas.getObject('table')

       # Set the data to the grid.

       table.setGridData(1,0,9,4,datas)

 When executing, the data is printed. If data is more than rows, it is able to refer data through nextPage(), prevPage().

  clearGridData()

  setGridData clears the data of the grid.

  Example) setGridData removes all of the set data on the grid.

       table =canvas.getObject('table')

       # Remove previously set data.

       table.clearGridData()

 Results)

  moveNextPage( )

  If the set data is more than rows, print the next data.

  Example) moveNextPage prints the next data.

       table =canvas.getObject('table')

       # Set the data on the grid.

       table.moveNextPage()

 Results)

  movePrevPage( )

  movePrevPage moves to the previous page.

  Example)

       table =canvas.getObject('table')

       # Set the data on the grid.

       table.movePrevPage()

 Results)

  currentPage( )

  totalPage()

  currentPage returns the current page, totalPage returns the total page number.

  Example)

       datas = list()

          for v in range(0,24):

             columnDatas = list()

             columnDatas.append('%.2d:00' % v)

             columnDatas.append(v)

             columnDatas.append(v)

             columnDatas.append(v)

             datas.append(columnDatas)

       table =canvas.getObject('table')

       table.setGridData(1,0,9,4,datas)

       o = canvas.getObject('totalPage')

       o.setProperty('FaceText',table.totalPage() )

       o = canvas.getObject('currentPage')

       o.setProperty('FaceText',table.currentPage()  )

 Results)

  setCellData( row , column , data  )

   Set a unique value to the cell. It is used to differentiate data by cell category.

  ㆍ Unique value refers to the value used as a key.

  ㆍ For example, if you want to separate data in hourly. Set a unique value to '1am', '2am', '3am', '4am', '5am'.

  Example)

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       obj.setCellData(9, 0, 8)  # Set a unique value as 8 to (9,0) of the text table widget.

  variant cellData( row, column )

  Read a unique value of cells.

  ㆍ Unique value refers the value used as a key.

  Example) Applied usage

       import datetime

       obj = canvas.getObject('Text Table')  # Obtain the text table widget object.

       hour_idx = obj.cellData(9, 0)  # Read the unique value on (9,0) of the text table widget.

       st = datetime.datetime(2019, 1, 1, hour_idx, 0, 0)  << 2019-1-1 0:00:00 of Python datetime format.

       et = st + datetime.timedelta(hours=1)  << Add an hour to the current time.

       data_list = logAnalog.readAnalogLog(‘PV.Positive kWh’, st, et, logAnalog.Time)

       for v in range(0, len(data_list)):        

        if data_list[v].isGood():

                print data_list[v].deltaValue()        # Obtain the variation of 'PV.Positive kWh'.

       data_list = logAnalog.readAnalogLog(‘PCS1.AC_AccumCharge’, st, et, logAnalog.Time)

       for v in range(0, len(data_list)):        

        if data_list[v].isGood():

                print data_list[v].deltaValue()        # Obtain the variation of 'PCS1.AC_AccumCharge'.

       data_list = logAnalog.readAnalogLog(‘PCS1.AC_AccumDisCharge’, st, et, logAnalog.Time)

       for v in range(0, len(data_list)):        

        if data_list[v].isGood():

                print data_list[v].deltaValue()        # Obtain the variation of 'PCS1.AC_AccumDisCharge'.

  Output)

      38.0

      12.0

      0.0