Styjun

Can you stand up from being prone using Skirmisher outside of your turn?

Why does the Cisco show run command not show the full version, while the show version command does?

c++ diamond problem - How to call base method only once

"Rubric" as meaning "signature" or "personal mark" -- is this accepted usage?

Multiple fireplaces in an apartment building?

Is Diceware more secure than a long passphrase?

Second order approximation of the loss function (Deep learning book, 7.33)

How can I wire a 9-position switch so that each position turns on one more LED than the one before?

How to get even lighting when using flash for group photos near wall?

Israeli soda type drink

What is the least dense liquid under normal conditions?

My admission is revoked after accepting the admission offer

Arriving in Atlanta after US Preclearance in Dublin. Will I go through TSA security in Atlanta to transfer to a connecting flight?

Can I criticise the more senior developers around me for not writing clean code?

Check if a string is entirely made of the same substring

What to do with someone that cheated their way through university and a PhD program?

Raising a bilingual kid. When should we introduce the majority language?

Is Electric Central Heating worth it if using Solar Panels?

How to keep bees out of canned beverages?

Are these square matrices always diagonalisable?

Is it OK if I do not take the receipt in Germany?

How do I check if a string is entirely made of the same substring?

With indentation set to `0em`, when using a line break, there is still an indentation of a size of a space

Expansion//Explosion and Siren Stormtamer

gspread moving through sheets in for loop

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a for loop that will give 50 CSV which then i will upload to spreadsheet through gspread, what i want to do is each time CSV is created it's uploaded to a new sheet, this is my code for now(it works for one csv on the first sheet)

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
cred = ServiceAccountCredentials.from_json_keyfile_name('test1.json', scope)
gc = gspread.authorize(cred)
content = open('shelproducts2.csv', 'r').read()
gc.import_csv('<sheet id>', content.encode("utf-8"))
#gc.create("shelproducts")
content.close()

i tried gc.create("NEW") but this creates a whole other spreadsheet(a different id), what i want to is to move the the sheets then add my CSV file using gc.import_csv(...)

my CSV files will be in a list os.listdir('.')

python gspread

share|improve this question

asked Mar 22 at 15:46

hadesfvhadesfv

717

add a comment | 

0

I have a for loop that will give 50 CSV which then i will upload to spreadsheet through gspread, what i want to do is each time CSV is created it's uploaded to a new sheet, this is my code for now(it works for one csv on the first sheet)

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
cred = ServiceAccountCredentials.from_json_keyfile_name('test1.json', scope)
gc = gspread.authorize(cred)
content = open('shelproducts2.csv', 'r').read()
gc.import_csv('<sheet id>', content.encode("utf-8"))
#gc.create("shelproducts")
content.close()

i tried gc.create("NEW") but this creates a whole other spreadsheet(a different id), what i want to is to move the the sheets then add my CSV file using gc.import_csv(...)

my CSV files will be in a list os.listdir('.')

python gspread

share|improve this question

asked Mar 22 at 15:46

hadesfvhadesfv

717

add a comment | 

I have a for loop that will give 50 CSV which then i will upload to spreadsheet through gspread, what i want to do is each time CSV is created it's uploaded to a new sheet, this is my code for now(it works for one csv on the first sheet)

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
cred = ServiceAccountCredentials.from_json_keyfile_name('test1.json', scope)
gc = gspread.authorize(cred)
content = open('shelproducts2.csv', 'r').read()
gc.import_csv('<sheet id>', content.encode("utf-8"))
#gc.create("shelproducts")
content.close()

i tried gc.create("NEW") but this creates a whole other spreadsheet(a different id), what i want to is to move the the sheets then add my CSV file using gc.import_csv(...)

my CSV files will be in a list os.listdir('.')

python gspread

share|improve this question

asked Mar 22 at 15:46

hadesfvhadesfv

717

import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive']
cred = ServiceAccountCredentials.from_json_keyfile_name('test1.json', scope)
gc = gspread.authorize(cred)
content = open('shelproducts2.csv', 'r').read()
gc.import_csv('<sheet id>', content.encode("utf-8"))
#gc.create("shelproducts")
content.close()

share|improve this question

asked Mar 22 at 15:46

hadesfvhadesfv

717

share|improve this question

asked Mar 22 at 15:46

hadesfvhadesfv

717

asked Mar 22 at 15:46

hadesfvhadesfv

717

asked Mar 22 at 15:46

hadesfvhadesfv

717