Skip to main content
 首页 » 编程设计

python之Kivy ListView excel 文件

2025年01月19日10shangdawei

我有一个关于 Kivy listview 和 Pandas dataframes 的问题。具体如何列出数据从 .xlsx 到 kivy 的 ListView ,然后让我们说删除选定的条目。这是我的主要代码:

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() 

这是用于获取 ListView 和按钮的question.kv文件

#: import main question 
#: import ListAdapter kivy.adapters.listadapter.ListAdapter 
#: import LitsItemButton kivy.uix.listview.ListItemButton 
 
 
QuestionDb: 
 
<QuestionDb>: 
    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" 

这是我们设置为数据框的 excel 电子表格“items.xlsx”:

 Item:  Cost:   Remaining: 
 Boots  10$     5 
 Socks  2$      4 
 Hats   5$      10 

现在在 kivy 中使用这个设置 ListView 只显示列名并且不列出其他项目,我怎样才能使项目被列出示例:

Boots  10$     5 
Socks  2$     4 
Hats   5$     10 

代替这个

还有关于如何链接按钮以随后删除所选条目的任何提示也将不胜感激。

希望这是有道理的。

请您参考如下方法:

你应该使用 Recycleview,因为 Listview has been deprecated since version 1.10.0 .

在下面的例子中,我们使用了一个 Recycleview 和 可选择的按钮回收网格布局。 Recycleview 支持上下滚动。我们已将按钮与 on_release 事件绑定(bind)。您还可以更改按钮以绑定(bind) on_press 事件。单击任意行将调用方法 delete_row。

Kivy RecycleView Documentation

例子

问题.py
import pandas 
from kivy.app import App 
from kivy.uix.boxlayout import BoxLayout 
 
from kivy.uix.label import Label 
from kivy.uix.recycleview.views import RecycleDataViewBehavior 
from kivy.uix.button import Button 
from kivy.properties import BooleanProperty, ListProperty, ObjectProperty 
from kivy.uix.recyclegridlayout import RecycleGridLayout 
from kivy.uix.behaviors import FocusBehavior 
from kivy.uix.recycleview.layout import LayoutSelectionBehavior 
from kivy.core.window import Window 
 
 
class SelectableRecycleGridLayout(FocusBehavior, LayoutSelectionBehavior, 
                                  RecycleGridLayout): 
    ''' Adds selection and focus behaviour to the view. ''' 
 
 
class SelectableButton(RecycleDataViewBehavior, Button): 
    ''' Add selection support to the Label ''' 
    index = None 
    selected = BooleanProperty(False) 
    selectable = BooleanProperty(True) 
 
    def refresh_view_attrs(self, rv, index, data): 
        ''' Catch and handle the view changes ''' 
        self.index = index 
        return super(SelectableButton, self).refresh_view_attrs( 
            rv, index, data) 
 
    def on_touch_down(self, touch): 
        ''' Add selection on touch down ''' 
        if super(SelectableButton, self).on_touch_down(touch): 
            return True 
        if self.collide_point(*touch.pos) and self.selectable: 
            return self.parent.select_with_touch(self.index, touch) 
 
    def apply_selection(self, rv, index, is_selected): 
        ''' Respond to the selection of items in the view. ''' 
        self.selected = is_selected 
 
 
class QuestionDb(BoxLayout): 
    items_list = ObjectProperty(None) 
    column_headings = ObjectProperty(None) 
    rv_data = ListProperty([]) 
 
    def __init__(self, **kwargs): 
        super(QuestionDb, self).__init__(**kwargs) 
        self.get_dataframe() 
 
    def get_dataframe(self): 
        df = pandas.read_excel("items.xlsx") 
 
        # Extract and create column headings 
        for heading in df.columns: 
            self.column_headings.add_widget(Label(text=heading)) 
 
        # Extract and create rows 
        data = [] 
        for row in df.itertuples(): 
            for i in range(1, len(row)): 
                data.append([row[i], row[0]]) 
        self.rv_data = [{'text': str(x[0]), 'Index': str(x[1]), 'selectable': True} for x in data] 
 
    def delete_row(self, instance): 
        # TODO 
        print("delete_row:") 
        print("Button: text={0}, index={1}".format(instance.text, instance.index)) 
        print(self.rv_data[instance.index]) 
        print("Pandas: Index={}".format(self.rv_data[instance.index]['Index'])) 
 
 
class QuestionApp(App): 
    def build(self): 
        Window.clearcolor = (1, 1, 1, 1)    # white background 
        return QuestionDb() 
 
 
if __name__ == "__main__": 
    QuestionApp().run() 

问题.kv

#:kivy 1.10.0 
 
<SelectableButton>: 
    # Draw a background to indicate selection 
    canvas.before: 
        Color: 
            rgba: (0, 0.517, 0.705, 1) if self.selected else (0, 0.517, 0.705, 1) 
        Rectangle: 
            pos: self.pos 
            size: self.size 
    background_color: [1, 0, 0, 1]  if self.selected else [1, 1, 1, 1]  # dark red else dark grey 
    on_release: app.root.delete_row(self) 
 
<QuestionDb>: 
    column_headings: column_headings 
    orientation: "vertical" 
 
    Label: 
        canvas.before: 
            Color: 
                rgba: (0, 0, 1, .5)     # 50% translucent blue 
            Rectangle: 
                pos: self.pos 
                size: self.size 
        text: 'Click on any row to delete' 
        size_hint: 1, 0.1 
 
    GridLayout: 
        canvas.before: 
            Color: 
                rgba: (1, 0.2, 0, .5)     # 50% translucent orange red 
            Rectangle: 
                pos: self.pos 
                size: self.size 
 
        id: column_headings 
        size_hint: 1, None 
        size_hint_y: None 
        height: 25 
        cols: 3 
 
    BoxLayout: 
        canvas.before: 
            Color: 
                rgba: (.0, 0.9, .1, .3) 
            Rectangle: 
                pos: self.pos 
                size: self.size 
 
        RecycleView: 
            viewclass: 'SelectableButton' 
            data: root.rv_data 
            SelectableRecycleGridLayout: 
                cols: 3 
                key_selection: 'selectable' 
                default_size: None, dp(26) 
                default_size_hint: 1, None 
                size_hint_y: None 
                height: self.minimum_height 
                multiselect: True 
                touch_multiselect: True 

输出