Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Coverting a Large Excel file to a Browser Friendly format

Status
Not open for further replies.

funkmonsteruk

IS-IT--Management
Feb 8, 2002
210
GB
I've got a large Excel File which I need to make browsable over a LAN Intranet, I've tried the Excel Convert to HTML add-in but it looks terrible, I've also tried using Adobe to turn it into a PDF, but the spreadsheet still doesn't seem to fit that well.

Does anybody have any suggestions?
 
Here is a simple way to do this:

Save the Excel file as tab-delimited text,
and load the resulting file into Word. Search for tab (^t)
and replace each occurrence with </TD><TD>.
Search for end-of-line (^p) and replace each instance with </TD></TR>^p<TR><TD>.
You now have an extra <TR><TD> on a blank line at the bottom,
and the same text missing at the start of the very first line.
Move the extra text to the beginning of the first line.
Add the <TABLE> tag at the top and </TABLE> at the end and you're ready to copy the document into your HTML page.
 
Is there a way you could get your data into Access, and use the Access viewer on your site....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top