This is a summary of everything I helped program in the office.
Items of note indexed by utility for future projects:
| Files |
Description |
| fileex.bat |
How to call a python file from batch file |
| pdfextract.py |
Extrating text from a PDF and exporting it to excel |
| Files |
Description |
| imageImport.bas |
How to import images into excel |
| MergeWorkbooks.bas |
Reading and writing data, saving to csv |
| printCompHistory.bas |
looping through data, printing, and deleting the printed data |
| saveAttachments.bas |
Saving all attachments from multiple emails in outlook |
| shuffleSlides.bas |
rearrange the order of slides in a powerpoint |
| IICM Directory Scripts |
Description |
| Directory.gs |
Custom function: pulls info from range by an index, Custom Menu: Updates custom functions in sheet |
| printToPdf.gs |
Exports current sheet as pdf with specific settings |
| IMOS Data Processor Scripts |
Description |
| KI Form.html |
Upload file select dialog in HTML |
| menu.gs |
An instance of a custom menu in GAS |
| createCustomMenu.gs |
Generic custom menu handling in GAS |
| contactUpload.gs |
Trying to upload contacts to www.contacts.google.com en masse |
| handleContacts.gs |
Manipulating sheet data to prepare for contact upload |
| handleKIData.gs |
Manipulating sheet data, getting unique values from range, insert values to sheet |
| emailRange.gs |
Send an email with a range attached, in this instance, as a CSV |
| copyFullSheet.gs |
Copies an entire sheet from one Spreadsheet to another |
| uploadFileToDrive.gs |
Takes fileData in and uploads it to Google Drive |
| Misc Scripts |
Description |
| IMOS Data Scraper |
Trying to authentiacte in a website and scrape data all from Google Sheets |