Importing Worksheets

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.

Importing Worksheet Data from Another Program

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 New Resource > Worksheet from the Resources menu.

    2. 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:

    5. ●    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.

Importing Worksheets from Another Vectorworks File

To import a Vectorworks worksheet from another Vectorworks file:

  1. From the Resource Browser, locate the file containing the worksheet; 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 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:

  1. In Word, select the entire table to be imported.

  2. Select the Table Tools > Layout > Convert to Text.

    3. 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.

    6. 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 a 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.

 

vectorworks.net