It‘s a new project
What is the project about?
When posting articles, I offen need a complex table which contain a lot of information. I have to type it in the markdown file. It's troublesome and cost me too much time.
So I create a python cli tool to simplify the process.
Install
pip install pipenv
git clone https://github.com/littlemucyoung/xls2md.git
cd xls2md
pipenv install
Usage
pipenv shell
$ python xls2md.py --head --from example/excel/data.xls --sindex 0 --to example/markdown/data.md
common usage:
xls2md.py [--head] --from <from_path> [--sindex <sheet_index>|--sname <sheet_name>] --to <to_path>
Demo
excel file: example/excel/data.xls
run
python xls2md.py --head --from example/excel/data.xls --sindex 0 --to example/markdown/data.md
data.md:
| 国家 | GDP总量(亿美元) | 人均GDP(美元) |
|---|---|---|
| 美国 | 186979.22 | 57765.512 |
| 中国 | 122539.75 | 8865.999 |
| 日本 | 41706.43 | 33010.024 |
| 德国 | 34725.07 | 42388.679 |
| 英国 | 30548.4 | 46719.862 |
| 法国 | 24788.48 | 38575.438 |
| 印度 | 23847.26 | 1820.8 |
| 意大利 | 18675.72 | 30540.566 |
| 巴西 | 16728.68 | 8117.645 |
| 加拿大 | 15928.48 | 44095.85 |
Technology Stack
Language: Python
Requirements: xlrd, xlwt, docopt
Development Environment: Pipenv
Roadmap
- v0.1: a demo which only satisfies the basic needs
- v0.2: support more options
- v0.3-0.6: support csv,json,xml,html
- v1.0: build excutable file or be wrapped as a pypi package
Contributing
Github: https://github.com/littlemucyoung/xls2md
Fork it!
Create your feature branch: git checkout -b my-new-feature
Commit your changes: git commit -am 'Add some feature'
Push to the branch: git push origin my-new-feature
Submit a pull request
Posted on Utopian.io - Rewarding Open Source Contributors
Your contribution cannot be approved because it does not follow the Utopian Rules.
Simple and common code snippets that can be easily found or reproduced can't be submitted in the development category.You may consider to re-submit if you have added more features:
Also, there are already more advanced tools like exceltk or pytablewriter
You can contact us on Discord.
[utopian-moderator]
Hey @justyy, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!