excel的数据通过pyecharts生成图表，插入ppt

系统管理员 2021-09-20 11:12 528阅读 0赞

一、安装pyecharts,xlrd

直接采用pip install pyecharts，会安装最新版本，应该是1.2.1，很多接口已经变化了，这里还是安装老版本，且不需要ssl和https认证，命令如下

**pip install -i http://mirrors.aliyun.com/pypi/simple/ pyecharts==0.1.9.4 --trusted-host mirrors.aliyun.com  **

项目网站：[http://pyecharts.herokuapp.com/][http_pyecharts.herokuapp.com]

二、读取excel

import xlrd
    import xlwt
    class excel():
        def read(xlsfile):
            book = xlrd.open_workbook(xlsfile)  # 得到Excel文件的book对象，实例化对象
            sheet0 = book.sheet_by_index(0)  # 通过sheet索引获得sheet对象
            sheet_name = book.sheet_names()[0]  # 获得指定索引的sheet表名字
            sheet1 = book.sheet_by_name(sheet_name)  # 通过sheet名字来获取，当然如果知道sheet名字就可以直接指定
            nrows = sheet0.nrows  # 获取行总数
            ncols = sheet0.ncols  # 获取列总数
            list = []
            for i in range(nrows):
                list.append([])
                for j in range(ncols):
                    # print(sheet0.cell_value(i, j))
                    list[i].append(str(sheet0.cell_value(i, j)))
            print(list)
            return sheet_name,list

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70 1][]

三、生成图表

def excel_to_bar():
        sheet_name,list =excel.read(file_path)
        name_list = []
        data_list= []
        for i in range(1,6):
            name_list.append(list[i][1])
            data_list.append(list[i][2])
        print(name_list)
        # 文件名和sheet名
        mybar = Bar(get_fileName(file_path), sheet_name)
        mybar.add(list[0][2], name_list, data_list)
        mybar.show_config()
        mybar.render(path="bar.html")

`会生成bar.html，直接在浏览器中打开，如下：`![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70 2][]

四、插入ppt

插入内置浏览器控件和按钮，进入VBA编码界面

Private Sub ToggleButton1\_Click()  
    WebBrowser1.Navigate ("file:///D:/Users/PycharmProjects/Cmd/cmd/excel\_pyecharts/render.html")  
End Sub

参考 ：[https://blog.csdn.net/sinat\_40801052/article/details/82556791][https_blog.csdn.net_sinat_40801052_article_details_82556791]

[http_pyecharts.herokuapp.com]: http://pyecharts.herokuapp.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70]: /images/20210726/8fa7296cef69467782f1a2d27859e3d9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70 1]: /images/20210726/8e04b1eade1e4c1588087be7988e4d03.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x1YW5zag_size_16_color_FFFFFF_t_70 2]: /images/20210726/be9e4acb93514eb3b19a10f3e723f896.png
[https_blog.csdn.net_sinat_40801052_article_details_82556791]: https://blog.csdn.net/sinat_40801052/article/details/82556791