Metadata-Version: 2.1
Name: sc-excel-splitter
Version: 0.0.10
Summary: Excel splitter according to a specific column
Home-page: https://github.com/Scott-Lau/sc-excel-splitter
Author: Scott Lau
Author-email: exceedego@126.com
License: MIT
Keywords: python excel splitter
Platform: POSIX
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Topic :: Software Development
Classifier: Topic :: Utilities
Requires-Python: >=3.6
License-File: LICENSE
Requires-Dist: sc-utilities (>=0.0.6)
Requires-Dist: sc-config (>=0.0.8)
Requires-Dist: pandas (>=1.3.1)
Requires-Dist: openpyxl (>=3.0.7)

.. image:: https://badge.fury.io/py/sc-excel-splitter.svg
    :target: https://badge.fury.io/py/sc-excel-splitter
.. image:: https://img.shields.io/pypi/pyversions/sc-excel-splitter
    :alt: PyPI - Python Version

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]_.

.. [1] https://opensource.org/licenses/MIT


