jars/gss-lib-2.2/javadoc/com/pras/WorkSheet.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r
   2 <!--NewPage-->\r
   3 <HTML>\r
   4 <HEAD>\r
   5 <!-- Generated by javadoc (build 1.5.0_22) on Tue May 10 10:28:01 IST 2011 -->\r
   6 <TITLE>\r
   7 WorkSheet\r
   8 </TITLE>\r
   9 \r
  10 <META NAME="keywords" CONTENT="com.pras.WorkSheet class">\r
  11 \r
  12 <LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style">\r
  13 \r
  14 <SCRIPT type="text/javascript">\r
  15 function windowTitle()\r
  16 {\r
  17     parent.document.title="WorkSheet";\r
  18 }\r
  19 </SCRIPT>\r
  20 <NOSCRIPT>\r
  21 </NOSCRIPT>\r
  22 \r
  23 </HEAD>\r
  24 \r
  25 <BODY BGCOLOR="white" onload="windowTitle();">\r
  26 \r
  27 \r
  28 <!-- ========= START OF TOP NAVBAR ======= -->\r
  29 <A NAME="navbar_top"><!-- --></A>\r
  30 <A HREF="#skip-navbar_top" title="Skip navigation links"></A>\r
  31 <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">\r
  32 <TR>\r
  33 <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">\r
  34 <A NAME="navbar_top_firstrow"><!-- --></A>\r
  35 <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">\r
  36   <TR ALIGN="center" VALIGN="top">\r
  37   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>\r
  38   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>\r
  39   <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>\r
  40   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/WorkSheet.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>\r
  41   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>\r
  42   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>\r
  43   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>\r
  44   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>\r
  45   </TR>\r
  46 </TABLE>\r
  47 </TD>\r
  48 <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>\r
  49 </EM>\r
  50 </TD>\r
  51 </TR>\r
  52 \r
  53 <TR>\r
  54 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">\r
  55 &nbsp;<A HREF="../../com/pras/SpreadSheetFactory.html" title="class in com.pras"><B>PREV CLASS</B></A>&nbsp;\r
  56 &nbsp;<A HREF="../../com/pras/WorkSheetCell.html" title="class in com.pras"><B>NEXT CLASS</B></A></FONT></TD>\r
  57 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">\r
  58   <A HREF="../../index.html?com/pras/WorkSheet.html" target="_top"><B>FRAMES</B></A>  &nbsp;\r
  59 &nbsp;<A HREF="WorkSheet.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;\r
  60 &nbsp;<SCRIPT type="text/javascript">\r
  61   <!--\r
  62   if(window==top) {\r
  63     document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>');\r
  64   }\r
  65   //-->\r
  66 </SCRIPT>\r
  67 <NOSCRIPT>\r
  68   <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>\r
  69 </NOSCRIPT>\r
  70 \r
  71 \r
  72 </FONT></TD>\r
  73 </TR>\r
  74 <TR>\r
  75 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">\r
  76   SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>\r
  77 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">\r
  78 DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>\r
  79 </TR>\r
  80 </TABLE>\r
  81 <A NAME="skip-navbar_top"></A>\r
  82 <!-- ========= END OF TOP NAVBAR ========= -->\r
  83 \r
  84 <HR>\r
  85 <!-- ======== START OF CLASS DATA ======== -->\r
  86 <H2>\r
  87 <FONT SIZE="-1">\r
  88 com.pras</FONT>\r
  89 <BR>\r
  90 Class WorkSheet</H2>\r
  91 <PRE>\r
  92 java.lang.Object\r
  93   <IMG SRC="../../resources/inherit.gif" ALT="extended by "><B>com.pras.WorkSheet</B>\r
  94 </PRE>\r
  95 <HR>\r
  96 <DL>\r
  97 <DT><PRE>public class <B>WorkSheet</B><DT>extends java.lang.Object</DL>\r
  98 </PRE>\r
  99 \r
 100 <P>\r
 101 This class represents an WorkSheet and utility methods to manage WorkSheet data.
 102  WorkSheets will manage (Add/Edit/Delete) data in Tables. It also supports <u>List
 103  based Feed</u>, but only to <b>retrieve data</b>. At present it doesn't provide any method to Add/Edit/Delete
 104  data in List based Feed.
 105  </br>
 106  </br>
 107  <b><a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#TableFeeds">Table Feed</a></b>
 108  </br>
 109  To Add/Edit/Delete Data, you need to use addRecord(), updateRecord() and deleteRecord(). It
 110  internally stores data in a single Table.
 111  </br>
 112  <b>Note:</b> <u>Table Feed will ignore data entered through Web UI.</u>
 113  So, if you want all data records irrespective of from where those are inserted/updated, you should use List Feed.
 114
 115  </br>
 116  </br>
 117  <b><a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListFeeds">List Feed</a></b>
 118  </br>
 119  To Retrieve data using List based Feed, use getData() method.\r
 120 <P>\r
 121 \r
 122 <P>\r
 123 <DL>\r
 124 <DT><B>Author:</B></DT>\r
 125   <DD>Prasanta Paul</DD>\r
 126 </DL>\r
 127 <HR>\r
 128 \r
 129 <P>\r
 130 \r
 131 <!-- ======== CONSTRUCTOR SUMMARY ======== -->\r
 132 \r
 133 <A NAME="constructor_summary"><!-- --></A>\r
 134 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">\r
 135 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">\r
 136 <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">\r
 137 <B>Constructor Summary</B></FONT></TH>\r
 138 </TR>\r
 139 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 140 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#WorkSheet()">WorkSheet</A></B>()</CODE>\r
 141 \r
 142 <BR>\r
 143 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>\r
 144 </TR>\r
 145 </TABLE>\r
 146 &nbsp;\r
 147 <!-- ========== METHOD SUMMARY =========== -->\r
 148 \r
 149 <A NAME="method_summary"><!-- --></A>\r
 150 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">\r
 151 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">\r
 152 <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">\r
 153 <B>Method Summary</B></FONT></TH>\r
 154 </TR>\r
 155 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 156 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 157 <CODE>&nbsp;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A></CODE></FONT></TD>\r
 158 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#addListRow(java.util.HashMap)">addListRow</A></B>(java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</CODE>\r
 159 \r
 160 <BR>\r
 161 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add List Feed row.</TD>\r
 162 </TR>\r
 163 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 164 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 165 <CODE>&nbsp;void</CODE></FONT></TD>\r
 166 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#addRecord(java.lang.String, java.util.HashMap)">addRecord</A></B>(java.lang.String&nbsp;key,\r
 167           java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</CODE>\r
 168 \r
 169 <BR>\r
 170 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add record into WorkSheet.</TD>\r
 171 </TR>\r
 172 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 173 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 174 <CODE>&nbsp;void</CODE></FONT></TD>\r
 175 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#delete()">delete</A></B>()</CODE>\r
 176 \r
 177 <BR>\r
 178 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Delete this WorkSheet.</TD>\r
 179 </TR>\r
 180 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 181 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 182 <CODE>&nbsp;void</CODE></FONT></TD>\r
 183 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#deleteListRow(java.lang.String, com.pras.WorkSheetRow)">deleteListRow</A></B>(java.lang.String&nbsp;key,\r
 184               <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&nbsp;r)</CODE>\r
 185 \r
 186 <BR>\r
 187 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Delete List Row</TD>\r
 188 </TR>\r
 189 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 190 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 191 <CODE>&nbsp;void</CODE></FONT></TD>\r
 192 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#deleteRecord(com.pras.table.Record)">deleteRecord</A></B>(<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&nbsp;record)</CODE>\r
 193 \r
 194 <BR>\r
 195 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Delete a Record</TD>\r
 196 </TR>\r
 197 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 198 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 199 <CODE>&nbsp;int</CODE></FONT></TD>\r
 200 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getColCount()">getColCount</A></B>()</CODE>\r
 201 \r
 202 <BR>\r
 203 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get column count of this WorkSheet</TD>\r
 204 </TR>\r
 205 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 206 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 207 <CODE>&nbsp;java.lang.String[]</CODE></FONT></TD>\r
 208 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getColumns()">getColumns</A></B>()</CODE>\r
 209 \r
 210 <BR>\r
 211 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get columns of the WorkSheet.</TD>\r
 212 </TR>\r
 213 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 214 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 215 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&gt;</CODE></FONT></TD>\r
 216 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getData(boolean)">getData</A></B>(boolean&nbsp;isCachedData)</CODE>\r
 217 \r
 218 <BR>\r
 219 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get all data of this WorkSheet (List based Feed)</TD>\r
 220 </TR>\r
 221 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 222 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 223 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&gt;</CODE></FONT></TD>\r
 224 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getData(boolean, boolean, java.lang.String, java.lang.String)">getData</A></B>(boolean&nbsp;isCachedData,\r
 225         boolean&nbsp;doReverse,\r
 226         java.lang.String&nbsp;sq,\r
 227         java.lang.String&nbsp;orderBy)</CODE>\r
 228 \r
 229 <BR>\r
 230 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List based Feed for a particular Work Sheet.</TD>\r
 231 </TR>\r
 232 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 233 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 234 <CODE>&nbsp;<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A></CODE></FONT></TD>\r
 235 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getEntry()">getEntry</A></B>()</CODE>\r
 236 \r
 237 <BR>\r
 238 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get Entry instance for this WorkSheet.</TD>\r
 239 </TR>\r
 240 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 241 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 242 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt;</CODE></FONT></TD>\r
 243 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getRecords()">getRecords</A></B>()</CODE>\r
 244 \r
 245 <BR>\r
 246 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get Cached Data (previously retrieved from server)</TD>\r
 247 </TR>\r
 248 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 249 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 250 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt;</CODE></FONT></TD>\r
 251 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getRecords(java.lang.String)">getRecords</A></B>(java.lang.String&nbsp;key)</CODE>\r
 252 \r
 253 <BR>\r
 254 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get data stored in this WorkSheet</TD>\r
 255 </TR>\r
 256 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 257 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 258 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt;</CODE></FONT></TD>\r
 259 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getRecords(java.lang.String, boolean, java.lang.String, java.lang.String)">getRecords</A></B>(java.lang.String&nbsp;key,\r
 260            boolean&nbsp;doReverse,\r
 261            java.lang.String&nbsp;sq,\r
 262            java.lang.String&nbsp;orderBy)</CODE>\r
 263 \r
 264 <BR>\r
 265 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get data stored in this WorkSheet.</TD>\r
 266 </TR>\r
 267 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 268 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 269 <CODE>&nbsp;java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt;</CODE></FONT></TD>\r
 270 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getRecords(java.lang.String, java.lang.String)">getRecords</A></B>(java.lang.String&nbsp;key,\r
 271            java.lang.String&nbsp;sq)</CODE>\r
 272 \r
 273 <BR>\r
 274 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>\r
 275 </TR>\r
 276 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 277 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 278 <CODE>&nbsp;int</CODE></FONT></TD>\r
 279 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getRowCount()">getRowCount</A></B>()</CODE>\r
 280 \r
 281 <BR>\r
 282 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get row count of this WorkSheet</TD>\r
 283 </TR>\r
 284 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 285 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 286 <CODE>&nbsp;java.lang.String</CODE></FONT></TD>\r
 287 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getTitle()">getTitle</A></B>()</CODE>\r
 288 \r
 289 <BR>\r
 290 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get WorkSheet Title</TD>\r
 291 </TR>\r
 292 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 293 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 294 <CODE>&nbsp;java.lang.String</CODE></FONT></TD>\r
 295 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getWorkSheetID()">getWorkSheetID</A></B>()</CODE>\r
 296 \r
 297 <BR>\r
 298 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get WorkSheet ID</TD>\r
 299 </TR>\r
 300 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 301 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 302 <CODE>&nbsp;java.lang.String</CODE></FONT></TD>\r
 303 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#getWorkSheetURL()">getWorkSheetURL</A></B>()</CODE>\r
 304 \r
 305 <BR>\r
 306 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Get WorkSheetURL</TD>\r
 307 </TR>\r
 308 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 309 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 310 <CODE>&nbsp;void</CODE></FONT></TD>\r
 311 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setColCount(int)">setColCount</A></B>(int&nbsp;colCount)</CODE>\r
 312 \r
 313 <BR>\r
 314 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set column count of this WorkSheet</TD>\r
 315 </TR>\r
 316 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 317 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 318 <CODE>&nbsp;void</CODE></FONT></TD>\r
 319 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setColumns(java.lang.String[])">setColumns</A></B>(java.lang.String[]&nbsp;columns)</CODE>\r
 320 \r
 321 <BR>\r
 322 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set columns of ListFeed</TD>\r
 323 </TR>\r
 324 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 325 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 326 <CODE>&nbsp;void</CODE></FONT></TD>\r
 327 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setEntry(com.pras.sp.Entry)">setEntry</A></B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A>&nbsp;entry)</CODE>\r
 328 \r
 329 <BR>\r
 330 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set Feed Entry instance</TD>\r
 331 </TR>\r
 332 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 333 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 334 <CODE>&nbsp;void</CODE></FONT></TD>\r
 335 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setRowCount(int)">setRowCount</A></B>(int&nbsp;rowCount)</CODE>\r
 336 \r
 337 <BR>\r
 338 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set row count of this WorkSheet</TD>\r
 339 </TR>\r
 340 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 341 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 342 <CODE>&nbsp;void</CODE></FONT></TD>\r
 343 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setTitle(java.lang.String)">setTitle</A></B>(java.lang.String&nbsp;title)</CODE>\r
 344 \r
 345 <BR>\r
 346 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set WorkSheet Title</TD>\r
 347 </TR>\r
 348 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 349 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 350 <CODE>&nbsp;void</CODE></FONT></TD>\r
 351 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setWorkSheetID(java.lang.String)">setWorkSheetID</A></B>(java.lang.String&nbsp;workSheetID)</CODE>\r
 352 \r
 353 <BR>\r
 354 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set WorkSheet ID</TD>\r
 355 </TR>\r
 356 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 357 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 358 <CODE>&nbsp;void</CODE></FONT></TD>\r
 359 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#setWorkSheetURL(java.lang.String)">setWorkSheetURL</A></B>(java.lang.String&nbsp;workSheetURL)</CODE>\r
 360 \r
 361 <BR>\r
 362 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set WorkSheet</TD>\r
 363 </TR>\r
 364 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 365 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 366 <CODE>&nbsp;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A></CODE></FONT></TD>\r
 367 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#updateListRow(java.lang.String, com.pras.WorkSheetRow, java.util.HashMap)">updateListRow</A></B>(java.lang.String&nbsp;key,\r
 368               <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&nbsp;r,\r
 369               java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</CODE>\r
 370 \r
 371 <BR>\r
 372 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Update List row</TD>\r
 373 </TR>\r
 374 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 375 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">\r
 376 <CODE>&nbsp;void</CODE></FONT></TD>\r
 377 <TD><CODE><B><A HREF="../../com/pras/WorkSheet.html#updateRecord(com.pras.table.Record)">updateRecord</A></B>(<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&nbsp;record)</CODE>\r
 378 \r
 379 <BR>\r
 380 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Record instance you want to Update
 381  Keep only those data which you want to update for this record</TD>\r
 382 </TR>\r
 383 </TABLE>\r
 384 &nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>\r
 385 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">\r
 386 <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">\r
 387 <TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>\r
 388 </TR>\r
 389 <TR BGCOLOR="white" CLASS="TableRowColor">\r
 390 <TD><CODE>equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>\r
 391 </TR>\r
 392 </TABLE>\r
 393 &nbsp;\r
 394 <P>\r
 395 \r
 396 <!-- ========= CONSTRUCTOR DETAIL ======== -->\r
 397 \r
 398 <A NAME="constructor_detail"><!-- --></A>\r
 399 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">\r
 400 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">\r
 401 <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">\r
 402 <B>Constructor Detail</B></FONT></TH>\r
 403 </TR>\r
 404 </TABLE>\r
 405 \r
 406 <A NAME="WorkSheet()"><!-- --></A><H3>\r
 407 WorkSheet</H3>\r
 408 <PRE>\r
 409 public <B>WorkSheet</B>()</PRE>\r
 410 <DL>\r
 411 </DL>\r
 412 \r
 413 <!-- ============ METHOD DETAIL ========== -->\r
 414 \r
 415 <A NAME="method_detail"><!-- --></A>\r
 416 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">\r
 417 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">\r
 418 <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">\r
 419 <B>Method Detail</B></FONT></TH>\r
 420 </TR>\r
 421 </TABLE>\r
 422 \r
 423 <A NAME="getWorkSheetID()"><!-- --></A><H3>\r
 424 getWorkSheetID</H3>\r
 425 <PRE>\r
 426 public java.lang.String <B>getWorkSheetID</B>()</PRE>\r
 427 <DL>\r
 428 <DD>Get WorkSheet ID\r
 429 <P>\r
 430 <DD><DL>\r
 431 \r
 432 <DT><B>Returns:</B><DD></DL>\r
 433 </DD>\r
 434 </DL>\r
 435 <HR>\r
 436 \r
 437 <A NAME="setWorkSheetID(java.lang.String)"><!-- --></A><H3>\r
 438 setWorkSheetID</H3>\r
 439 <PRE>\r
 440 public void <B>setWorkSheetID</B>(java.lang.String&nbsp;workSheetID)</PRE>\r
 441 <DL>\r
 442 <DD>Set WorkSheet ID\r
 443 <P>\r
 444 <DD><DL>\r
 445 <DT><B>Parameters:</B><DD><CODE>workSheetID</CODE> - </DL>\r
 446 </DD>\r
 447 </DL>\r
 448 <HR>\r
 449 \r
 450 <A NAME="getWorkSheetURL()"><!-- --></A><H3>\r
 451 getWorkSheetURL</H3>\r
 452 <PRE>\r
 453 public java.lang.String <B>getWorkSheetURL</B>()</PRE>\r
 454 <DL>\r
 455 <DD>Get WorkSheetURL\r
 456 <P>\r
 457 <DD><DL>\r
 458 \r
 459 <DT><B>Returns:</B><DD></DL>\r
 460 </DD>\r
 461 </DL>\r
 462 <HR>\r
 463 \r
 464 <A NAME="setWorkSheetURL(java.lang.String)"><!-- --></A><H3>\r
 465 setWorkSheetURL</H3>\r
 466 <PRE>\r
 467 public void <B>setWorkSheetURL</B>(java.lang.String&nbsp;workSheetURL)</PRE>\r
 468 <DL>\r
 469 <DD>Set WorkSheet\r
 470 <P>\r
 471 <DD><DL>\r
 472 <DT><B>Parameters:</B><DD><CODE>workSheetURL</CODE> - </DL>\r
 473 </DD>\r
 474 </DL>\r
 475 <HR>\r
 476 \r
 477 <A NAME="getTitle()"><!-- --></A><H3>\r
 478 getTitle</H3>\r
 479 <PRE>\r
 480 public java.lang.String <B>getTitle</B>()</PRE>\r
 481 <DL>\r
 482 <DD>Get WorkSheet Title\r
 483 <P>\r
 484 <DD><DL>\r
 485 \r
 486 <DT><B>Returns:</B><DD></DL>\r
 487 </DD>\r
 488 </DL>\r
 489 <HR>\r
 490 \r
 491 <A NAME="setTitle(java.lang.String)"><!-- --></A><H3>\r
 492 setTitle</H3>\r
 493 <PRE>\r
 494 public void <B>setTitle</B>(java.lang.String&nbsp;title)</PRE>\r
 495 <DL>\r
 496 <DD>Set WorkSheet Title\r
 497 <P>\r
 498 <DD><DL>\r
 499 <DT><B>Parameters:</B><DD><CODE>title</CODE> - </DL>\r
 500 </DD>\r
 501 </DL>\r
 502 <HR>\r
 503 \r
 504 <A NAME="getColCount()"><!-- --></A><H3>\r
 505 getColCount</H3>\r
 506 <PRE>\r
 507 public int <B>getColCount</B>()</PRE>\r
 508 <DL>\r
 509 <DD>Get column count of this WorkSheet\r
 510 <P>\r
 511 <DD><DL>\r
 512 \r
 513 <DT><B>Returns:</B><DD></DL>\r
 514 </DD>\r
 515 </DL>\r
 516 <HR>\r
 517 \r
 518 <A NAME="setColCount(int)"><!-- --></A><H3>\r
 519 setColCount</H3>\r
 520 <PRE>\r
 521 public void <B>setColCount</B>(int&nbsp;colCount)</PRE>\r
 522 <DL>\r
 523 <DD>Set column count of this WorkSheet\r
 524 <P>\r
 525 <DD><DL>\r
 526 <DT><B>Parameters:</B><DD><CODE>colCount</CODE> - </DL>\r
 527 </DD>\r
 528 </DL>\r
 529 <HR>\r
 530 \r
 531 <A NAME="getRowCount()"><!-- --></A><H3>\r
 532 getRowCount</H3>\r
 533 <PRE>\r
 534 public int <B>getRowCount</B>()</PRE>\r
 535 <DL>\r
 536 <DD>Get row count of this WorkSheet\r
 537 <P>\r
 538 <DD><DL>\r
 539 \r
 540 <DT><B>Returns:</B><DD></DL>\r
 541 </DD>\r
 542 </DL>\r
 543 <HR>\r
 544 \r
 545 <A NAME="setRowCount(int)"><!-- --></A><H3>\r
 546 setRowCount</H3>\r
 547 <PRE>\r
 548 public void <B>setRowCount</B>(int&nbsp;rowCount)</PRE>\r
 549 <DL>\r
 550 <DD>Set row count of this WorkSheet\r
 551 <P>\r
 552 <DD><DL>\r
 553 <DT><B>Parameters:</B><DD><CODE>rowCount</CODE> - </DL>\r
 554 </DD>\r
 555 </DL>\r
 556 <HR>\r
 557 \r
 558 <A NAME="getColumns()"><!-- --></A><H3>\r
 559 getColumns</H3>\r
 560 <PRE>\r
 561 public java.lang.String[] <B>getColumns</B>()</PRE>\r
 562 <DL>\r
 563 <DD>Get columns of the WorkSheet. It will return columns of associated table, otherwise
 564  columns of List Feed i.e. content of Header row of ListFeed\r
 565 <P>\r
 566 <DD><DL>\r
 567 \r
 568 <DT><B>Returns:</B><DD></DL>\r
 569 </DD>\r
 570 </DL>\r
 571 <HR>\r
 572 \r
 573 <A NAME="setColumns(java.lang.String[])"><!-- --></A><H3>\r
 574 setColumns</H3>\r
 575 <PRE>\r
 576 public void <B>setColumns</B>(java.lang.String[]&nbsp;columns)</PRE>\r
 577 <DL>\r
 578 <DD>Set columns of ListFeed\r
 579 <P>\r
 580 <DD><DL>\r
 581 <DT><B>Parameters:</B><DD><CODE>columns</CODE> - </DL>\r
 582 </DD>\r
 583 </DL>\r
 584 <HR>\r
 585 \r
 586 <A NAME="getEntry()"><!-- --></A><H3>\r
 587 getEntry</H3>\r
 588 <PRE>\r
 589 public <A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> <B>getEntry</B>()</PRE>\r
 590 <DL>\r
 591 <DD>Get Entry instance for this WorkSheet.
 592  Entry contains low level Feed Details\r
 593 <P>\r
 594 <DD><DL>\r
 595 \r
 596 <DT><B>Returns:</B><DD></DL>\r
 597 </DD>\r
 598 </DL>\r
 599 <HR>\r
 600 \r
 601 <A NAME="setEntry(com.pras.sp.Entry)"><!-- --></A><H3>\r
 602 setEntry</H3>\r
 603 <PRE>\r
 604 public void <B>setEntry</B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A>&nbsp;entry)</PRE>\r
 605 <DL>\r
 606 <DD>Set Feed Entry instance\r
 607 <P>\r
 608 <DD><DL>\r
 609 <DT><B>Parameters:</B><DD><CODE>entry</CODE> - </DL>\r
 610 </DD>\r
 611 </DL>\r
 612 <HR>\r
 613 \r
 614 <A NAME="getData(boolean)"><!-- --></A><H3>\r
 615 getData</H3>\r
 616 <PRE>\r
 617 public java.util.ArrayList&lt;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&gt; <B>getData</B>(boolean&nbsp;isCachedData)</PRE>\r
 618 <DL>\r
 619 <DD>Get all data of this WorkSheet (List based Feed)\r
 620 <P>\r
 621 <DD><DL>\r
 622 <DT><B>Parameters:</B><DD><CODE>isCachedData</CODE> - Do you want to read cached data or data from Server\r
 623 <DT><B>Returns:</B><DD></DL>\r
 624 </DD>\r
 625 </DL>\r
 626 <HR>\r
 627 \r
 628 <A NAME="getData(boolean, boolean, java.lang.String, java.lang.String)"><!-- --></A><H3>\r
 629 getData</H3>\r
 630 <PRE>\r
 631 public java.util.ArrayList&lt;<A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&gt; <B>getData</B>(boolean&nbsp;isCachedData,\r
 632                                                  boolean&nbsp;doReverse,\r
 633                                                  java.lang.String&nbsp;sq,\r
 634                                                  java.lang.String&nbsp;orderBy)</PRE>\r
 635 <DL>\r
 636 <DD>List based Feed for a particular Work Sheet. Use this method if you want to retrieve data entered
 637  through Web GUI and also through Table records.\r
 638 <P>\r
 639 <DD><DL>\r
 640 <DT><B>Parameters:</B><DD><CODE>isCachedData</CODE> - Do you want to read cached data or data from Server<DD><CODE>doReverse</CODE> - Do you need data in reverse order ?<DD><CODE>sq</CODE> - <a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#SendingStructuredRowQueries">Structured Query</a>. If you don't need this, set to <b>null</b>. (Make sure that column name is in lower case).<DD><CODE>orderBy</CODE> - If you don't need this, set to <b>null</b>. (Make sure that column name is in lower case).\r
 641 <DT><B>Returns:</B><DD></DL>\r
 642 </DD>\r
 643 </DL>\r
 644 <HR>\r
 645 \r
 646 <A NAME="addListRow(java.util.HashMap)"><!-- --></A><H3>\r
 647 addListRow</H3>\r
 648 <PRE>\r
 649 public <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A> <B>addListRow</B>(java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</PRE>\r
 650 <DL>\r
 651 <DD>Add List Feed row. One row at a time.
 652  TODO: need to test\r
 653 <P>\r
 654 <DD><DL>\r
 655 <DT><B>Parameters:</B><DD><CODE>records</CODE> - </DL>\r
 656 </DD>\r
 657 </DL>\r
 658 <HR>\r
 659 \r
 660 <A NAME="deleteListRow(java.lang.String, com.pras.WorkSheetRow)"><!-- --></A><H3>\r
 661 deleteListRow</H3>\r
 662 <PRE>\r
 663 public void <B>deleteListRow</B>(java.lang.String&nbsp;key,\r
 664                           <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&nbsp;r)</PRE>\r
 665 <DL>\r
 666 <DD>Delete List Row\r
 667 <P>\r
 668 <DD><DL>\r
 669 <DT><B>Parameters:</B><DD><CODE>r</CODE> - WorkSheetRow which need to be deleted</DL>\r
 670 </DD>\r
 671 </DL>\r
 672 <HR>\r
 673 \r
 674 <A NAME="updateListRow(java.lang.String, com.pras.WorkSheetRow, java.util.HashMap)"><!-- --></A><H3>\r
 675 updateListRow</H3>\r
 676 <PRE>\r
 677 public <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A> <B>updateListRow</B>(java.lang.String&nbsp;key,\r
 678                                   <A HREF="../../com/pras/WorkSheetRow.html" title="class in com.pras">WorkSheetRow</A>&nbsp;r,\r
 679                                   java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</PRE>\r
 680 <DL>\r
 681 <DD>Update List row\r
 682 <P>\r
 683 <DD><DL>\r
 684 <DT><B>Parameters:</B><DD><CODE>r</CODE> - WorkSheetRow to be updated<DD><CODE>records</CODE> - new records\r
 685 <DT><B>Returns:</B><DD></DL>\r
 686 </DD>\r
 687 </DL>\r
 688 <HR>\r
 689 \r
 690 <A NAME="addRecord(java.lang.String, java.util.HashMap)"><!-- --></A><H3>\r
 691 addRecord</H3>\r
 692 <PRE>\r
 693 public void <B>addRecord</B>(java.lang.String&nbsp;key,\r
 694                       java.util.HashMap&lt;java.lang.String,java.lang.String&gt;&nbsp;records)</PRE>\r
 695 <DL>\r
 696 <DD>Add record into WorkSheet. This WorkSheet need to have associated Table.
 697
 698  Use SpreadSheet.addWorkSheet()
 699  </br>
 700  <b>Note:</b>
 701  </br>
 702  All data entered through Web Interface will be ignored.\r
 703 <P>\r
 704 <DD><DL>\r
 705 <DT><B>Parameters:</B><DD><CODE>key</CODE> - Key of SpreadSheet<DD><CODE>records</CODE> - Record to be added ([col_name],[value])</DL>\r
 706 </DD>\r
 707 </DL>\r
 708 <HR>\r
 709 \r
 710 <A NAME="getRecords(java.lang.String)"><!-- --></A><H3>\r
 711 getRecords</H3>\r
 712 <PRE>\r
 713 public java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt; <B>getRecords</B>(java.lang.String&nbsp;key)</PRE>\r
 714 <DL>\r
 715 <DD>Get data stored in this WorkSheet\r
 716 <P>\r
 717 <DD><DL>\r
 718 <DT><B>Parameters:</B><DD><CODE>key</CODE> - SpreadSheet Key\r
 719 <DT><B>Returns:</B><DD></DL>\r
 720 </DD>\r
 721 </DL>\r
 722 <HR>\r
 723 \r
 724 <A NAME="getRecords(java.lang.String, java.lang.String)"><!-- --></A><H3>\r
 725 getRecords</H3>\r
 726 <PRE>\r
 727 public java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt; <B>getRecords</B>(java.lang.String&nbsp;key,\r
 728                                               java.lang.String&nbsp;sq)</PRE>\r
 729 <DL>\r
 730 <DD><DL>\r
 731 <DT><B>Parameters:</B><DD><CODE>key</CODE> - SpreadSheet Key<DD><CODE>sq</CODE> - <a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#SendingStructuredRowQueries">Structured Query</a>\r
 732 <DT><B>Returns:</B><DD></DL>\r
 733 </DD>\r
 734 </DL>\r
 735 <HR>\r
 736 \r
 737 <A NAME="getRecords(java.lang.String, boolean, java.lang.String, java.lang.String)"><!-- --></A><H3>\r
 738 getRecords</H3>\r
 739 <PRE>\r
 740 public java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt; <B>getRecords</B>(java.lang.String&nbsp;key,\r
 741                                               boolean&nbsp;doReverse,\r
 742                                               java.lang.String&nbsp;sq,\r
 743                                               java.lang.String&nbsp;orderBy)</PRE>\r
 744 <DL>\r
 745 <DD>Get data stored in this WorkSheet. Retrieved data will be in a HashMap-
 746  <COL_NAME>,<VALUE>
 747  <br/>
 748  It supports following conditional Query- <br/>
 749  <b>Structured Query:</b> you can define conditional statements like in SQL e.g. <col_name> != <value><br/>
 750  <b>Order By:</b> Order by a given column name or position <br/>
 751  <b>Reverse:</b> Record retrived in reverse order (last row 1st)<br/>
 752  <br/>
 753  <b>NOTE:</b>
 754  <br/>
 755  It will retrieve records present in the Table. Tables can't be accessed by the Web UI.
 756  <br/>
 757  So, any data inserted by Web UI will be discarded.
 758  <br/>\r
 759 <P>\r
 760 <DD><DL>\r
 761 <DT><B>Parameters:</B><DD><CODE>key</CODE> - SpreadSheet Key<DD><CODE>doReverse</CODE> - Display data in reverse order (last row first)<DD><CODE>sq</CODE> - <a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#SendingStructuredRowQueries">Structured Query</a><DD><CODE>orderBy</CODE> - <a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#SendingStructuredRowQueries">Order By</a>\r
 762 <DT><B>Returns:</B><DD></DL>\r
 763 </DD>\r
 764 </DL>\r
 765 <HR>\r
 766 \r
 767 <A NAME="getRecords()"><!-- --></A><H3>\r
 768 getRecords</H3>\r
 769 <PRE>\r
 770 public java.util.ArrayList&lt;<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&gt; <B>getRecords</B>()</PRE>\r
 771 <DL>\r
 772 <DD>Get Cached Data (previously retrieved from server)\r
 773 <P>\r
 774 <DD><DL>\r
 775 \r
 776 <DT><B>Returns:</B><DD></DL>\r
 777 </DD>\r
 778 </DL>\r
 779 <HR>\r
 780 \r
 781 <A NAME="updateRecord(com.pras.table.Record)"><!-- --></A><H3>\r
 782 updateRecord</H3>\r
 783 <PRE>\r
 784 public void <B>updateRecord</B>(<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&nbsp;record)</PRE>\r
 785 <DL>\r
 786 <DD>Record instance you want to Update
 787  Keep only those data which you want to update for this record\r
 788 <P>\r
 789 <DD><DL>\r
 790 <DT><B>Parameters:</B><DD><CODE>record</CODE> - Record to be updated</DL>\r
 791 </DD>\r
 792 </DL>\r
 793 <HR>\r
 794 \r
 795 <A NAME="deleteRecord(com.pras.table.Record)"><!-- --></A><H3>\r
 796 deleteRecord</H3>\r
 797 <PRE>\r
 798 public void <B>deleteRecord</B>(<A HREF="../../com/pras/table/Record.html" title="class in com.pras.table">Record</A>&nbsp;record)</PRE>\r
 799 <DL>\r
 800 <DD>Delete a Record\r
 801 <P>\r
 802 <DD><DL>\r
 803 <DT><B>Parameters:</B><DD><CODE>record</CODE> - Record to be deleted</DL>\r
 804 </DD>\r
 805 </DL>\r
 806 <HR>\r
 807 \r
 808 <A NAME="delete()"><!-- --></A><H3>\r
 809 delete</H3>\r
 810 <PRE>\r
 811 public void <B>delete</B>()</PRE>\r
 812 <DL>\r
 813 <DD>Delete this WorkSheet. It will also delete its associated Table.
 814  There is no separate method for deleting a Table\r
 815 <P>\r
 816 <DD><DL>\r
 817 </DL>\r
 818 </DD>\r
 819 </DL>\r
 820 <!-- ========= END OF CLASS DATA ========= -->\r
 821 <HR>\r
 822 \r
 823 \r
 824 <!-- ======= START OF BOTTOM NAVBAR ====== -->\r
 825 <A NAME="navbar_bottom"><!-- --></A>\r
 826 <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>\r
 827 <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">\r
 828 <TR>\r
 829 <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">\r
 830 <A NAME="navbar_bottom_firstrow"><!-- --></A>\r
 831 <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">\r
 832   <TR ALIGN="center" VALIGN="top">\r
 833   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>\r
 834   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>\r
 835   <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>\r
 836   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/WorkSheet.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>\r
 837   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>\r
 838   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>\r
 839   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>\r
 840   <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>\r
 841   </TR>\r
 842 </TABLE>\r
 843 </TD>\r
 844 <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>\r
 845 </EM>\r
 846 </TD>\r
 847 </TR>\r
 848 \r
 849 <TR>\r
 850 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">\r
 851 &nbsp;<A HREF="../../com/pras/SpreadSheetFactory.html" title="class in com.pras"><B>PREV CLASS</B></A>&nbsp;\r
 852 &nbsp;<A HREF="../../com/pras/WorkSheetCell.html" title="class in com.pras"><B>NEXT CLASS</B></A></FONT></TD>\r
 853 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">\r
 854   <A HREF="../../index.html?com/pras/WorkSheet.html" target="_top"><B>FRAMES</B></A>  &nbsp;\r
 855 &nbsp;<A HREF="WorkSheet.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;\r
 856 &nbsp;<SCRIPT type="text/javascript">\r
 857   <!--\r
 858   if(window==top) {\r
 859     document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>');\r
 860   }\r
 861   //-->\r
 862 </SCRIPT>\r
 863 <NOSCRIPT>\r
 864   <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>\r
 865 </NOSCRIPT>\r
 866 \r
 867 \r
 868 </FONT></TD>\r
 869 </TR>\r
 870 <TR>\r
 871 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">\r
 872   SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>\r
 873 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">\r
 874 DETAIL:&nbsp;FIELD&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>\r
 875 </TR>\r
 876 </TABLE>\r
 877 <A NAME="skip-navbar_bottom"></A>\r
 878 <!-- ======== END OF BOTTOM NAVBAR ======= -->\r
 879 \r
 880 <HR>\r
 881 \r
 882 </BODY>\r
 883 </HTML>\r