Method, system, and apparatus for exposing workbook ranges...

Details Method, system, and apparatus for exposing workbook ranges... Method, system, and apparatus for exposing workbook ranges...

2004-06-01

2010-02-16

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

Database design

Database and data structure management

C707S600000, C707S758000, C707S803000, C707S802000, C707S705000, C707S790000

Reexamination Certificate

active

07664804

ABSTRACT:
A method, system, and apparatus are provided for exposing and utilizing workbook ranges as server data sources. The system includes a client computer capable of executing a spreadsheet application program for creating a workbook including a range that includes data objects. The workbook may be published to a server computer where the specified data objects are exposed as server data sources. The server computer allows client applications to discover and connect to the data objects contained within the workbook as server data sources.

REFERENCES:
patent: 5437006 (1995-07-01), Turski
patent: 5870522 (1999-02-01), Strolle et al.
patent: 5890174 (1999-03-01), Khanna et al.
patent: 5893123 (1999-04-01), Tuinenga
patent: 5933818 (1999-08-01), Kasravi et al.
patent: 5937406 (1999-08-01), Balabine et al.
patent: 5974416 (1999-10-01), Anand et al.
patent: 6012057 (2000-01-01), Mayer et al.
patent: 6055548 (2000-04-01), Comer et al.
patent: 6094651 (2000-07-01), Agrawal et al.
patent: 6157934 (2000-12-01), Khan et al.
patent: 6269377 (2001-07-01), Collie et al.
patent: 6282548 (2001-08-01), Burner et al.
patent: 6317750 (2001-11-01), Tortolani et al.
patent: 6411313 (2002-06-01), Conlon et al.
patent: 6430584 (2002-08-01), Comer et al.
patent: 6446059 (2002-09-01), Berger et al.
patent: 6456999 (2002-09-01), Netz
patent: 6473750 (2002-10-01), Petculescu et al.
patent: 6477536 (2002-11-01), Pasumansky et al.
patent: 6493718 (2002-12-01), Petculescu et al.
patent: 6532458 (2003-03-01), Chaudhuri et al.
patent: 6549907 (2003-04-01), Fayyad et al.
patent: 6604135 (2003-08-01), Rogers et al.
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6632249 (2003-10-01), Pollock
patent: 6684206 (2004-01-01), Chen et al.
patent: 6701485 (2004-03-01), Igra et al.
patent: 6898603 (2005-05-01), Petculescu et al.
patent: 6920443 (2005-07-01), Cesare et al.
patent: 7032030 (2006-04-01), Codignotto
patent: 7240052 (2007-07-01), Sidlosky et al.
patent: 7299223 (2007-11-01), Namait et al.
patent: 7460713 (2008-12-01), Lapstun et al.
patent: 2002/0010743 (2002-01-01), Ryan et al.
patent: 2002/0013786 (2002-01-01), Machalek
patent: 2002/0059261 (2002-05-01), Pollock
patent: 2002/0095399 (2002-07-01), Devine et al.
patent: 2002/0169799 (2002-11-01), Voshell
patent: 2002/0188629 (2002-12-01), Burfoot
patent: 2003/0110191 (2003-06-01), Handsaker et al.
patent: 2003/0149934 (2003-08-01), Worden
patent: 2003/0195762 (2003-10-01), Gleason et al.
patent: 2004/0060001 (2004-03-01), Coffen et al.
patent: 2004/0103365 (2004-05-01), Cox
patent: 2004/0103366 (2004-05-01), Peyton-Jones et al.
patent: 2004/0133567 (2004-07-01), Witkowski et al.
patent: 2004/0133568 (2004-07-01), Witkowski et al.
patent: 2004/0237029 (2004-11-01), Medicke et al.
patent: 2005/0039113 (2005-02-01), Balducci et al.
patent: 2005/0039114 (2005-02-01), Naimat et al.
patent: 2006/0024653 (2006-02-01), Battagin et al.
patent: 2006/0069603 (2006-03-01), Williams et al.
patent: 2006/0069617 (2006-03-01), Milener et al.
patent: 2006/0112123 (2006-05-01), Clark et al.
patent: 2009/0235154 (2009-09-01), Khen et al.
patent: 9 997 834 (2000-05-01), None
patent: 1 605 367 (2005-12-01), None
4tops.com, “Excel Import Assistant for Microsoft Access” Apr. 2003, www.4tops.com.
U.S. Office Action dated Dec. 19, 2007 cited in U.S. Appl. No. 10/903,568.
ExcelTip.com, “Export data from Excel to Access (DAO) using VBA in Microsoft Excel,” 05.2003, pp. 1-2.
Andrew Witkowski et al., “Spreadsheets in RDBMS for OLAP,” 06.2003, ACM SIGMOD, pp. 52-63.
U.S. Appl. No. 10/903,568, filed Jul. 30, 2004 entitled “Method, System, and Apparatus for Exposing Workbooks as Data Sources”.
European Search Report dated Jun. 30, 2006 cited in Application No. 05104477.4-2201.
Lakshmanan et al., “On Querying Spreadsheets,” Data Engineering, 1998, Proceedings, 14thInternational Conference, pp. 134-141.
De Paoli et al., “Requirements for a Layered Software Architecture Supporting Cooperative Multi-Layer Interaction,” Software Engineering, 1996, Proceedings of the 18thInternational Conference, pp. 408-417.
U.S. Office Action dated Nov. 2, 2006 cited in U.S. Appl. No. 10/903,568.
U.S. Final Office Action dated May 4, 2007 cited in U.S. Appl. No. 10/903,568.
U.S. Appl. No. 10/903,781, filed Jul. 30, 2004 entitled, “Method, System, and Apparatus for Providing Access to Workboook Models Through Remote Function Calls”; (60001.0337US01); 30 pgs.
European Search Report mailed Aug. 6, 2007 cited in EP Application No. 0510620.9-1243; (60001.0337EP01); 3 pgs.
European Official Communication dated Nov. 5, 2007 cited in EP Application No. 05 104 620.9-1243; (60001.0337EP01); 5 pgs.
U.S. Office Action dated Oct. 31, 2007 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 13 pgs.
U.S. Final Office Action dated May 12, 2008 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 14 pgs.
U.S. Final Office Action dated Jun. 6, 2008 cited in U.S. Appl. No. 10/903,568; (60001.0336US01); 25 pgs.
U.S. Office Action dated Nov. 26, 2008 cited in U.S. Appl. No. 10/903,781; (60001.0337US01); 16 pgs.
U.S. Office Action dated Dec. 19, 2008 cited in U.S. Appl. No. 10/903,568; (60001.0336US01); 29 pgs.
Chinese First Office Action dated Mar. 14, 2008 cited in Application No. 200510082420.X; 17 pgs.
Chinese Second Office Action dated Nov. 21, 2008 cited in Application No. 200510082420.X; 7 pgs.
Chinese First Office Action dated Feb. 13, 2009 cited in Application No. 200510082407.4 (0337cc01) pp. 1-11.
Chinese Third Office Action dated Mar. 13, 2009 cited in Application No. 200510082420.X (0336cc01), pp. 1-7.
U.S. Office Action mailed May 20, 2009, in U.S. Appl. No. 11/599,598.
European Examination Report mailed Mar. 25, 2009 in 07717882.0-1527/1977340.
European Examination Report mailed Apr. 1, 2009 in 07717837.4-1527/1977339.
U.S. Final Office Action dated Aug. 4, 2009 cited in U.S. Appl. No. 10/903,781, pp. 1-20.
Chinese Fourth Office Action dated Jul. 10, 2009 cited in Application No. 200510082420.X (0336cc01), pp. 1-7.
Mexican Office Action dated Jan. 22, 2009 cited in Application No. PA/a/2005/005799 (0337mx01), pp. 1-4.
European Official Communication dated Nov. 26, 2007 cited in EP Application No. 05 104 620.9-1243.
Erik Hatcher, “Remote scripting using a servlet,” Jan. 2, 2001, http://www.ibm.com/developerworks/web/library/wa-resc/, 7 pgs. (0337ep01).

Affiliated with

Also associated with

Rating

Method, system, and apparatus for exposing workbook ranges... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method, system, and apparatus for exposing workbook ranges..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method, system, and apparatus for exposing workbook ranges... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4184454