Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Embedding Excel into Sheet Metal template

79 REPLIES 79
SOLVED
Reply
Message 1 of 80
Breeze104
2220 Views, 79 Replies

Embedding Excel into Sheet Metal template

First off..Noob question... How do you embed (not link) an excel spread sheet into my sheet metal template.  The excel file is simple, 2 rows listing the A1=gauge and B1= decimal equivalent.

 

What I want to do with this is to get the gauge to show up in the iProperties description along with length and width of part.  The thing is I need colum A to show up in the iProperties (12GA) but colum B to be used for the sheet metal default thicness.

 

I keep getting this errorwhen I run my code.....

 

Error in rule: Gauge, in document: Part1

GoExcel: 3rd Party worksheet not found: "3rd Party:Embedding 1", Sheet: "Sheet1"

 

Code so far..

i = GoExcel.FindRow("3rd Party:Embedding 1", "Sheet1", "Gauge", "<=", iProperties.Value("Custom", "Gauge"))

MultiValue.List("Thickness") = GoExcel.CellValues("3rd Party:Embedding 1", "Sheet1", "B2", "B35")

 

So I need help with both the embedding and code. 

79 REPLIES 79
Message 61 of 80
jletcher
in reply to: Breeze104

Design Data is the place your styles are saved if you project points to one but you have your applications options set to another this could be why.

 

Look at pics may help.

Same.JPG

Project.JPG

Message 62 of 80
Breeze104
in reply to: jletcher

I thought that is what you were talking about and yes they are the same.  I only have one main project and so all setting are according to it and I only have 1 ver of Inventor installed...2013

Message 63 of 80
jletcher
in reply to: Breeze104

OK try this instead of saveas do a save copy as it is differnt But if they are in your styles it should show up. But I also have not load 2013 yet there are to many issues so I will wait till 2014 I hope they work out all the bugs by then. But I will not hold my breath LOL.

 

I have it loaded at the main office but I have not set up anything with it.

Message 64 of 80
Breeze104
in reply to: jletcher

Ok I will try after lunch...Boss is cooking smoked brisket..Yummmmmm

One of the guys is retiring...I will eat an extra piece just for you...LOL

Message 65 of 80
jletcher
in reply to: Breeze104

Wow your going to eat my brisket...Smiley Mad

 

 

Fine figure this out by yourself Smiley Happy

 

 

 

 

 

 

 

 

 

 

 

 

Just kidding Smiley LOL

Message 66 of 80
Breeze104
in reply to: jletcher

Don't worry it wasn't that good......  Man Sad

 

 

 

 your right...

 

 

 

 

 

 

 

..I lied....  

Man Wink

 

 

 

 

 

 

 

Message 67 of 80
Breeze104
in reply to: jletcher

Here's one for you.....

I closed out of the file I was in...I checked the locations you wanted me to check...Reopened a new sheet metal part....and are you ready for this......

 

 

 

Now I have doubles of almost everything I created..How is that for bizarre....LOL

 

And it won't let me delete the styles I don't want..

Message 68 of 80
jletcher
in reply to: Breeze104

LOL now you see why I did not load 2013...........

 

Do you remember when autocad was cursed by the odd number release well I think Inventor caught the bug....

Message 69 of 80
Breeze104
in reply to: jletcher

I was having so much trougle with 2012 that I figured 2013 couldn't be to much worse...LOL

 

 

My first job I was using ACAD 13...So I din't know any different...LOL

 

 

Message 70 of 80
Breeze104
in reply to: Breeze104

What button are you talking about???

 

"how to you save back to template did you use the make template button?"

Message 71 of 80
jletcher
in reply to: Breeze104

Well I can't remember 2013 but under the saveas if you wait another window expands and there is more options. But I don't use the template button the supplied I use save copy as not saveas

 

Here pic

Save as.JPG

Message 72 of 80
Breeze104
in reply to: jletcher

Boy am I blind....  Smiley Frustrated Smiley Embarassed

 

Looked right past it 3 times...errrrrr

Message 73 of 80
jletcher
in reply to: Breeze104

Oh i see how you are helped you out and did not give me the solved wow really Smiley Mad

 

 

 

 

Just kidding have fun with it Smiley Happy

Message 74 of 80
Breeze104
in reply to: Breeze104

Now we close out

 

Reboot and see if it stays....

Message 75 of 80
Breeze104
in reply to: jletcher

I did....

 

Back when you posted the code...on Page 5.... AND.... I gave Kudos on almost all your replies that helped.  You must have a dozen + Kudos by now....

 

Woman Sad Smiley Sad Cat Sad Robot Sad

 

 

 

 

 

Man LOL Smiley LOL Robot LOL

 THANKS FOR ALL YOUR HELP!!!  

 

Message 76 of 80
jletcher
in reply to: Breeze104

Yeah i seen all them but I only giving you a hard time .. Smiley Happy

 

 

See.JPG

 

But really don't care just want give you a hard time Smiley Very Happy

Message 77 of 80
Breeze104
in reply to: jletcher

I know...LOL

Message 78 of 80
Breeze104
in reply to: Breeze104

Well after reboot I still have all of the styles...even the ones I didn't want and can't seem to get rid of......LOL

Message 79 of 80
jletcher
in reply to: Breeze104

Did 2013 come with a Style Libary Manager I can't remember. it will be under the programs of your start button > inventor 2013 > tools

Message 80 of 80
Breeze104
in reply to: jletcher

yes it does and that took care of the issue.

 

Thanks again!!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report