Skip to content

Latest commit

 

History

History
19 lines (12 loc) · 745 Bytes

README.md

File metadata and controls

19 lines (12 loc) · 745 Bytes
Raw

unMergeExcelCell.py - unmerge excel file

Using the python package xlrd and xlwt to unmerge the excel file, and then auto fill the merged cells by the first cell in the merged cells.

For general purpose, unMergeExcelCell.py won't keep the style and format from the origin excel file.

Usage

    Un-merge excel cell and auto fill with the first cell value in the merged cells
    Usage: unMergeExcelCell.py <excel file>
    excel file: the path for un-merging excel file

Notice: unMergeExcelCell.py will make a new excel file by add the sufix _unmerged.

e.g. excel.xlsx -> excel_unmerged.xlsx

In learning we trust !