Spreadsheet Cell Bock Parser

By John Thompson on Jan 23, 2003

This script will take a block of spreadsheet cells and convert them to a 2×2 table object. The value of cells within this table can be accessed by specifying row and column number. Simply paste a block of cells into the space below and click “Pare Pasted Objects”

Parse Spreadsheet Data into a 2×2 Table

Paste a Block of SpreadSheet Cells:
Formatted table will appear below when pressed
  • After parsing, the variable tableobject, declared in the document head, will hold the parsed table.
  • You can access the table cells via JavaScript like this: tableobject.cell[2][3] (the cell value at row 2, column 3).
  • Works in MSIE Only



The JavaScript Source: Page Details: Spreadsheet Cell Bock Parser

Simply click inside the window below, use your cursor to highlight the script, and copy (type Control-c or Apple-c) the script into a new file in your text editor (such as Note Pad or Simple Text) and save (Control-s or Command-s). The script is yours!!!