Excel splitter according to a specific column
Project description
A simple Python project sample structure
This project provides a sample structure for creating python project.
Installation
It is possible to install the tool with pip:
pip install sc-excel-splitter
Configuration
Configuration files reading in this order, the first is the top most priority:
production.xml in current directory,
production.xml in <project_name> directory under User directory,
production.xml in <project_name> directory under /var/opt/sc/ directory,
default.xml in <project_name> directory under /var/opt/sc/ directory.
The default configuration file looks like this:
dev: # whether this program is running is development mode dev_mode: False excel: # 源文件路径 source_file_path: "/path/to/source_excel_file.xlsx" # 导出文件的保存路径 target_directory: "/path/to/target/" # 网点名称列表 branch_list: - "A支行" - "B支行" # 需要按列拆分的Sheet以及拆分所在列 sheet_config: # 需要拆分的Sheet名称,用双引号包围 "Sheet1": # 机构列所在列的索引(从0开始计数,第一列为0,依此类推) branch_column: 3 # 表头所在行的索引(从0开始计数,第一列为0,依此类推) header: 2 # 需要拆分的Sheet名称,用双引号包围 "Sheet2": # 机构列所在列的索引(从0开始计数,第一列为0,依此类推) branch_column: 17 # 表头所在行的索引(从0开始计数,第一列为0,依此类推) header: 0 # 其他需要导出的Sheet名称列表 other_sheets: # Sheet名称 - "Sheet3" # Sheet名称 - "Sheet4"
License
The script is released under the MIT License. The MIT License is registered with and approved by the Open Source Initiative [1].
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
Hashes for sc_excel_splitter-0.0.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e9d6262e62b63c49b30e8684a2923e05a9dde6fb7a05106e0e7fac326c51ff46 |
|
MD5 | 6d6f77f8d01c657f295e2ea1dd0663e2 |
|
BLAKE2b-256 | 968b6ab682ee7cd17a16b8b728e3aace38319fdb7a6a22661a9b0b29567ec9c7 |