2.7.6 Excel table import
Icon:
With the import function of Excel table, you can import the appointed worksheet in the ready Excel table to editor at a time. Pictures and charts and other files in Excel table will auto upload to server. Furthermore when importing, it provides options to ask for whether to keep some format or not for you actual publishing application needs. And it can perform the shift from Excel worksheet to HTML and importing by one press instead of reenter and any complicated operations.
Click the button icon; it will pop up the following dialog box:
Click browse in the above box and then choose the Excel document with an extension of ".xls" and which you need to import. After selecting valid Excel document, in "worksheet" pull-down menu it will list the worksheet existing in the Excel document and then select worksheet to import. Next select options and click "ok" to finish. Then the Excel worksheet will be imported to editor.
Keep VML:
This option is mainly designed for chart from Excel. If you select "yes", the chart from Excel document will be displayed in VML format instead of picture file. Otherwise it will produce image and be uploaded to server.
Effect comparison of the two options:
options |
effect |
Yes |
Chart will not produce image file but instead it display in VML. Files in server would be less while HTML code became more in editor content area. Browsers (IE4.0 and later) supporting VML are applicable. |
No |
Chart will produce image file and without VML code. Files in server become more while HTML code in editor content area would be less. All browsers are applicable. |
Auto roll:
If you select "yes", it will add an auto rolling layer to the most border of table. It can keep page from being zooming on or invisible when the imported table is too wide and auto add roller to fully display table.
Table frame:
Excel table defaults no frame lines. If you don't add frame line when making tables in Excel, there will be no frame lines when it is imported. You can employ this function to auto add frame to tables which don't have.
Note:
The using of this function requires the support of "eWebEditor client software". If it is the first time for you to use it, it will popup the install interface of "eWebEditor client software" component. Click "yes" in the install interface and finish the install of component and it will popup interface as above.
You can see the online Demo for this function by the following link:
http://www.ewebeditor.com/Demo/ImportExcel.asp