i have a Question about to import a Excel table to doors (as table in attributes). I want this Excel table just in look , to have on Doors (without new Objectives, only the Table).
The only thing which works, is to insert the table as a picture (Screenshot). But there must be a solution to solve this Problem.
Thanks a lot !
cliff.sadler 270003EEPR22 Posts
Re: Import Excel Table as Table2011-10-05T15:14:07ZThis is the accepted answer. This is the accepted answer.My practice is to copy the cells of the excel table, and paste it into MS Word. This creates a Word table. I remove the Table 1 autocaption, and then set the top heading row (if applicable) to repeat as a header row. I then save this as a Word 97-2003 .doc file.
Create an object in DOORS (ctrl-N, and hit space to put you in inset edit mode for Object Text), backspace, and then insertOLE object from file, navigating to the newly created Word document.
This gives you one object, a properly formatted table, with table properties.
To edit the table later on, right click on the object to get the properties page, and then double click the OLE insert from there. That will open MS Word in a SEPARATE window, allowing for editing.
This is crucial for long tables that span more than one page. When they are exported, you can use a macro to expand the tables to their full size. Excel embedded tables don't do this well.
m4teria 270004NSUV3 Posts
Re: Import Excel Table as Table2011-10-10T06:57:11ZThis is the accepted answer. This is the accepted answer.
- cliff.sadler 270003EEPR
Its better then input the table as screenshot. But i want to have a Doorstable. Is that realizable ? Our customer send his Specs always in Powerpoint format (yes Powerpoint...) and my job it is to get this large Specs into Doors. I want to find an automation for this. Well, that is not easy but i want to try it.
I want to have a original doorstable from a table which i have in Powerpoint (or Excel, Word). Realizable?
Thanks a lot
SystemAdmin 110000D4XK1084 Posts
Re: Import Excel Table as Table2013-02-12T22:20:43ZThis is the accepted answer. This is the accepted answer.
- cliff.sadler 270003EEPR
rmoskwa 270001W91H72 Posts
Re: Import Excel Table as Table2013-02-13T15:03:11ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
I am considering on upgrading to Office 2010 on my PC, but I am concerned after reading your post. Did you have an older version of Office on a PC first, followed by installing DOORS, perhaps followed with DOORS updates, and then you updated to Office 2010?
I ask because I think you stated (in your DXL forum post) that you were able to have Excel OLEs functional in DOORS, then you updated to Office 2010, and now Excel OLEs do not function for you in DOORS.
I have other PCs that had Office 2010 on them, followed by installing DOORS 9.202, and Excel OLEs function properly in DOORS. I am wondering if your problem may be fixed by re-installing the DOORS client on the PC that you upgraded with Office 2010.