a guest Oct 4th, 2017 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- require "google.auth"
- require "google.spreadsheet"
- local user , pwd
- io.write("Login : ")
- user = io.read()
- io.write("Password : ")
- pwd = io.read()
- local token = google.auth.newToken(user,pwd,google.auth.service.spreadsheet)
- for i,spreadsheet in google.spreadsheet.iGetList(token) do
- local QAP = google.spreadsheet.load(token,google.spreadsheet.getList(token))
- QAP:addWorksheet("TESTING 1")
- local Sheet1 = QAP:getWorksheet("TESTING 1")
- Sheet1:setTitle("Test Sheet")
- sheet:set(1,1,"Bacon Strips !")
RAW Paste Data