Importing an Excel worksheet with linking
When you import an Excel worksheet with “linking”, Namo WebEditor converts it to an HTML table and maintains a link to the original worksheet. (This process is unrelated to hyperlinks.) Since the table and worksheet are linked, you can then tell Namo WebEditor to update the table if you later edit the worksheet.
If the Excel spreadsheet file to be imported contains more than one worksheet, Namo WebEditor will only import the first one.
In order for the link to the original worksheet to be maintained, the spreadsheet file must remain in the same location in the local file system as when you imported it. If the spreadsheet file is moved or deleted, you will not be able to update the imported table with changes to the worksheet.
To import an Excel worksheet with linking
- 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 Link to original spreadsheet, 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 linking, Microsoft Excel program should be installed on your system.
To update a table after changing the linked worksheet
- Right-click the table, and then click Update Spreadsheet Contents.
Namo WebEditor will launch or switch to Excel, open the specified spreadsheet file, re-import the worksheet, and then close the file (or Excel) and return to itself.
You can quickly launch Excel for editing the worksheet by right-clicking the imported table and clicking Edit Spreadsheet. When you close the spreadsheet or Excel, Namo WebEditor will automatically update the table.
Related topics
Importing an Excel worksheet with embedding
Importing an Excel worksheet as a static table