CSV table separated by commas and not spaces

[BC_10219589]

Hello,

I have been trying to add an excel table into a creo drawing and when I import the csv file into the drawing the data is separated by commas and I get only one-column table. Does anybody know how to fix this so that I get all the columns and a table that looks like to one I have in excel?

Thank you for your help.

[MartinHanak]

---

@BC_10219589 wrote:

Hello,

I have been trying to add an excel table into a creo drawing and when I import the csv file into the drawing the data is separated by commas and I get only one-column table. Does anybody know how to fix this so that I get all the columns and a table that looks like to one I have in excel?

Thank you for your help.

---

Hi,

on my PC I applied setting from https://www.ptc.com/en/support/article/CS355947 .

In Creo 9.0.0.0 I am able to:

• create empty Excel workbook in Creo drawing
• open Excel file outside Creo
• select cells
• CTRL+C
• double-click table in Creo drawing
• CTRL+V

I do not need to export/import csv file.

[BC_10219589]

Hi,

Thank you for your answer, however, I can't paste excel cells into my creo drawing (I am using Creo 7, 0.7.0)

do you know why this happens?

Thank you,

[MartinHanak · Accepted solution]

---

@BC_10219589 wrote:

Hi,

Thank you for your answer, however, I can't paste excel cells into my creo drawing (I am using Creo 7, 0.7.0)

do you know why this happens?

Thank you,

---

Hi,

did you apply setting from https://www.ptc.com/en/support/article/CS355947 ?

Creo 7.0.7.0 & Excel 2016 on my PC works as expected. See video.

[BC_10219589]

Thank you very much, now it works. Do you know if there is any possibility of changing the font size and table widht/height? (once it's an excel table) The table I want to add is a very large one and I'm not sure if using this option I will be able to make it fit in one sheet and would like to control those parameters.

[MartinHanak]

Hi,

double-click the table ... Excel UI opens ... then do what you need.