Please provide your e-mail address to download your FREE 30-day trial.
This tutorial demonstrates the use of ProjectExplorer to generate a simple Civil 3D Alignment/Profile report to a PDF file. We then write the same report to a different file format in a few simple steps - to an Excel XLSX file.
In AutoCAD Civil 3D, Open the standard Civil 3D sample drawing: Intro-1.dwg
This drawing is part of the standard Civil 3D installation, and can generally be found in the following folder:
C:\Program Files\Autodesk\AutoCAD 2018\C3D\Help\Civil Tutorials\
There are two ways to generate reports in ProjectExplorer. The quickest, easiest way to generate a report of a single element from your Civil 3D model is to use the Quick Report function. Right-click any listed item in the ProjectExplorer window to access the associated Quick Report options.
The Create Quick Report dialog opens.
To generate a Quick Report we need to choose a file type for the report, then configure the content and layout of the report using a Layout Style and a Report Style.
Layout Styles define the heading, visibility, and order of every column of data in the report. The units of numerical values can also be controlled from a Layout Style.
Report Styles define the page formatting, fonts, table style, and header/footer content of outgoing reports.
Layout and Report Styles can be saved and retrieved at any time, but for this tutorial we will define our requirements manually.
The Layout Options dialog opens.
From this dialog we will define the layout of the outgoing report.
Press OK to close the Layout Options dialog and return to the Quick Report dialog.
Next, we'll specify the style of the outgoing report. Press the Edit Report Style for Quick Reports button. The Report Options dialog opens.
Finally, press OK to close the Report Options dialog and return to the Quick Report dialog.
We are now ready to generate the report. From the Quick Report dialog, press the OK button and choose a path in which to save the PDF report file.
The report is generated. Open Adobe Acrobat to inspect the resulting report file.
If you wish to change the layout or style of the report, right-click the same object in the ProjectExplorer window and select the Quick Report to file option again. Your preferences will be remembered from the previous quick report.
From the Alignments tab of the ProjectExplorer window, relocate the alignment Second Street, and right-click the associated Finished Grade Centerline - Second Street Design Profile. Select Quick Report to file from the right-click menu.
The Create Quick Report dialog opens again.
Change the file type to XLSX file to generate an Excel file.
As we have previously configured our report settings, you can just accept the current layout style and report style, or make some minor adjustments if you wish.
Press the OK button to generate the file.
Open Microsoft Excel to review the output.
Note that three worksheets have been generated in the exported XLSX file. The first worksheet contains the report header. The second worksheet contains the selected object geometry. The third worksheet contains the Report Footer.
To prevent the report header and footer from creating additional worksheets in the exported file, run the Quick Report option again and deselect the Add Fields to Report Header and Add Report Footer options in the Report Style dialog.
ProjectExplorer does not automatically set the width of columns in the exported Excel file. In Microsoft Excel, select the entire worksheet and select Autofit Column Width from the cell formatting options in the Excel ribbon.
You have now completed this tutorial.