Data from a wide variety of worksheet formats can be imported into a file, including worksheet data from other programs and worksheets from other Vectorworks files.
To import a worksheet into the current file, a blank worksheet must exist in the active drawing as a destination for the imported worksheet. During import, the spreadsheet data is imported, but the formulas (logic) are not.
To import worksheet data into a Vectorworks file:
1. From the Resource Browser, select Resources > New Resource > Worksheet.
The Create Worksheet dialog box opens.
2. Specify the same number of rows and columns that are present in the worksheet to be imported.
3. Select File > Import > Import Worksheet.
4. Select the worksheet file to be imported. The worksheet must be in one of the following formats:
● Tab delimited text (.txt)
● Comma delimited text (.csv)
● DIF (.dif)
● SYLK (.slk)
5. Click Open. The worksheet is imported into the open worksheet in the Vectorworks file.
To import a Vectorworks worksheet from another Vectorworks file:
1. From the Resource Browser, locate the file containing the worksheet using the Resources > Find command, or from a Favorites file. See Accessing Existing Resources for more information.
2. Select the worksheet to import, and click Import. (Alternatively, drag the worksheet resource into the desired Vectorworks file to insert it as a drawing object; see Worksheets as Graphic Objects.)
The selected worksheet is imported into the current file.
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:
1. In Word, select the entire table to be imported.
2. In versions of Word prior to 2007, select Table > Convert > Table to Text. In Word 2007 and later, select the Table Tools > Layout > Convert to Text.
The Convert Table to Text dialog box opens.
3. In the dialog box, click Tabs for the separation identifier.
4. Click OK.
5. 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, and click OK.
If the table is part of a larger file, copy the table to the Clipboard. Select File > New, and paste the table text into the new document. Save the file as a text file.
6. Return to the Vectorworks file and import the table as described in Importing Worksheet Data from Another Program.