1 package com.prasanta.sample;
\r
3 import java.util.ArrayList;
\r
4 import java.util.HashMap;
\r
7 import com.pras.SpreadSheet;
\r
8 import com.pras.SpreadSheetFactory;
\r
9 import com.pras.WorkSheet;
\r
10 import com.pras.table.Record;
\r
13 * Demonstrates WorkSheet handling Add/Delete
\r
14 * Add/Update/Delete Records into WorkSheet
\r
15 * Retrieve record from WorkSheet
\r
17 * @author Prasanta Paul
\r
20 public class WorkSheetSample {
\r
22 public static void main(String[] args){
\r
24 // Enable/Disable Logging
\r
25 // by default it will be enabled
\r
28 // Create SpreadSheet Factory
\r
29 SpreadSheetFactory spf = SpreadSheetFactory.getInstance(args[0], args[1]);
\r
31 // Get All SpreadSheets
\r
32 //ArrayList<SpreadSheet> spreadSheets = spf.getAllSpreadSheets();
\r
34 // Get selected SpreadSheet- whose name contains "Pras"
\r
35 ArrayList<SpreadSheet> spreadSheets = spf.getSpreadSheet("Pras", false);
\r
37 if(spreadSheets == null || spreadSheets.size() == 0){
\r
38 System.out.println("No SpreadSheet Exists!");
\r
42 System.out.println("Number of SpreadSheets: "+ spreadSheets.size());
\r
44 SpreadSheet sp = spreadSheets.get(0);
\r
47 //sp.addWorkSheet("testWork1", new String[]{"date", "item", "price"});
\r
48 //sp.addWorkSheet("tabWork2", new String[]{"date", "item", "price", "person"});
\r
50 // Get all WorkSheets
\r
51 // ArrayList<WorkSheet> wks = sp.getAllWorkSheets();
\r
53 // Get selected WorkSheet
\r
54 ArrayList<WorkSheet> wks = sp.getWorkSheet("test", false);
\r
56 if(wks == null || wks.size() == 0){
\r
57 System.out.println("No WorkSheet exists!!");
\r
61 System.out.println("Number of WorkSheets: "+ wks.size());
\r
63 WorkSheet wk = null;
\r
64 /*for(int i=0; i<wks.size(); i++){
\r
66 * Search for WorkSheet having name "tab_*"
\r
68 if(wks.get(i).getTitle().startsWith("tab_")){
\r
75 System.out.println("wk="+ wk.getTitle());
\r
77 HashMap<String, String> rs = new HashMap<String, String>();
\r
78 rs.put("date", "1st Jan 2011");
\r
79 rs.put("item", "Item3");
\r
80 rs.put("price", "250");
\r
81 wk.addRecord(sp.getKey(), rs);
\r
84 * WorkSheet Record Handling
\r
87 ArrayList<Record> records = wk.getRecords(sp.getKey());
\r
89 if(records == null || records.size() == 0){
\r
90 System.out.println("No Record exists!!");
\r
94 System.out.println("Number of Records: "+ records.size());
\r
97 for(int i=0; i<records.size(); i++){
\r
98 Record r = records.get(i);
\r
99 HashMap<String, String> data = r.getData();
\r
100 System.out.println("Data: "+ data);
\r
104 //wk.deleteRecord(records.get(0));
\r
107 //Record toUpdate = records.get(0);
\r
109 //toUpdate.addData("Name", "Update_Name");
\r
110 //wk.updateRecord(toUpdate);
\r