View Single Post
Old April 10th, 2004, 12:34 AM     #8 (permalink)
jmichna
1010011010
 
jmichna's Avatar
 
Join Date: Oct 2001
Location: Chicagoland IL
Posts: 3,249
You should be able to import the Excel file into html, then strip out anything Excel-specific, leaving only the values and the tags html uses to create the table: <table></table> (table) or <tr></tr> (table row) or <td></td> (table cell).

The structure will look like:
Code:
<table>
   <tr>
      <td> your 1st col</td>
      <td> your 2nd col</td>
      <td> your 3rd col</td>
      <td> your 4th col</td>
   </tr>
The above will be repeated 1700 times (once for each of your rows) then the end table tag
</table>
If you have W2K or XP, Notepad can do a Find... Edit... Replace and you can manually strip out all the extra Excel junk.
__________________
"The trouble with our liberal friends is not that they're ignorant; It's just that they know so much that isn't so." -- Ronald Reagan
jmichna is offline   Reply With Quote