google-apps

get value in one column in spreadsheet using google apps script

by

If you use simply : var values = SpreadsheetApp.getActiveSheet().getDataRange().getValues() You will get a 2 Dimension array of all the data in the sheet indexed by rows and columns. So to get the value in column A, row1 you use values[0][0] , values[1][0] for columnA, row 2, values[0][2] for column C row1, etc… If you need … Read more

Send Email via C# through Google Apps account

by

There is no need to hardcode all SMTP settings in your code. Put them in web.config instead. This way you can encrypt these settings if needed and change them on the fly without recompiling your application. <configuration> <system.net> <mailSettings> <smtp from=”example@domain.example” deliveryMethod=”Network”> <network host=”smtp.gmail.com” port=”587″ userName=”example@domain.example” password=”password”/> </smtp> </mailSettings> </system.net> </configuration> End when you send … Read more

Getting Google Spreadsheet CSV into A Pandas Dataframe

by

Seems to work for me without the StringIO: test = pd.read_csv(‘https://docs.google.com/spreadsheets/d/’ + ‘0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc’ + ‘/export?gid=0&format=csv’, # Set first column as rownames in data frame index_col=0, # Parse column values to datetime parse_dates=[‘Quradate’] ) test.head(5) # Same result as @TomAugspurger BTW, including the ?gid= enables importing different sheets, find the gid in the URL.