title: Kivy Listview excel file
body: <p>I have a question regarding Kivy listview and Pandas dataframes. Specifically how to list data from .xlsx to listview of kivy and then lets say delete selected entry.This is my main code:</p>
  
  <pre><code>import pandas
  from kivy.app import App
  from kivy.uix.boxlayout import BoxLayout
  from kivy.properties import ObjectProperty
  from kivy.uix.listview import ListItemButton
  
  class ItemsListItemButton(ListItemButton):
      pass
  
  class QuestionDb(BoxLayout):
      items_list = ObjectProperty()
  
      def dataframe(self):
          df = pandas.read_excel("items.xlsx")
          return df
  
  
  class QuestionApp(App):
      def build(self):
          return QuestionDb()
  
  Questionapp= QuestionApp()
  Questionapp.run()
  </code></pre>
  
  <p>This is question.kv file used to get the listview and button</p>
  
  <pre><code>#: import main question
  #: import ListAdapter kivy.adapters.listadapter.ListAdapter
  #: import LitsItemButton kivy.uix.listview.ListItemButton
  
  
  QuestionDb:
  
  &lt;QuestionDb&gt;:
      items_list:  items_list_view
      ListView:
         id:items_list_view
         adapter:
             ListAdapter(data=main.QuestionDb.dataframe(self) , 
  cls=main.ItemsListItemButton)
      Button:
          text: "Deletes selected entry on press"
  </code></pre>
  
  <p>And this is the excel spreadsheet "items.xlsx" which we set as our dataframe: </p>
  
  <pre><code> Item:  Cost:   Remaining:
   Boots  10$     5
   Socks  2$      4
   Hats   5$      10
  </code></pre>
  
  <p>Now with this setup listview in kivy only shows the column names and lists no other items, how can i make it so that items are listed  example:</p>
  
  <pre><code>Boots  10$     5
  Socks  2$     4
  Hats   5$     10
  </code></pre>
  
  <p>Instead of this</p>
  
  <p><img src="https://i.stack.imgur.com/o2zW6.png" alt=""></p>
  
  <p>Also any tips on how to link the button to afterwards delete the selected entry would be appreciated as well.</p>
  
  <p>Hope this makes sense. </p>