Embedded ad hoc browser web to spreadsheet conversion control

• US 7,594,165 B2
• Filed: 01/11/2005
• Issued: 09/22/2009
• Est. Priority Date: 01/11/2005
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Walker, Keith Raymond, Handy-Bosma, John Hans, Chen, Yen-Fu
• Primary Examiner(s): Pesin; Boris
• Application Number:
  US11/032,847
• Publication Number:
  US 20060156221A1
• Time in Patent Office: 1,715 Days
• Field of Search: 715/500, 715/769, 715/856, 715/862, 715/212, 715/217, 715/221
• US Class Current: 715/212
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/154 Tree transformation for tree-structured or markup documents, e.g. XSLT, XSL-FO or stylesheets
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A table converter is disclosed that enables a user to convert any table, or portion of a table, displayed on a web page to a spreadsheet control embedded in the webpage. The table converter is a web browser plug-in or feature comprising a table analysis program (TAP); a table conversion program (TCP), a spreadsheet configuration program (SCP), a spreadsheet modification program (SMP), a configurable table engine (CTE), and a configurable table template (CTT). The CTE contains a rules database. The TAP interrogates the highlighted hypertext markup language (HTML) table structure <table>, <tr>, <th> and <td> tags, and text for delimiters. The TCP maps the table headings and data to a configurable table engine (CTE). The CTE inserts the headings and data into a configurable table template (CTT), and displays the CTT on the web page at a user configurable location. The SCP enables a user to automate the process, to add or subtract columns or rows from the table, and to add calculation functions. Automation options include both locating and converting a table displayed on a web page.

Claims

1. A computer implemented method in a data processing system, which includes a processor, for using a web browser to convert an entire HTML table in a web page to a spreadsheet in the web page, the method comprising:

receiving, by a table analysis program that is being executed by the processor, the web page, wherein the web page includes the entire HTML table, and further wherein the entire HTML table includes a plurality of table headings and a plurality of pieces of data, and still further wherein each piece of said plurality of pieces of data is preceded by an HTML tag;

displaying the entire HTML table in the web page in a web browser window;

analyzing the web page for tables in response to receiving the web page,

wherein the entire HTML table is found as a result of the analysis of the web page;

after finding the entire HTML table, converting the entire HTML table to a spreadsheet by mapping the plurality of table headings and the plurality of pieces of data to a spreadsheet template, wherein converting the entire HTML table to the spreadsheet occurs only as a result of the receipt of the web page;

displaying the spreadsheet in the web page browser window, wherein the spreadsheet in the web page replaces the entire HTML table in the web page; and

providing a web browser plug-in that includes the table analysis program, a table conversion program, a spreadsheet modification program, a spreadsheet configuration program, a configuration table engine, and a configurable table template.