Home } Page Details } Spreadsheet Cell Bock Parser



This script will take a block of spreadsheet cells and convert them to a 2x2 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 2x2 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!!!

    

Did you use this script?  Do you like this site?  Please link to us!

Add a comment, suggestion, or correction
[For questions about usage, consult the Notes tab above or visit the JavaScript forum. Do not include more than two (2) lines of code in your comments. If you have suggestions or corrections, you can submit them to us.]

    
   
       
[optional]
 
[optional]

   

Comments feed Comment Feed RSS 2.0

Sign up for the JavaScript Weekly
internet.com Privacy Policy
We'll send this script to you!

(just click "Send it!" once!)