Insert Spreadsheet Data to Table.... ACE Rocks

I remember back in the day when I did real work I was always creating spreadsheets to display servo data, motor data and anything else the Engineers wanted to display in the drawings. The problem would come in when I wanted to get the Spreadsheet into the drawings. You could import it as an OLE object but then it looked horrible.

I recently was going through some of the toolbars and menu's just to see what I have forgotten or have never found, and I found a tool to help out with the scenario mentioned above. That Nate guy thoght of everything.

If you go to the Projects pull down menu, then the Reports fly out menu click on "Insert Spreadsheet Data to Table". This will allow you to select a spreadsheet and bring it into the standard Report Generator we are used to seeing in AutoCAD Electrical reports.  This dialog gives us the ability to add information such as line labels, time and date, page breaks and even edit specific line entries within the Report Generator.  Great tool that many may have overlooked. Once you select Put on Drawing it will give you the standard Table Generation Setup dialog just like when we run BOM reports or any other reports. After you click OK you place the newly created "Table" into your drawing.

If you have any ideas or topics you would like me to cover in an upcoming blog please feel free to Email me at [email protected] with your topic ideas.

Thanks

Rob Stein

INCAT