1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
\r
5 <!-- Generated by javadoc (build 1.5.0_22) on Tue May 10 10:28:01 IST 2011 -->
\r
10 <META NAME="keywords" CONTENT="com.pras.SpreadSheet class">
\r
12 <LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style">
\r
14 <SCRIPT type="text/javascript">
\r
15 function windowTitle()
\r
17 parent.document.title="SpreadSheet";
\r
25 <BODY BGCOLOR="white" onload="windowTitle();">
\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
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> </TD>
\r
38 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
\r
39 <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
\r
40 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/SpreadSheet.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD>
\r
41 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
\r
42 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
\r
43 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
\r
44 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
\r
48 <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
\r
54 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
\r
55 <A HREF="../../com/pras/Log.html" title="class in com.pras"><B>PREV CLASS</B></A>
\r
56 <A HREF="../../com/pras/SpreadSheetFactory.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/SpreadSheet.html" target="_top"><B>FRAMES</B></A>
\r
59 <A HREF="SpreadSheet.html" target="_top"><B>NO FRAMES</B></A>
\r
60 <SCRIPT type="text/javascript">
\r
63 document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>');
\r
68 <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>
\r
75 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
\r
76 SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD>
\r
77 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
\r
78 DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD>
\r
81 <A NAME="skip-navbar_top"></A>
\r
82 <!-- ========= END OF TOP NAVBAR ========= -->
\r
85 <!-- ======== START OF CLASS DATA ======== -->
\r
90 Class SpreadSheet</H2>
\r
93 <IMG SRC="../../resources/inherit.gif" ALT="extended by "><B>com.pras.SpreadSheet</B>
\r
97 <DT><PRE>public class <B>SpreadSheet</B><DT>extends java.lang.Object</DL>
\r
101 This class represents a given Spreadsheet. You can add multiple WorkSheets into a Spreadsheet.
102 It provides methods to Add/Retrieve/Delete WorkSheet and Share SpreadSheet.
105 <a href="http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html">http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html</a>
109 <a href="http://code.google.com/apis/documents/docs/3.0/reference.html">http://code.google.com/apis/documents/docs/3.0/reference.html</a>
113 <i>Resource ID is required to delete a SpreadSheet</i>
\r
118 <DT><B>Author:</B></DT>
\r
119 <DD>Prasanta Paul</DD>
\r
125 <!-- ======== CONSTRUCTOR SUMMARY ======== -->
\r
127 <A NAME="constructor_summary"><!-- --></A>
\r
128 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
\r
129 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
\r
130 <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
\r
131 <B>Constructor Summary</B></FONT></TH>
\r
133 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
134 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#SpreadSheet(com.pras.sp.Entry)">SpreadSheet</A></B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> entry)</CODE>
\r
137 </TD>
\r
141 <!-- ========== METHOD SUMMARY =========== -->
\r
143 <A NAME="method_summary"><!-- --></A>
\r
144 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
\r
145 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
\r
146 <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
\r
147 <B>Method Summary</B></FONT></TH>
\r
149 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
150 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
151 <CODE> void</CODE></FONT></TD>
\r
152 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#addCollaborator(com.pras.Collaborator)">addCollaborator</A></B>(<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A> c)</CODE>
\r
155 Add a Collaborator</TD>
\r
157 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
158 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
159 <CODE> <A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A></CODE></FONT></TD>
\r
160 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#addListWorkSheet(java.lang.String, int, java.lang.String[])">addListWorkSheet</A></B>(java.lang.String name,
\r
162 java.lang.String[] cols)</CODE>
\r
165 Create List feed based WorkSheet</TD>
\r
167 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
168 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
169 <CODE> void</CODE></FONT></TD>
\r
170 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#addWorkSheet(java.lang.String)">addWorkSheet</A></B>(java.lang.String name)</CODE>
\r
173 This will create an WorkSheet without Table.</TD>
\r
175 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
176 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
177 <CODE> void</CODE></FONT></TD>
\r
178 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#addWorkSheet(java.lang.String, java.lang.String[])">addWorkSheet</A></B>(java.lang.String name,
\r
179 java.lang.String[] cols)</CODE>
\r
182 Add WorkSheet
183 This will create an Internal Table and manage WorkSheet data in that Table.</TD>
\r
185 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
186 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
187 <CODE> void</CODE></FONT></TD>
\r
188 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#addWorkSheet(java.lang.String, java.lang.String, int, java.lang.String[])">addWorkSheet</A></B>(java.lang.String name,
\r
189 java.lang.String description,
\r
191 java.lang.String[] cols)</CODE>
\r
194 Add WorkSheet <br/>
195 It will create a Table for this WorkSheet.</TD>
\r
197 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
198 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
199 <CODE> void</CODE></FONT></TD>
\r
200 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#clearCollaboratorList()">clearCollaboratorList</A></B>()</CODE>
\r
203 Clear existing list of Collaborators</TD>
\r
205 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
206 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
207 <CODE> void</CODE></FONT></TD>
\r
208 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#deleteWorkSheet(com.pras.WorkSheet)">deleteWorkSheet</A></B>(<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A> wk)</CODE>
\r
211 Delete this WorkSheet</TD>
\r
213 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
214 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
215 <CODE> boolean</CODE></FONT></TD>
\r
216 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#equals(java.lang.Object)">equals</A></B>(java.lang.Object obj)</CODE>
\r
219 </TD>
\r
221 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
222 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
223 <CODE> java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>></CODE></FONT></TD>
\r
224 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getAllWorkSheets()">getAllWorkSheets</A></B>()</CODE>
\r
227 It will retrieve all WorkSheets of this SpreadSheet from Server</TD>
\r
229 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
230 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
231 <CODE> java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>></CODE></FONT></TD>
\r
232 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getAllWorkSheets(boolean)">getAllWorkSheets</A></B>(boolean doRefresh)</CODE>
\r
235 It will retrieve all WorkSheets of this SpreadSheet either from Server or from Local Cache</TD>
\r
237 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
238 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
239 <CODE> java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>></CODE></FONT></TD>
\r
240 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getAllWorkSheets(boolean, java.lang.String, boolean)">getAllWorkSheets</A></B>(boolean doRefresh,
\r
241 java.lang.String title,
\r
242 boolean isTitleExact)</CODE>
\r
245 It will retrieve WorkSheets with matching title either from Server or from Local Cache</TD>
\r
247 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
248 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
249 <CODE> java.util.ArrayList<<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A>></CODE></FONT></TD>
\r
250 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getCollaborators()">getCollaborators</A></B>()</CODE>
\r
253 Get the list of all Collaborator details (users/groups and their access rights) for a given SpreadSheet</TD>
\r
255 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
256 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
257 <CODE> <A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A></CODE></FONT></TD>
\r
258 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getEntry()">getEntry</A></B>()</CODE>
\r
261 Get Entry Object of SpreadSheet Feed.</TD>
\r
263 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
264 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
265 <CODE> java.lang.String</CODE></FONT></TD>
\r
266 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getKey()">getKey</A></B>()</CODE>
\r
269 Get SpreadSheet Feed Key</TD>
\r
271 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
272 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
273 <CODE> java.lang.String</CODE></FONT></TD>
\r
274 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getResourceID()">getResourceID</A></B>()</CODE>
\r
277 Get SpreadSheet Resource ID.</TD>
\r
279 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
280 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
281 <CODE> java.lang.String</CODE></FONT></TD>
\r
282 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getTitle()">getTitle</A></B>()</CODE>
\r
285 Get SpreadSheet Title</TD>
\r
287 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
288 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
289 <CODE> java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>></CODE></FONT></TD>
\r
290 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#getWorkSheet(java.lang.String, boolean)">getWorkSheet</A></B>(java.lang.String title,
\r
291 boolean isTitleExact)</CODE>
\r
294 It will retrieve WorkSheets with matching title from Server</TD>
\r
296 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
297 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
298 <CODE> int</CODE></FONT></TD>
\r
299 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#hashCode()">hashCode</A></B>()</CODE>
\r
302 </TD>
\r
304 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
305 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
306 <CODE> void</CODE></FONT></TD>
\r
307 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#setCollaborators(java.util.ArrayList)">setCollaborators</A></B>(java.util.ArrayList<<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A>> collaborators)</CODE>
\r
310 Set a list of Collaborators</TD>
\r
312 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
313 <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
\r
314 <CODE> void</CODE></FONT></TD>
\r
315 <TD><CODE><B><A HREF="../../com/pras/SpreadSheet.html#setEntry(com.pras.sp.Entry)">setEntry</A></B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> entry)</CODE>
\r
318 Set Entry Object of SpreadSheet Feed.</TD>
\r
321 <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
\r
322 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
\r
323 <TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
\r
324 <TH ALIGN="left"><B>Methods inherited from class java.lang.Object</B></TH>
\r
326 <TR BGCOLOR="white" CLASS="TableRowColor">
\r
327 <TD><CODE>getClass, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
\r
333 <!-- ========= CONSTRUCTOR DETAIL ======== -->
\r
335 <A NAME="constructor_detail"><!-- --></A>
\r
336 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
\r
337 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
\r
338 <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
\r
339 <B>Constructor Detail</B></FONT></TH>
\r
343 <A NAME="SpreadSheet(com.pras.sp.Entry)"><!-- --></A><H3>
\r
346 public <B>SpreadSheet</B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> entry)</PRE>
\r
350 <!-- ============ METHOD DETAIL ========== -->
\r
352 <A NAME="method_detail"><!-- --></A>
\r
353 <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
\r
354 <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
\r
355 <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
\r
356 <B>Method Detail</B></FONT></TH>
\r
360 <A NAME="equals(java.lang.Object)"><!-- --></A><H3>
\r
363 public boolean <B>equals</B>(java.lang.Object obj)</PRE>
\r
366 <DT><B>Overrides:</B><DD><CODE>equals</CODE> in class <CODE>java.lang.Object</CODE></DL>
\r
374 <A NAME="hashCode()"><!-- --></A><H3>
\r
377 public int <B>hashCode</B>()</PRE>
\r
380 <DT><B>Overrides:</B><DD><CODE>hashCode</CODE> in class <CODE>java.lang.Object</CODE></DL>
\r
388 <A NAME="getEntry()"><!-- --></A><H3>
\r
391 public <A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> <B>getEntry</B>()</PRE>
\r
393 <DD>Get Entry Object of SpreadSheet Feed. Entry holds all SpreadSheet Feed details
\r
397 <DT><B>Returns:</B><DD></DL>
\r
402 <A NAME="setEntry(com.pras.sp.Entry)"><!-- --></A><H3>
\r
405 public void <B>setEntry</B>(<A HREF="../../com/pras/sp/Entry.html" title="class in com.pras.sp">Entry</A> entry)</PRE>
\r
407 <DD>Set Entry Object of SpreadSheet Feed.
\r
410 <DT><B>Parameters:</B><DD><CODE>entry</CODE> - </DL>
\r
415 <A NAME="getTitle()"><!-- --></A><H3>
\r
418 public java.lang.String <B>getTitle</B>()</PRE>
\r
420 <DD>Get SpreadSheet Title
\r
424 <DT><B>Returns:</B><DD></DL>
\r
429 <A NAME="getResourceID()"><!-- --></A><H3>
\r
432 public java.lang.String <B>getResourceID</B>()</PRE>
\r
434 <DD>Get SpreadSheet Resource ID. Each SpreadSheet has an unique Resource ID.
435 This ID is required to Delete this SpreadSheet.
\r
439 <DT><B>Returns:</B><DD></DL>
\r
444 <A NAME="getKey()"><!-- --></A><H3>
\r
447 public java.lang.String <B>getKey</B>()</PRE>
\r
449 <DD>Get SpreadSheet Feed Key
\r
453 <DT><B>Returns:</B><DD></DL>
\r
458 <A NAME="getCollaborators()"><!-- --></A><H3>
\r
459 getCollaborators</H3>
\r
461 public java.util.ArrayList<<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A>> <B>getCollaborators</B>()</PRE>
\r
463 <DD>Get the list of all Collaborator details (users/groups and their access rights) for a given SpreadSheet
\r
467 <DT><B>Returns:</B><DD></DL>
\r
472 <A NAME="addCollaborator(com.pras.Collaborator)"><!-- --></A><H3>
\r
473 addCollaborator</H3>
\r
475 public void <B>addCollaborator</B>(<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A> c)</PRE>
\r
477 <DD>Add a Collaborator
\r
480 <DT><B>Parameters:</B><DD><CODE>c</CODE> - </DL>
\r
485 <A NAME="clearCollaboratorList()"><!-- --></A><H3>
\r
486 clearCollaboratorList</H3>
\r
488 public void <B>clearCollaboratorList</B>()</PRE>
\r
490 <DD>Clear existing list of Collaborators
\r
498 <A NAME="setCollaborators(java.util.ArrayList)"><!-- --></A><H3>
\r
499 setCollaborators</H3>
\r
501 public void <B>setCollaborators</B>(java.util.ArrayList<<A HREF="../../com/pras/Collaborator.html" title="class in com.pras">Collaborator</A>> collaborators)</PRE>
\r
503 <DD>Set a list of Collaborators
\r
506 <DT><B>Parameters:</B><DD><CODE>collaborators</CODE> - </DL>
\r
511 <A NAME="addWorkSheet(java.lang.String)"><!-- --></A><H3>
\r
514 public void <B>addWorkSheet</B>(java.lang.String name)</PRE>
\r
516 <DD>This will create an WorkSheet without Table. It will create WorkSheet with 1 Column and 1 Row. It can
517 be accessed/modified by Web Interface.
520 This Library supports Record Handling only through Table. If you use this method, it will not
521 create Table internally and thus unable to add/edit/delete record from this WorkSheet. Instead,
522 use addWorkSheet(String name, String[] cols)
\r
525 <DT><B>Parameters:</B><DD><CODE>name</CODE> - WorkSheet name</DL>
\r
530 <A NAME="addWorkSheet(java.lang.String, java.lang.String[])"><!-- --></A><H3>
\r
533 public void <B>addWorkSheet</B>(java.lang.String name,
\r
534 java.lang.String[] cols)</PRE>
\r
537 This will create an Internal Table and manage WorkSheet data in that Table.
538 This Lib supports only Table based record Add/Edit/Delete
\r
541 <DT><B>Parameters:</B><DD><CODE>name</CODE> - name of WorkSheet<DD><CODE>cols</CODE> - name of Columns</DL>
\r
546 <A NAME="addWorkSheet(java.lang.String, java.lang.String, int, java.lang.String[])"><!-- --></A><H3>
\r
549 public void <B>addWorkSheet</B>(java.lang.String name,
\r
550 java.lang.String description,
\r
552 java.lang.String[] cols)</PRE>
\r
554 <DD>Add WorkSheet <br/>
555 It will create a Table for this WorkSheet. WorkSheet and Table Name will be the same
556 The Table will be used for Add/Edit/Delete Records
560 <DT><B>Parameters:</B><DD><CODE>name</CODE> - Name of the WorkSheet<DD><CODE>description</CODE> - Description of the WorkSheet<DD><CODE>row</CODE> - Number of Rows<DD><CODE>cols</CODE> - Name of Columns</DL>
\r
565 <A NAME="addListWorkSheet(java.lang.String, int, java.lang.String[])"><!-- --></A><H3>
\r
566 addListWorkSheet</H3>
\r
568 public <A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A> <B>addListWorkSheet</B>(java.lang.String name,
\r
570 java.lang.String[] cols)</PRE>
\r
572 <DD>Create List feed based WorkSheet
\r
575 <DT><B>Parameters:</B><DD><CODE>name</CODE> - Name of the WorkSheet<DD><CODE>rowCount</CODE> - Number of row. This doesn't limit future row addition.<DD><CODE>cols</CODE> - Array of column name. First row of the WorkSheet is header row.
\r
576 <DT><B>Returns:</B><DD></DL>
\r
581 <A NAME="getAllWorkSheets()"><!-- --></A><H3>
\r
582 getAllWorkSheets</H3>
\r
584 public java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>> <B>getAllWorkSheets</B>()</PRE>
\r
586 <DD>It will retrieve all WorkSheets of this SpreadSheet from Server
\r
590 <DT><B>Returns:</B><DD></DL>
\r
595 <A NAME="getAllWorkSheets(boolean)"><!-- --></A><H3>
\r
596 getAllWorkSheets</H3>
\r
598 public java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>> <B>getAllWorkSheets</B>(boolean doRefresh)</PRE>
\r
600 <DD>It will retrieve all WorkSheets of this SpreadSheet either from Server or from Local Cache
\r
603 <DT><B>Parameters:</B><DD><CODE>doRefresh</CODE> - Do you want to Synch with Server ?
\r
604 <DT><B>Returns:</B><DD>list of available WorkSheets</DL>
\r
609 <A NAME="getWorkSheet(java.lang.String, boolean)"><!-- --></A><H3>
\r
612 public java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>> <B>getWorkSheet</B>(java.lang.String title,
\r
613 boolean isTitleExact)</PRE>
\r
615 <DD>It will retrieve WorkSheets with matching title from Server
\r
618 <DT><B>Parameters:</B><DD><CODE>title</CODE> - SpreadSheet title. <b>null</b> means all SpreadSheets. No need to do URL encode.<DD><CODE>isTitleExact</CODE> - whether title string should be an exact match
\r
619 <DT><B>Returns:</B><DD></DL>
\r
624 <A NAME="getAllWorkSheets(boolean, java.lang.String, boolean)"><!-- --></A><H3>
\r
625 getAllWorkSheets</H3>
\r
627 public java.util.ArrayList<<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A>> <B>getAllWorkSheets</B>(boolean doRefresh,
\r
628 java.lang.String title,
\r
629 boolean isTitleExact)</PRE>
\r
631 <DD>It will retrieve WorkSheets with matching title either from Server or from Local Cache
\r
634 <DT><B>Parameters:</B><DD><CODE>doRefresh</CODE> - Do you want to Synch with Server ?<DD><CODE>title</CODE> - SpreadSheet title. <b>null</b> means all SpreadSheets. No need to do URL encode.<DD><CODE>isTitleExact</CODE> - Whether title string should be an exact match
\r
635 <DT><B>Returns:</B><DD>list of available WorkSheets</DL>
\r
640 <A NAME="deleteWorkSheet(com.pras.WorkSheet)"><!-- --></A><H3>
\r
641 deleteWorkSheet</H3>
\r
643 public void <B>deleteWorkSheet</B>(<A HREF="../../com/pras/WorkSheet.html" title="class in com.pras">WorkSheet</A> wk)</PRE>
\r
645 <DD>Delete this WorkSheet
\r
648 <DT><B>Parameters:</B><DD><CODE>wk</CODE> - WorkSheet to be deleted</DL>
\r
651 <!-- ========= END OF CLASS DATA ========= -->
\r
655 <!-- ======= START OF BOTTOM NAVBAR ====== -->
\r
656 <A NAME="navbar_bottom"><!-- --></A>
\r
657 <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
\r
658 <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
\r
660 <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
\r
661 <A NAME="navbar_bottom_firstrow"><!-- --></A>
\r
662 <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
\r
663 <TR ALIGN="center" VALIGN="top">
\r
664 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
\r
665 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD>
\r
666 <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD>
\r
667 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/SpreadSheet.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD>
\r
668 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
\r
669 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
\r
670 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-files/index-1.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
\r
671 <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
\r
675 <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
\r
681 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
\r
682 <A HREF="../../com/pras/Log.html" title="class in com.pras"><B>PREV CLASS</B></A>
\r
683 <A HREF="../../com/pras/SpreadSheetFactory.html" title="class in com.pras"><B>NEXT CLASS</B></A></FONT></TD>
\r
684 <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
\r
685 <A HREF="../../index.html?com/pras/SpreadSheet.html" target="_top"><B>FRAMES</B></A>
\r
686 <A HREF="SpreadSheet.html" target="_top"><B>NO FRAMES</B></A>
\r
687 <SCRIPT type="text/javascript">
\r
690 document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>');
\r
695 <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>
\r
702 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
\r
703 SUMMARY: NESTED | FIELD | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD>
\r
704 <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
\r
705 DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD>
\r
708 <A NAME="skip-navbar_bottom"></A>
\r
709 <!-- ======== END OF BOTTOM NAVBAR ======= -->
\r