![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Excel操作
liehen2046
这个作者很懒,什么都没留下…
展开
-
python操作excel,只支持xlsx
code # coding=utf-8 import openpyxl from openpyxl import load_workbook from openpyxl.styles import Font, colors def write(file_name, sheet_name, title, rows): wb = openpyxl.Workbook() sheet = wb.create_sheet(index=0, title=sheet_name) sheet.原创 2020-06-04 09:41:51 · 192 阅读 · 0 评论 -
java操作EXCEL
引入 <!--poi对excel2007以上版本的支持--> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <ver...转载 2020-02-27 15:57:23 · 118 阅读 · 0 评论 -
python操作excel,支持xls,xlsx
# coding=utf-8 import logging import xlrd # 读模块 import xlwt # 写模块 logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s') logger = logging.getLogger(__name__) def read_excel(excel_path, sheet_index=None,原创 2020-06-02 09:45:57 · 842 阅读 · 0 评论