You've got an Excel spreadsheet, and you want it to become a table in a Web page. How do you do it?
Whatever you do, do NOT export from Excel to HTML - the 'HTML' it produces is a godawful mess. In fact, it only works with Internet Explorer on Windows. There's no technological reason for this; during the antitrust trial, Microsoft executives testified that they made this decision in order to further force people to use IE instead of alternative browsers.
There's a much better way to do this.
1. Save the Excel file as a CSV (comma-delimited) file (or tab-delimited - whatever floats your boat). Excel will complain that you're going to lose formatting. Go ahead and let it know that you are a human with a brain, and yes, you really want to do this.
2. Open Dreamweaver & go to the File menu > Import > Import Tabular Data.
3. Follow the instructions in the dialog box. Hit OK.
You're done. Your Excel spreadsheet is now a table on a Web page. And, best of all, your HTML is not a godawful, proprietary mess.
|