Exporting worksheets

Vectorworks worksheet files can be exported and read by spreadsheet programs, as well as by some word processing programs. Because these programs have different format requirements, several export formats are available. For example, a tab delimited text file can be opened as a table in Microsoft Word. The following formats are available:

When exporting to Excel, as much as possible, formatting and formulas are preserved. An alert displays when exact translation isn’t possible. Database header rows will have light gray fill, similar to the way they look in the worksheet window. You can export multiple worksheets to Excel format simultaneously with the Publish command; see Batch publishing.

● Open the worksheet to export, and select the command from the worksheet’s File menu.

Parameter	Description
Worksheet	Specifies the worksheet to export; if the command was executed from the worksheet menu, that worksheet name displays and cannot be edited
Format	Specifies the export format
Export Range	If the command was executed from the worksheet menu, specifies whether to export all rows or only the selected rows; otherwise, all rows will be exported
Recalculate worksheet prior to exporting	Recalculates the worksheet before export
Open file in the default viewer	Automatically opens the exported file in the default viewer application, if available