If you have access to a unix shell, save the file as a tab delimited file.
Upload it to the shell.
Execute a command like the following:
(assuming the filename is spreadsheet.txt)
echo '<TABLE>' > output.html
awk -F\\t '{printf "<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>\n\r", $1,
$2, $3}' speadsheet.txt >> output.html
echo '</TABLE>' >> output.html
You just need to modify the awk string for however many fields you have, so
if you have 5 you would have a string with a "<TR>" at the
beginning, five "<TD>%s</TD>" and a "</TR>\r\n". Then make sure to add $1,
$2, $3, $4, $5 to the list following the string.
output.html should be a simple HTML 1.1 table.
Ryan Merton
NERDC Support Desk
392-2061 x140
[log in to unmask]
On Fri, 20 Dec 2002, Kristiina Butler wrote:
> I need to import Excel spread sheets into the web and would like to find a way to do it
> without having all the extra tags, style sheets and other junk on the page.
>
> Any advice?
>
> Kristiina Butler
> OIT - Network Services
> 392-2061
>
|