Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

merged cells excel tools

Project description

merged_excel_tools

读取合并单元格的工具类

这是用来读取特定格式(合并单元格)的Excel表格的工具类,格式如下 table.png

install

使用pip

pip install merged_excel_tools

使用方法

from merged_excel_tools import merged_excel
me = merged_excel("example.xlsx")
ranges=me.getMergedList()
for range in ranges:
    # 这是合并单元格的首
    start = range.min_row
    # 这是合并单元格的尾
    end = range.max_row
    #这是A区域的合并单元格的值
    As = me.getValue("A",start)

注意

使用openpyxl来读取excel表格

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for merged-excel-tools, version 1.4
Filename, size File type Python version Upload date Hashes
Filename, size merged_excel_tools-1.4-py3-none-any.whl (2.1 kB) File type Wheel Python version py3 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page