I recently wrote a piece of software for a friend working on a project, you can find it on github here. The following is from the README.md:
zipcode-distance-excel
This is a command line utility to automatically calculate the distance between two zipcodes and then put the results in an excel (.xlsx) file. It works for US postal codes only.
It was developed to help a colleague and is very application-specific.
Prerequisites
Downloading is easy git, which is already on most systems, on ubuntu use:
1 2 |
sudo apt-get install git |
For everyone else:
Installing
A step by step series of examples that tell you have to get a development env running
Say what the step will be
1 2 3 4 |
git clone https://github.com/esologic/zipcode-distance-excel cd zipcode-distance-excel python3 setup.py install |
Usage
in a directory with the .xlsx file that you want to modify, run:
1 2 |
python3 zde.py |
The program skips the first row in the spreadsheet to avoid headers.
Example Usage
Before:
Terminal output:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
Which file would you like to modify? [0] - International Addresses.xlsx [1] - testbook.xlsx File Number: 1 You've selected [testbook.xlsx] to edit. Which sheet would you like to modify? [0] - Sheet1 [1] - Sheet2 [2] - Sheet3 Sheet Number: 0 You've selected [Sheet1] to edit. Which column to read? (ie. A, B, AA): A Which column to write result? (ie. A, B, AA): B Point A Zipcode? 02114 Job Complete. 10 modifications made. |
After:
Authors
License
This project is licensed under the MIT License