The Excel table below was imported using Dreamweaver's File > Paste Special Command. Notice the lack of formatting. Also, look at the code in code view. Here are the steps:
| ITI Open Enrollment Trends Code302 - CMP | |||||
| Semester | SumII-02 | Fall02 | Spring03 | Sum1-3 | FY03 |
| Enrollment | 176 | 372 | 486 | 187 | 1221 |
| Change | -128 | -1699 | -1778 | -595 | -4200 |
| % Change | -42.1% | -82.0% | -78.5% | -76.1% | -77.5% |
| Semester | SumII-03 | Fall03 | Spring04 | Sum1-04 | FY04 |
| Enrollment | 152 | 550 | 686 | 348 | 1736 |
| Change | -24 | 178 | 200 | 161 | 515 |
| % Change | -13.6% | 47.8% | 41.2% | 86.1% | 42.2% |
Formatting. Notice that the full Excel formatting, including "conditional formatting," is preserved in the example below by selecting the "Text with Structure plus full formatting" radio button in Dreamweaver's Edit > Paste Special dialog box. However, this is not a "spreadsheet." It is the HTML representation of a finished spreadsheet. If the data changes, you will still have to calculate the formulas in Excel and re-import to Dreamweaver. This page will not automatically "update" a "spreadsheet."
"Paste Special Includes A Microsoft Internal Style Sheet. Look at the large Microsoft Excel Internal Styles in the HTML Head tag at the top of the code page. Microsoft is using XML to "style" the Excel 2003 formatting. Many data formats around the world are now using XML, including Microsoft. See Thomas Friedman's The World Is Flat. Notice, however, that limited border formatting is incorporated. To provide a border around each cell, see the next Revised Formatting spreadsheet which applies style changes to each of the Microsoft styles in the Dreamweaver Code View Header.
Note. Required data table 508 accessibility features are not part of this document. Note: See the 508 Web Accessibility course. The document will need further revision.