Importing parameters from excel; data type problem
Importing parameters from excel; data type problem
(OP)
When I import parameters from an excel file into a drawing, I have problems with the data type.
Basically I am making a tool list template. There are 23 tools each with 6 pieces of information, so there will be 138 parameters. It is much easier to enter data within excel which is why I choose to do it this way.
In the template file I want to import the parameters from the excel file with blank values which I will tie into a table.
When I instantiate the template file for use, I want to import the excel file to update the values. When I do this though, anything that was destined to be a number returns a data type error. Strings seem to be fine.
It seems that the initial import just assumes it is a string regardless of the data format used in excel (number, text, general...)
I don't want to one-by-one create 138 parameters and assign the data types through the parameter editor. I can't seem to find a way to change the data type once a parameter is created.
Anyone?
Nick
Basically I am making a tool list template. There are 23 tools each with 6 pieces of information, so there will be 138 parameters. It is much easier to enter data within excel which is why I choose to do it this way.
In the template file I want to import the parameters from the excel file with blank values which I will tie into a table.
When I instantiate the template file for use, I want to import the excel file to update the values. When I do this though, anything that was destined to be a number returns a data type error. Strings seem to be fine.
It seems that the initial import just assumes it is a string regardless of the data format used in excel (number, text, general...)
I don't want to one-by-one create 138 parameters and assign the data types through the parameter editor. I can't seem to find a way to change the data type once a parameter is created.
Anyone?
Nick
Light structural commercial aircraft parts
PCDMIS 4.3 CAD++, CATIA V5 R20
APM Consortium Inc.
Cambridge Ontario, Canada





RE: Importing parameters from excel; data type problem
Nick
Light structural commercial aircraft parts
PCDMIS 4.3 CAD++, CATIA V5 R20
APM Consortium Inc.
Cambridge Ontario, Canada
RE: Importing parameters from excel; data type problem
So, on my initial import of the parameters into the template file, I have dummy numbers and dummy text where I expect numbers and text to go. This seems to work.
Premature post-ulation...
Nick
Light structural commercial aircraft parts
PCDMIS 4.3 CAD++, CATIA V5 R20
APM Consortium Inc.
Cambridge Ontario, Canada
RE: Importing parameters from excel; data type problem
Nick
Light structural commercial aircraft parts
PCDMIS 4.3 CAD++, CATIA V5 R20
APM Consortium Inc.
Cambridge Ontario, Canada