Data to Table Data to Table acts upon a text file containing data and produces HTML code for a table structure which contains that data. This panel initially appears as follows:
The data for each row of the table must be in one line in the text file, and the data for each cell must be separated by a specified character, which may be a comma, a semicolon, a space or a tab character (respecively ASCII 44, 59, 32 and 9). Such data is of the following kind (for a table with three rows and six columns):
Wilson, Ralph, 33, Kansas City, KS, pilot
Poniatowski, Mabel, 21, Chico, CA, waitress
Jefferson, Clarence, 68, Dayton, OH, retiredSome rules of use:
- If the data contains commas and spaces then a semicolon can be used to separate the data in the cells, as in (for a table of three rows and four columns):
Wilson, Ralph; 33; Kansas City, KS; pilot
Poniatowski, Mabel; 21; Chico, CA; waitress
Jefferson, Clarence; 68; Dayton, OH; retired
- Alternatively if the character used to separate data for the cells itself occurs within this data then it can be preceded by \, e.g. "4,321" should be changed to "4\,321" (if the comma is the separator), as in:
Wilson\, Ralph, 33, Kansas City\, KS, pilot
Poniatowski\, Mabel, 21, Chico\, CA, waitress
Jefferson\, Clarence, 68, Dayton\, OH, retired
- A new line in text in a cell can be obtained by inserting \! where the line break should occur, e.g. "first line\!second line".
- If a line of data should be a table heading (and so appear in bold) then \TH should be placed at the start of the line.
- For a blank cell just use the separator character (e.g. ",,," if the comma is the separator); if the separator is the space character then use \ plus a space) to mark an empty cell.
Examples of use are given on the following pages:
Easy HTML Construction Kit Home Page