Hello! Thank you for being interested, if you are new to coding - a lot of this will seem a bit overwhelming but remember you can always reach out to me via Discord @Beora.
This is a simple repo which aims to tackle the automation of updating images in a spreadsheet so that they include the most recent champions/items/runes
To use this you will need to obtain a Google Oauth2 key, afterwards you will need to import Images to a new sheet, and add your Oauth2 Service Email as an editor
Then you may use the code provided to run set_images() with your url as a parameter and it should update the images in that sheet.
For ease of use you can use sheet_dct in dictionaries.py to store your sheet urls so they are easier to keep track of
Before installing, complete the following tasks:
-
(For beginners) Make sure Python and PIP are added to PATH.
-
During your Python install, you can specify that you'd like to do this by choosing Custom Installation, highly recommend!
-
You'll also need an IDE to code in, I use VSCode.
-
-
Obtain Google Oauth2 credentials (JSON format).
- Might need to google how to do this if you're new to it.
Once you have finished the above tasks, navigate to the directory you'd like to work in and do the following:
-
Clone this repository
git clone https://github.com/Baeora/set_images.git -
Inside said repository, use Pip to install dependencies
pip install -r requirements.txt -
Create a 'JSON' folder in the main
set_imagesdirectory, put your Oauth2 JSON file here. -
Inside
scripts, navigate tocore.pyand replace the following line:service_file = os.path.join(os.path.dirname(Path.cwd()), 'JSONs\\<Your Oauth2 filename>.json')
That should be everything. If you run into errors or spot anything that I missed, please reach out!
MIT License
Copyright (c) 2023 Beora
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.