inventor ilogic to get and post data from an excel

inventor ilogic to get and post data from an excel

Anonymous
Not applicable
370 Views
2 Replies
Message 1 of 3

inventor ilogic to get and post data from an excel

Anonymous
Not applicable

hi all,

 

I am getting stuck when putting this together

 

my goal is to a build a rule/ button for my existing form:

 

1,that looks in a excel file on my "c:\" called "data.xls"

 

2, for it to look from the bottom up ( in column "C")  to the next cell with data in it and then move 1 down (to next empty line)

 

3, I then want it to take the valve from column "A" ( in that row) and input that as the part number

 

4, I then want to take the description from the model and input this into column "D" of the same row 

 

5, save the document 

 

if anyone can help thank you in advance 

0 Likes
371 Views
2 Replies
Replies (2)
Message 2 of 3

bradeneuropeArthur
Mentor
Mentor

Hi,

 

Can you upload the data file as Xls or as Txt

Regards,

Arthur Knoors

Autodesk Affiliations & Links:
blue LinkedIn LogoSquare Youtube Logo Isolated on White Background


Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:
Drawing List!|
Toggle Drawing Sheet!|
Workplane Resize!|
Drawing View Locker!|
Multi Sheet to Mono Sheet!|
Drawing Weld Symbols!|
Drawing View Label Align!|
Open From Balloon!|
Model State Lock!
Posts and Ideas:
My Ideas|
Dimension Component!|
Partlist Export!|
Derive I-properties!|
Vault Prompts Via API!|
Vault Handbook/Manual!|
Drawing Toggle Sheets!|
Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !


 


EESignature

0 Likes
Message 3 of 3

Anonymous
Not applicable

please see attached upload this is the kind of thing I want to build.

 

thank you in advance 

0 Likes