title: why can't i populate my tksheet table row?
body: <ol>
  <li>I am trying to get a students attendance record set up in python. I have most of it figured out. I am stuck on one section and it is the attendane section. I am trying to use a table format (tksheets) to keep record of students names and their attendance. The issue I am having is working with tksheets. I can't seem to get the information from my DB(SQLite3) to populate the columns. I've also tried tktables, and the pandastables. But again I run into the same issue.</li>
  </ol>
  <p>I have considered using the Treeview Widget to populate the columns with the students names, and then use entry boxes to add the attendance. The issue is I have to create each entry box and place it individually. I didn't like this plan. Below is the current code I am using.</p>
  <p>If anyone could show me how to get the data from the DB and populate the spreadsheet I am using that be great. Thanks.</p>
  <pre><code>    def rows(self):
          self.grid_columnconfigure(1, weight=1)
          self.grid_rowconfigure(1,weight=1)
          self.sheet = Sheet(self.aug_tab,
                         data=[[f'Row{r} Column{c}' for c in range(36)]for r in range(24)],
                             height=300,
                             width=900)
          self.sheet.enable_bindings((&quot;single&quot;,
                                           &quot;drag_select&quot;,
                                           &quot;column_drag_and_drop&quot;,
                                           &quot;row_drag_and_drop&quot;,
                                           &quot;column_select&quot;,
                                           &quot;row_select&quot;,
                                           &quot;column_width_resize&quot;,
                                           &quot;double_click_column_resize&quot;,
                                           &quot;row_width_resize&quot;,
                                           &quot;column_height_resize&quot;,
                                           &quot;arrowkeys&quot;,
                                           &quot;row_height_resize&quot;,
                                           &quot;double_click_row_resize&quot;,
                                           &quot;right_click_popup_menu&quot;,
                                           &quot;rc_insert_column&quot;,
                                           &quot;rc_delete_column&quot;,
                                           &quot;rc_insert_row&quot;,
                                           &quot;rc_delete_row&quot;,
                                           &quot;copy&quot;,
                                           &quot;cut&quot;,
                                           &quot;paste&quot;,
                                           &quot;delete&quot;,
                                           &quot;undo&quot;,
                                           &quot;edit_cell&quot;))
             
  
          self.headers_list = (&quot;Student ID&quot;,&quot;Ch. First Name&quot;,&quot;Ch. Last Name&quot;,&quot;Eng. Name&quot;)
          self.headers = [f'{c}'for c in self.headers_list]
          self.sheet.headers(self.headers)
  
          self.sheet.pack()
          print(self.sheet.get_column_data(0,0))
  
      #############DEFINE FUNCTIONS###############################
  
      rows(self)
  </code></pre>
  <p><a href="https://i.stack.imgur.com/5fAag.jpg" rel="nofollow noreferrer">enter image description here</a></p>