Saving an Excel File such that it can be brought into a Pro/ Drawing as a Table

An MS Excel file can be saved in a format such that the information in each column is lined up. It is also possible to modify the spreadsheet in Excel such that the text appears within cells, as it would in MS Excel format.

In the existing MS Excel spreadsheet, add the following columns:

1) Add a column to the left of the existing columns, and enter @[ preceded by a single quote.

2) Between each column of text, enter @]@[ preceded by a single quote.

3) Add an extra column to the right of the existing columns, and enter @] preceded by a single quote.

Save the file as a space delimited (*.prn) file, and then modify the file name to have a (*.txt) extension.

This text file can then be used in a drawing note, by selecting #detail; #create; #note; using the #file option.