Editing_an_HTML_table_in_Microsoft

Editing an HTML table in Microsoft Excel

The Table object in Phoenix creates tables in HTML format.

Right-click the output table and select Copy to Tables Folder.

In the Object Browser, select the worksheet in the Tables folder.

Select Edit > Edit in Excel.

Right-click the worksheet and select Edit in Excel.

In the information dialog, press OK to open the table in Excel.

Edit the worksheet using the Excel tools.

When finished editing in Excel, select File > Save As and change the filename.

Excel cannot publish to the same file that is being edited.

In the Save as type menu, make sure that Web Page (*.htm;*.html) is selected.

Press Save.

In the next dialog, press Yes to continue saving in the Web Page format.

Close Excel without saving.

When asked to apply the changes to the table, click Yes.

An entry is written in the table’s History tab noting that it was edited in Excel.

In the next dialog, select the renamed HTML file and click Open.

The HTML file’s name is the same one entered in Excel.

The HTML table in the Tables folder now contains the edits made in Excel.

When the table is open in Excel, it is stored as a temp file which, by default, is in C:\Users\<username>\AppData\Local\Temp\Phoenix.

Points to consider when editing tables in Excel

HTML table format edits are saved when saving back to Phoenix and the option to apply the changes is selected.

Only formatting available in standard Phoenix tables are supported. For non-standard tables, the HTML is passed to Excel as is.

Multiple HTML tables can be edited at once.

The edited table will match any changes that Excel automatically makes to those files.

Detailed edits made in Excel are not recorded in the table History tab. The History tab only records a single edit entry named “Object Edited in Excel.”