MicroStation CONNECT Reports let you export DGN data to an external file. You can choose various file formats, including Excel.
There is an apparently-related key-in command REPORTS EXPORT. However, that command is not documented and appears to do nothing.
This Idea is for an expanded set of export command key-ins. A comprehensive set ofREPORTS EXPORT key-ins would facilitate automation and batch-processing of Reports.
It would be useful to have various set commands. For example...
REPORTS EXPORT SET FORMAT csv | xml | html | Excel
REPORTS EXPORT SET FILENAME fileName
REPORTS EXPORT SET OUTPUT folder
If the key-in is entered without a value, it should echo the current state of that value.
Here's a set of report export commands...
REPORTS EXPORT reportName
REPORTS EXPORT reportName, fileName
This should have been included in the initial release. Developers had to know this functionality would be requested.
This really needs to make it into the 2023 release. As a CAD Administrator, we use the reporting tools in MicroStation CONNECT for things like model information, active design file units (MU:SU), workspace/workset branding, Annotation Scale, Geographic Coordinate System, etc. and export that data to excel for analysis. We've been looking at automating a solution to regularly report this data at scale; however, we can't achieve that with the limited functionality of the REPORTS EXPORT key-in.