I want to mention I learned how to code from codeacademy which I now see
didn't really teach me more than the basics. Additionally I have a *reading
deficiency*. A reading deficiency means* I have difficulty comprehending
information in a written format*. If someone is able to* talk to me in a
hangout it would be the the fast way for me to understand the explanations*.
Please bare with me as I'm sure this will not be an easy help.
*
*
*Goals:*
- Put RSS data into javascript object
- Split a Javascript object property and place the 2 new strings in new
properties
- Read the new properties back into the spreadsheets with headers that
match the properties
*Problems*
- Can't figure out how to create sequential objects ( Post0001, Post
0002, etc)
- Can't get the correct rows to read into the correct property
The code is limited since I couldn't get past these 2 problems. If you have
any questions as to some of the functions that get called.
I was modifying the code from the Tutorial google provides.
*Here is the Code I tired:*
> function runExample() {
>
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[1];
// Get the range of cells that store the RSS data.
var redditDataRange = ss.getRangeByName("redditRange");
> // For every row of RSS data, generate an Reddit object.
var redditObjects = getRowsData(sheet, redditDataRange);
//Create Numbered Objects Named Post
for (var i = 0;i < redditDataRange.getNumColumns(); i++) {
var post = redditObjects[i];
};
// Checking Objects look the way they should
for (var i = 0;i < redditDataRange.getNumColumns(); i++) {
Logger.log("Date: "+ post[i].originalDate + ", Title: " +
> post[i].redditTitle);
};
// The attempt to chantge the formating of the Original date colum and
> make it into 2 one with just the date and just the time
//for (var i = 0; i < redditDataRange.getNumColumns(); i++){
//var newDates = redditObjects[i].originalDate.split("at");
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
