Is it possible to create a table in MicroStation CONNECT and export that table into Excel?
I am aware of being able to import Excel into MicroStation, but not vice versa.
Thanks!
Norah Locke said:Is it possible to create a table in MicroStation CONNECT and export that table into Excel?
A Table is a visual representation of a Report. You can export a Report to an Excel workbook.
Regards, Jon Summers LA Solutions
For the Report tool, how do I just export the text content of a regular table?
Hi Norah,
MicroStation is 3D CAD system, not software to work with tables.
Can you specify more what for you is "table"? For some users it can be just simple object with formatted lists of values, for some others calculations and sorting is even not enough.
Norah Locke said:For the Report tool, how do I just export the text content of a regular table?
See this MicroStation documentation chapter.
With regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
Hey Jan,
I have a parts list that has been manually entered using the table tool (Empty Table) in CONNECT. The table has not been generated from a report. I'd like the parts list to be exported to an Excel table.
Thanks
Norah Locke said:I have a parts list that has been manually entered using the table tool (Empty Table) in CONNECT. The table has not been generated from a report. I'd like the parts list to be exported to an Excel table.
That's exactly what should be shared in the original post, because it makes the question and context much clearer :-)
Norah Locke said:I'd like the parts list to be exported to an Excel table.
When the table has no data source (e.g. report), I think it's not possible to export it to external format.
I do not know, but maybe the enhancement mentioned by Karan targets this functionality.
Jan Šlegr said:When the table has no data source (e.g. report), I think it's not possible to export it to external format. I do not know, but maybe the enhancement mentioned by Karan targets this functionality. With regards
With regards
Karan Sharma
Karan,
Do you know if enhancement 1098563 targets the functionality in question?
Yes. It does target the said functionality. Enhancement 1098563:Use Table element to create an Excel file - Export Table to Excel
When do you think that enhancement would be made available? My company would heavily rely on that feature so I'd like to know a timeline to decide if I should spend time exploring more complicated options to achieve this.
Norah Locke said:to decide if I should spend time exploring more complicated options to achieve this.
I think there are not many alternative options available. What should work is to access table using own application, as far as I know, both C++ and NET APIs provide access to table element.
Regards,