Guest User

Untitled

a guest
Jan 12th, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. function AcessaVendas () {
  2. var URL = 'jdbc:sqlserver://servername:49159'
  3. var USER = 'visitant'
  4. var PASS = '*******'
  5. var conn = Jdbc.getConnection(URL, USER, PASS);
  6. var stmt = conn.createStatement();
  7. stmt.setMaxRows(10000);
  8. var start = new Date();
  9. var rs = stmt.executeQuery( myquery());
  10. var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Dados");
  11. ss.getRange('a2:h1000').clearContent();
  12. var cell = ss.getRange('a2');
  13. var row = 0;
  14. while (rs.next()) {
  15. for (var col = 0; col < 11; col++) {
  16. cell.offset(row, col).setValue(rs.getString(col + 1));
  17. }
  18. row++;
  19. }
  20. rs.close();
  21. stmt.close();
  22. conn.close();
  23. var end = new Date();
  24. Logger.log('Time elapsed: ' + (end.getTime() - start.getTime()));
  25. }
  26.  
  27. db = "databasename"
  28. URL = 'jdbc:mysql://servername:49159'+'/'+ db;
Add Comment
Please, Sign In to add comment