Importing an Excel worksheet with embedding
When you import an Excel worksheet with embedding, Namo WebEditor converts it to an HTML table and embeds a hidden copy of the worksheet in the Web document. As a result, you can always edit the worksheet in Excel—even if the original file is no longer available—and Namo WebEditor will automatically update the table to reflect your changes to the worksheet. The table does not preserve any relationship with the original worksheet—only with the embedded copy of it.
Note that the file size of the Web document will increase by the size of the worksheet that is embedded in it.
If the Excel spreadsheet file to be imported contains more than one worksheet, Namo WebEditor will only import the first one.
To import an Excel worksheet with embedding
- Place the insertion point in an empty paragraph.
- On the Insert menu, go to Data, and then click Spreadsheet.
- Click Browse, locate and select the Excel file to be imported, and then click Open.
- Under Insertion method, click Embed into HTML document, and then click OK.
When you click OK, Namo WebEditor will launch or switch to Excel, open the specified spreadsheet file, import the first worksheet, and then close the file (or Excel) and return to itself.
To import an Excel worksheet with embedding, Microsoft Excel program should be installed on your system.
To edit an embedded worksheet
- Right-click the imported table, and then click Edit Spreadsheet. (The embedded worksheet will open in Excel.)
- Edit the worksheet as desired. When you are finished, exit Excel.
Namo WebEditor will automatically update the table to reflect your changes to the embedded worksheet.
Related topics
Importing an Excel worksheet with linking
Importing an Excel worksheet as a static table