Importing worksheets
Data from a wide variety of formats can be imported into a file, including worksheet data from other programs and worksheets from other Vectorworks files.
Importing worksheet data from another program
|
Command |
Path |
|
Import Worksheet |
File (worksheet menu) File > Import |
During import, the spreadsheet data is imported, and as much as possible, formatting and formulas are preserved. An alert displays when exact translation isn't possible. When you import a Microsoft Excel file you can also reference it, which allows you to easily update the worksheet when the Excel file changes.
To import worksheet data into a Vectorworks file:
Do one of the following:
Select the command from the File > Import menu.
Open the worksheet to import into, and select the command from the worksheet's File menu.
From the Organization dialog box or Navigation palette, create a reference to an Excel file; see Adding and editing reference files and The Navigation palette.
Select the worksheet file to be imported and click Open. The worksheet must be in one of the following formats:
Tab delimited text (.txt)
Comma delimited text (.csv)
DIF (.dif)
SYLK (.slk)
Excel (.xls, .xlsx)
If you're importing an Excel worksheet, the Excel Import Options dialog box opens. See Microsoft Excel references for more information.
Click to show/hide the parameters.Click to show/hide the parameters.
|
Parameter |
Description |
|
Sheet |
If the Excel file has multiple sheets, select the sheet to import |
|
Reference |
References the original Excel file (master file), so that the imported sheet can be updated when the master file changes. See Concept: Workgroups and referencing for more information. |
|
Absolute path |
Stores the absolute file path of the master file. Select this option when the location of the master file will not change in the future, or if the master file is on another volume. |
|
Path relative to current document |
Stores the file path of the master file relative to the target Vectorworks file; this option is available only if the master file is on the same volume as the Vectorworks file. Select this option if the target file and the master file may be moved to another volume in the future. If you're using server-based project sharing, and the master file is not on the same volume as the Project Sharing Server, you’ll be prompted to upload the file to the server's project folder. (Design Suite product required) |
|
Automatically update reference during file open |
Updates the worksheet from the master file each time this target file is opened, if the master file has changed |
If a Vectorworks worksheet is open, the worksheet is imported into it. Otherwise, the worksheet is imported as a new worksheet resource, named after the imported file.
Importing worksheets from another Vectorworks file
To import a Vectorworks worksheet from another Vectorworks file:
From the Resource Manager, right-click on the resource, and select Import.
Alternatively, drag the worksheet resource into the desired Vectorworks file to insert it as a drawing object; see Placing a worksheet on the drawing.
The selected worksheet is imported into the current file.
Importing a table from Microsoft Word
The following procedure is an example of how to import a table from Microsoft Word into a Vectorworks worksheet.
To import a Word table into a worksheet:
In Word, select the entire table to be imported.
Select the Table Tools > Layout > Convert to Text.
The Convert Table to Text dialog box opens.
In the dialog box, click Tabs for the separation identifier.
Click OK.
Save the table.
If the file consists of only the table, select File > Save As. In the Save As dialog box that opens, select Text Only from the Save as type list.
If the table is part of a larger file, copy the table to the Clipboard. Select File > New, and paste the table text into a new document. Save the file as a text file.
Return to the Vectorworks file and import the table as described above in Importing worksheet data from another program.