tabella excel

[learningcad]

Hi.
I have to insert a table from excel in casket.
I explain better, in sheet 1 (accessible to all) of my workbook I have inserted the parameters to edit, in sheet 2 (changeable only from me) in some and in sheet 3 incollo as a link a little column of sheet 1 and sheet 2.
When I admit the table in the casket, the program does not see the columns that are "paste as a link". How can I do that?
thanks to all:smile:

 

[gianni55]

Hi.

I don't have excel (but libre office) so I can't check.

I seem to remember that excel has the option to replace the formula with the "value" of the cell, so you could try in 2 ways:

the first:

create the cell with connection in a position (e.g. d5, which will have inside the formula:? ? #$foglio1.g5)
Cops and incolli (only value) the cell in the field used by catia (the cell should show the value and if selected a =d5)

If it works, you're fine.

if instead to catia does not like that =d5, but probably seeks a text,

then try the second:

do the same thing but create a macro in excel that at closing the file select the fields and then copy them and paste them "only values".

Let me know.

Hi.

years ago

 

[learningcad]

Hi.
thanks for the suggestion, it worked!
I created a macro that only copies the values and so does it read them.
Thank you very much: