Import and export tabular data
You can import tabular data that has been created in another application (such as Microsoft Excel) and saved in a delimited text format (with items separated by tabs, commas, colons, or semicolons) into Dreamweaver and format it as a table.
You can also export table data from Dreamweaver into a text file, with the contents of adjacent cells separated by a delimiter. You can use commas, colons, semicolons, or spaces as delimiters. When you export a table, the entire table is exported; you cannot select portions of a table to export.
If
you want only some of the data from a table—for example, the first
six rows or the first six columns—then copy the cells containing
that data, paste those cells outside of the table (to create a new
table), and export the new table.
Import table data
- Specify the options for the tabular data and click OK.
- Data File
- The name of the file to import. Click the Browse button to select a file.
- Delimiter
-
The delimiter used in the file you’re importing.
If you select Other, a text box appears to the right of the pop‑up menu. Enter the delimiter used in your file.
Note: Specify the delimiter that was used when the data file was saved. If you don’t do this, the file will not be imported properly, and your data will not be correctly formatted in a table. - Table Width
-
The width of the table.
-
Select Fit to Data to make each column wide enough to fit the longest text string in the column.
-
Select Set to specify a fixed table width in pixels or as a percentage of the browser window’s width.
-
- Border
- Specifies the width, in pixels, of the tables borders.
- Cell Padding
- The number of pixels between a cell’s content and the cell boundaries.
- Cell Spacing
-
The number of pixels between adjacent table cells.
If you don’t explicitly assign values for borders,
cell spacing, and cell padding, most browsers display the table
with borders and cell padding set to 1, and cell spacing set to
2. To ensure that browsers display the table with no padding or spacing,
set Cell Padding and Cell Spacing to 0. To view cell and table boundaries when
the border is set to 0, select View > Visual Aids >
Table Borders.
- Format Top Row
- Determines what formatting, if any, is applied to the top row of the table. Select from four formatting options: no formatting, bold, italic, or bold italic.