Skip to main content
Chris3
Chris321-Topaz I
21-Topaz I
January 25, 2023
Solved

Formatting a table with mapkeys

  • January 25, 2023
  • 3 replies
  • 1318 views

I have an Excel file that has merged cells. I don't want to pull the native file into Creo. I am importing these now as a .csv but when I do that I loose the merged cells.

 

Does anyone have a technique or a better way of doing this? I looked at creating my own tbl file but they are not straight text.

Best answer by Chris3

For anyone coming back to this, I resolved this issue by recording and then re-running a modified trail file from a mapkey.

3 replies

N
NiruSatya10-Marble
10-Marble
January 25, 2023

CSV - Comma Specified Value file format will remove any formatting you might have applied for XLSX file Table Cells.

 

I generally insert table as an Object with/without linking the .xlsx file.

Go to Layout Tab - Select OBJECT under Insert Group - Create New - Microsoft Excel Worksheet [Copy Paste your content with Formatting] - Select anywhere in the Drawing to place the file. Then Move, Scale etc.....as per your requirement.

 

Might not look excellent, But it'll do the job. Anytime double click on the table to modify it.

 

01 May I know what is the purpose of bringing Excel sheet into Creo Drawing.

02 Also what you want to do after Importing the Excel file into Drawing? [Do you need to extract the Table info?]

 

Chris3
Chris321-Topaz IAuthor
21-Topaz I
January 31, 2023

Yes, as I stated, I know I can insert a native Excel file but that's not what I want.

 

I haven't had a chance to cycle back to this but I am going to attempt to resolve this by inserting the csv by mapkey and then have the mapkey call a trail file to get me the clicks I need to format the table. Crossing my fingers I can get it to work.

Chris3
Chris321-Topaz IAuthorAnswer
21-Topaz I
April 24, 2023

For anyone coming back to this, I resolved this issue by recording and then re-running a modified trail file from a mapkey.

Terms & ConditionsAccessibility statement