PyExcelSync

PyExcelSync is a tool to get data from another excel file and write the value to existing file.

Example
Take a look at SourceName

In this case, we need to get the value (NO SURAT) of each file and append on the column.
But the problem is... it will take a lot of times if we open one by one right?
Then imagine there is a lot of source file 😭 That's why we need a tool to make our work easier!
Using PyExcelSync will automatically read the values of each files, Then it will add the result to new column, next to SourceName

Installation

PyExcelSync requires Python3 & Pip3 to run.

Create virtualenv first, Then install requirements.txt for the dependencies.

Skip this if you already install the virtualenv

pip3 install virtualenv

Create virtualenv for this project

virtualenv -p python3 <name>

Activate the virtualenv

source <name>/bin/activate
----
to deactivate
deactivate

Install requirements.txt for the dependencies.

pip install -r requirements.txt

Running

Make sure you read this step carefuly before running

• The default file name for work file is works.xlsx

Just replace the file if you want to use ur own with the same name (works.xlsx)

Or change this line to ur own filename (main.py line 19)
file_work = "works.xlsx"

Make sure the extension file is .xlsx!

• The default file header is NoSurat

Change this line to make ur own header name (main.py line 23)
dataSurat.append('NoSurat')

Make sure the header doesn't have a space!

The most important
Make sure you put the source file from list SourceName at file/ folder.

Running the tools In your terminal (virtualenv)

python main.py

And check the result in output.xlsx file