Help > Authoring > Working with Tables > Table Editing > Importing Excel Tables
  
Importing Excel Tables
You can copy and paste Microsoft Excel spreadsheet data into Arbortext Editor as a new table. The following limitations and considerations apply to this feature:
Spreadsheets and Excel
Excel must be running when you choose Edit > Paste Excel in Arbortext Editor.
Excel must be installed on the local workstation, not run from a networked drive.
If you are importing from a new Excel spreadsheet, save it before performing the import.
The Excel cells you wish to paste must be selected by dragging over the range of desired cells. Full row or column selections are not supported.
Do not work in Excel while the table import is in progress.
Excel formulas will be resolved and the resulting value will be stored in the imported table.
Cell references to other worksheets or other documents will be resolved (if the other worksheet/document is available), and the resulting value will be stored in the imported table.
The Excel import functionality supports both vertical and horizontal cell spanning (Excel's Merge Cells function).
Cell border settings are not imported.
Hidden rows and columns in the Excel selection will be ignored. If you want to import hidden rows or columns, you must display them before copying them. When a table contains hidden columns and merged cells, the import may not be correct. In case of merged cells, it is recommended to import the table with hidden columns and then remove the hidden data in Arbortext Editor.
For versions of Excel prior to Excel 2007, only the first 1024 character in a cell will be imported. If your spreadsheet contains cells with more than 1024 characters in a cell, you must use Excel 2007 or later to import the spreadsheet into Arbortext Editor.
Tables in Arbortext Editor
Excel tables can be imported into documents using document types containing supported table models, including OASIS Exchange, Arbortext, and HTML tables. Refer to Tables overview for more information on supported tables.
The columns in your selection will be re-sized to fit within the default display width. The default table display width is controlled by the set tablewidth set option. While the columns may be adjusted to fit within the display width, they will maintain their proportions to one another.
If you have a title above the table data, you can set the Use First Row as Table Title option in the Excel Import Options dialog box to automatically paste the text into a separate title element.
Arbortext Editor supports importing up to 10,000 Excel spreadsheet cells. Break large tables into smaller sections, and combine them in Arbortext Editor to import larger tables.
CJK Considerations
Imported cell data can use CJK characters regardless of Excel version.
Arbortext Editor supports using Excel XP (2002) and Excel 2003 CJK file names (workbook names) and CJK worksheet names.
Arbortext Editor supports using Excel 2000 with CJK file names. However, sheet names within the workbook using CJK characters are not supported.
If the Excel file name contains CJK characters and the file is stored on a file server, then you cannot import that table into Arbortext Editor. You can work around this issue by either moving the file to your local machine or by using Arbortext Editor’s capability to copy and paste content from other applications.
Other Considerations
Copying from Microsoft Excel captures content exactly as it appears in the original source. Any anomalies in the original content will be carried into the pasted content. For example, if cell content in Excel appears as hash characters (####) when the cell is too narrow to display it fully, this is how the same content will appear when pasted into an Arbortext Editor table. Ensure that the content appears as expected in Excel before carrying out the copy action.
To import Microsoft Excel spreadsheet cells as table data
1. In Microsoft Excel, select the desired cells. If you intend to use the top row as a title, make sure to include it in your selection.
2. From the Excel menus, choose Edit > Copy.
3. In Arbortext Editor, place the cursor in a place where it is legal to insert a new table.
4. From the Arbortext Editor menus, choose Edit > Paste Excel.
5. Select the desired options from the Excel Import Options dialog box and click the OK button.
If sgmlselection is set to on, the data will be pasted in tagged format.