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.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 83fd2fb890bfa04a75ea0c657f38954afe0d794a4a1e8e846df7529208e8e432 |
|
MD5 | e1c6ed89db3d5baf267b54344b377428 |
|
BLAKE2b-256 | 4a86a42c00c7cee5be4c79af99c2062216cb8a183ae35cc57f9f88a8ab245821 |