I have my account i would like to access data in spreadsheets:
https://docs.google.com/?tab=mo&pli=1#spreadsheets
documentation is clear how to access separate rows and cells except
how to access certain spreadsheet,
or i am wrongly printing the names of spreadsheets?
Is it possible to get answer with piece of working code:)
/** *************************************************************** */
<?xml version="1.0" encoding="UTF-8" ?>
<Module>
<ModulePrefs title="Sample Spreadsheet Gadget" >
<Require feature="idi"/>
<Require feature="locked-domain"/>
</ModulePrefs>
<Content type="html">
<![CDATA[
var prefs = new gadgets.Prefs();
<script type="text/javascript">
import com.google.gdata.client.spreadsheet.*;
import com.google.gdata.data.*;
import com.google.gdata.data.spreadsheet.*;
import com.google.gdata.util.*;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintStream;
import java.net.URL;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
function displayGreeting () {
URL metafeedUrl = new URL("https://docs.google.com/?
tab=mo&pli=1#spreadsheets");
SpreadsheetFeed feed = service.getFeed(metafeedUrl,
SpreadsheetFeed.class);
List<SpreadsheetEntry> spreadsheets = feed.getEntries();
for (int i = 0; i < spreadsheets.size(); i++) {
SpreadsheetEntry entry = spreadsheets.get(i);
System.out.println("\t" +
entry.getTitle().getPlainText());
}
var html = "";
html += entry.getTitle().getPlainText()
var element = document.getElementById('content_div');
element.style.height=250;
element.style.backgroundColor="red";
element.innerHTML = html;
}
gadgets.util.registerOnLoadHandler(displayGreeting);
</script>
]]>
</Content>
</Module>
/** *************************************** */
--
You received this message because you are subscribed to the Google Groups
"iGoogle Developer Forum" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/Google-Gadgets-API?hl=en.