![]() ImportCsv("data.csv", spreadsheet, curr_sheet) ImportCsv. (firstRow, firstColumn) = 1_to_rowcol(cell) Worksheet = spreadsheet.add_worksheet(title=curr_date, rows="1000", cols="5")Ĭell - string giving starting cell, optionally including sheet/tab name ![]() # Librariesįrom rvice_account import ServiceAccountCredentialsĬredentials = om_json_keyfile_name("credentials.json", scope) It can be modified to whatever your use case requires. This script create a new worksheet in a pre-defined spreadsheet where the name of the worksheet is current world date. This process can easily be automated and requires zero human interaction once the initial setup is done. csv and import it in Sheets, apply headers, set font size etc (DAILY)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |