Having problem importing data from a google sheets workbook to a master workbook, code cant find first empty...

I cant make the range that i selected go to the first empty row in column A in sheet 1.

Im new to Google-App-Script, and have never done anything in Java before, just read some tutorials.
Im trying to automate some lab machines so that the data they return go to a master workbook.

function macro (){

var s1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var range = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0].getRange('E16:F');

SpreadsheetApp.setActiveRange(range)

var copy = s1.getRange('E16:F36').getValues();

var s2 = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1kXinBTHIhEf78AHe2zpSz6ugi1qgmd5WwqSg81IFrfk/edit?usp=drive_web&ouid=102308466606203090938')

var column = s2.getRange('A:A');

var values = column.getValues();

var ct = 0;

while ( values[ct][0] != "" ) 

ct++;

var lastCell = s2.getRange('E16:F36');

var paste = s2.getRange('ct:B').setValues(copy);

}

I expect the code to set the data from the source workbook to be placed in the first empty row on the master workbook in sheet 1.

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

Google Apps Script is based on javascript not on java

– Rubén
Jan 18 at 21:52

add a comment |

I cant make the range that i selected go to the first empty row in column A in sheet 1.

Im new to Google-App-Script, and have never done anything in Java before, just read some tutorials.
Im trying to automate some lab machines so that the data they return go to a master workbook.

function macro (){

var s1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var range = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0].getRange('E16:F');

SpreadsheetApp.setActiveRange(range)

var copy = s1.getRange('E16:F36').getValues();

var s2 = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1kXinBTHIhEf78AHe2zpSz6ugi1qgmd5WwqSg81IFrfk/edit?usp=drive_web&ouid=102308466606203090938')

var column = s2.getRange('A:A');

var values = column.getValues();

var ct = 0;

while ( values[ct][0] != "" ) 

ct++;

var lastCell = s2.getRange('E16:F36');

var paste = s2.getRange('ct:B').setValues(copy);

}

I expect the code to set the data from the source workbook to be placed in the first empty row on the master workbook in sheet 1.

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

Google Apps Script is based on javascript not on java

– Rubén
Jan 18 at 21:52

add a comment |

I cant make the range that i selected go to the first empty row in column A in sheet 1.

Im new to Google-App-Script, and have never done anything in Java before, just read some tutorials.
Im trying to automate some lab machines so that the data they return go to a master workbook.

function macro (){

var s1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var range = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0].getRange('E16:F');

SpreadsheetApp.setActiveRange(range)

var copy = s1.getRange('E16:F36').getValues();

var s2 = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1kXinBTHIhEf78AHe2zpSz6ugi1qgmd5WwqSg81IFrfk/edit?usp=drive_web&ouid=102308466606203090938')

var column = s2.getRange('A:A');

var values = column.getValues();

var ct = 0;

while ( values[ct][0] != "" ) 

ct++;

var lastCell = s2.getRange('E16:F36');

var paste = s2.getRange('ct:B').setValues(copy);

}

I expect the code to set the data from the source workbook to be placed in the first empty row on the master workbook in sheet 1.

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

I cant make the range that i selected go to the first empty row in column A in sheet 1.

Im new to Google-App-Script, and have never done anything in Java before, just read some tutorials.
Im trying to automate some lab machines so that the data they return go to a master workbook.

function macro (){

var s1 = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

var range = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0].getRange('E16:F');

SpreadsheetApp.setActiveRange(range)

var copy = s1.getRange('E16:F36').getValues();

var s2 = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1kXinBTHIhEf78AHe2zpSz6ugi1qgmd5WwqSg81IFrfk/edit?usp=drive_web&ouid=102308466606203090938')

var column = s2.getRange('A:A');

var values = column.getValues();

var ct = 0;

while ( values[ct][0] != "" ) 

ct++;

var lastCell = s2.getRange('E16:F36');

var paste = s2.getRange('ct:B').setValues(copy);

}

I expect the code to set the data from the source workbook to be placed in the first empty row on the master workbook in sheet 1.

google-apps-script google-sheets

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

edited Jan 18 at 21:47

Rubén

10.7k43567

edited Jan 18 at 21:47

Rubén

10.7k43567

edited Jan 18 at 21:47

Rubén

10.7k43567

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

asked Jan 18 at 17:26

Felipe Pacheco de Sequeira

New contributor

Felipe Pacheco de Sequeira is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Google Apps Script is based on javascript not on java

– Rubén
Jan 18 at 21:52

add a comment |

Google Apps Script is based on javascript not on java

– Rubén
Jan 18 at 21:52

Google Apps Script is based on javascript not on java

– Rubén
Jan 18 at 21:52

add a comment |

2 Answers
2

active

oldest

votes

Need to use getLastRow() method of spreadsheet class

  var lastRow = s2.getLastRow(); 

  var newStartRow = lastRow +1;

and then add 1 to it to define first row to paste your data to.

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

add a comment |

Use appendRow

Appends a row to the spreadsheet. This operation is atomic; it prevents issues where a user asks for the last row, and then writes to that row, and an intervening mutation occurs between getting the last row and writing to it.

answered Jan 18 at 22:01

Rubén

10.7k43567

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

Felipe Pacheco de Sequeira is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54258784%2fhaving-problem-importing-data-from-a-google-sheets-workbook-to-a-master-workbook%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

Need to use getLastRow() method of spreadsheet class

  var lastRow = s2.getLastRow(); 

  var newStartRow = lastRow +1;

and then add 1 to it to define first row to paste your data to.

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

add a comment |

Need to use getLastRow() method of spreadsheet class

  var lastRow = s2.getLastRow(); 

  var newStartRow = lastRow +1;

and then add 1 to it to define first row to paste your data to.

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

add a comment |

Need to use getLastRow() method of spreadsheet class

  var lastRow = s2.getLastRow(); 

  var newStartRow = lastRow +1;

and then add 1 to it to define first row to paste your data to.

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

Need to use getLastRow() method of spreadsheet class

  var lastRow = s2.getLastRow(); 

  var newStartRow = lastRow +1;

and then add 1 to it to define first row to paste your data to.

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

edited Jan 18 at 21:41

toti08

1,74941523

edited Jan 18 at 21:41

toti08

1,74941523

edited Jan 18 at 21:41

toti08

1,74941523

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

answered Jan 18 at 17:47

RobertLCrocker

362

answered Jan 18 at 17:47

RobertLCrocker

362

New contributor

RobertLCrocker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment |

Use appendRow

Appends a row to the spreadsheet. This operation is atomic; it prevents issues where a user asks for the last row, and then writes to that row, and an intervening mutation occurs between getting the last row and writing to it.

answered Jan 18 at 22:01

Rubén

10.7k43567

add a comment |

Use appendRow

Appends a row to the spreadsheet. This operation is atomic; it prevents issues where a user asks for the last row, and then writes to that row, and an intervening mutation occurs between getting the last row and writing to it.

answered Jan 18 at 22:01

Rubén

10.7k43567

add a comment |

Use appendRow

Appends a row to the spreadsheet. This operation is atomic; it prevents issues where a user asks for the last row, and then writes to that row, and an intervening mutation occurs between getting the last row and writing to it.

answered Jan 18 at 22:01

Rubén

10.7k43567

Use appendRow

Appends a row to the spreadsheet. This operation is atomic; it prevents issues where a user asks for the last row, and then writes to that row, and an intervening mutation occurs between getting the last row and writing to it.

answered Jan 18 at 22:01

Rubén

10.7k43567

answered Jan 18 at 22:01

Rubén

10.7k43567

answered Jan 18 at 22:01

Rubén

10.7k43567

answered Jan 18 at 22:01

Rubén

10.7k43567

add a comment |

Felipe Pacheco de Sequeira is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

Felipe Pacheco de Sequeira is a new contributor. Be nice, and check out our Code of Conduct.

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Brtdku