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?
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.
With regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
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,
This is targeted for a future release with no timeline yet determined. To increase its priority, I would suggest raising a service ticket and ask for it to be linked with the enhancement number.
Hi Norah,
one more comment:
Norah Locke said: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.
When I checked MicroStation APIs (especially NET, because it's simpler than C++ one), it seems to access a table content is not very complicated. So when, as you wrote, your company heavily rely on the tables, it makes sense to implement own tool, providing exactly the functionality you need.
I can imagine that to export table content to not excel, but csv, which is in general simpler than to create Excel file, should not be extremely complicated task. Of course, as usually, it depends a lot of other requirements whether it should be dynamic (a user can locate table) or every time all tables will be exported etc.
Jan Šlegr said:it seems to access a table content is not very complicated
Norah Locke said:I have a parts list that has been manually entered using the table tool
FlexiTable CONNECT Edition may provide a solution. Post a small DGN example.