richard512 / Python Excel Automation
Examples of automation of excel via python, and related useful things
Stars: ✭ 31
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Python Excel Automation
Facetracker
Real time deformable face tracking in C++ with OpenCV 3.
Stars: ✭ 944 (+2945.16%)
Mutual labels: opencv
Kinectwithopencvforunityexample
Kinect with OpenCV for Unity Example
Stars: ✭ 20 (-35.48%)
Mutual labels: opencv
Fourier Descriptors
OpenCV project for my image processing course, horribly bad work.
Stars: ✭ 28 (-9.68%)
Mutual labels: opencv
Air drums
This project enables you to play virtual drums simply by using concepts of image processing and computer vision.
Stars: ✭ 31 (+0%)
Mutual labels: opencv
Tbls
tbls is a CI-Friendly tool for document a database, written in Go.
Stars: ✭ 940 (+2932.26%)
Mutual labels: excel
Gtk Rust By Example
Gtk-Rust by Example (GRBE) - неофициальная книга по разработке GTK GUI, на языке программирования Rust. Практическое использование библиотеки GTK на различных примерах.
Stars: ✭ 30 (-3.23%)
Mutual labels: gtk
Anonymize Video
Replace faces in a video with imaginary persons generated by a progressive GAN deep neural network
Stars: ✭ 15 (-51.61%)
Mutual labels: opencv
Wingpanel Indicator Nightlight
A Wingpanel indicator for Night Light
Stars: ✭ 20 (-35.48%)
Mutual labels: gtk
Deepnude nowatermark withmodel
DeepNude source code，without watermark，with demo and model download link，one command to run offline，GAN/Pytorch/pix2pix/pic2pic
Stars: ✭ 950 (+2964.52%)
Mutual labels: opencv
Xlnt
📊 Cross-platform user-friendly xlsx library for C++11+
Stars: ✭ 876 (+2725.81%)
Mutual labels: excel
Tensorflow object counting api
🚀 The TensorFlow Object Counting API is an open source framework built on top of TensorFlow and Keras that makes it easy to develop object counting systems!
Stars: ✭ 956 (+2983.87%)
Mutual labels: opencv
Reproject Image To 3d
Comparing a OpenCV's reprojectImageTo3D to my own
Stars: ✭ 13 (-58.06%)
Mutual labels: opencv
Enhanced Image Colour Transfer
An Enhanced Implementation of the Colour Transfer Method Proposed by E Reinhard et al.
Stars: ✭ 28 (-9.68%)
Mutual labels: opencv
Rtsp Client Ffmpeg Opencv On Qt
RTSP Client Program using FFmpeg and OpenCV on Qt
Stars: ✭ 31 (+0%)
Mutual labels: opencv
Manjarin Gtk Theme
GTK2 and GTK3 theme developed for the Manjaro-Gnome Edition
Stars: ✭ 30 (-3.23%)
Mutual labels: gtk
Python-Excel-Automation
Examples of automation of excel via python, and related useful things
Contents and compatibility
| script | platform(s) it works on | what it does |
|---|---|---|
| autoclicker.py | linux | uses GTK to check a pixel on the screen. if it's a specified color, the script does a left mouse click |
| copyPaste.py | windows | uses win32com to append one xlsx to another, then saves to csv |
| findPhotoWithinPhoto.py | both | uses opencv to find the location of an image within another image. useful for gui automation |
| openpyxlTest.py | both | uses openpyxl to generate a spreadsheet |
| runMacro.py | windows | uses win32com and excel com to run a VBA function inside of time.xlsm |
| time.py | both | outputs the current date and time |
| time.xlsm | windows | contains a button which executes a VBA function which runs time.py 3 times sequentially without clobbering |
| worksheet1.xlsx | both | a spreadsheet with functions in the "total" row |
| worksheet2.xlsx | both | a spreadsheet with functions in the "total" row |
| xlrdTest.py | both | uses xlrd to enumerate the contents of worksheet1.xlsx |
| Python Library Name | Linux support | Windows support |
|---|---|---|
| GTK | strong | possible to install, but not easily |
| cv2 (opencv) | strong | wonky install, but works |
| pymouse | strong | doesn't seem to work, though it looks like it should |
| win32com | none | strong |
| numpy | strong | strong |
Install Prerequisites (Ubuntu Linux)
sudo apt install python pip python-opencv python-xlrd python-gtk2-dev
Install Prerequisites (Windows 10)
Install Python for Windows
Add the location of python.exe to your PATH environment variable
Download get-pip.py and run it in command prompt:
python get-pip.py
Add the location of pip.exe to your PATH environment variable
Run this in a command prompt
pip install pypiwin32
pip install xlrd
pip install openpyxl
Download the latest OpenCV whl (wheel) file from here then install it like this:
pip install opencv_python-3.2.0-cp36-cp36m-win32.whl
Might need Visual C++ 2015 redistributable (vc_redist.x86.exe) for OpenCV
If you need GTK, follow this guide
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].