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: 

iLogic - replace or refresh embedded excel spreadsheet

1 REPLY 1
Reply
Message 1 of 2
TopAce80
540 Views, 1 Reply

iLogic - replace or refresh embedded excel spreadsheet

Hi,

 

For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.

 

For now i use the following rule:

 

For I = 65 To 90 '65=A 90=Z
	Buchstabe = Chr(I) 
	GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:\Konstruktion\Vorlagen\Materialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")
Next I 

 it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.

 

Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?

 

1 REPLY 1
Message 2 of 2
HOLDflash
in reply to: TopAce80

Hi


i'm trying to write part number in embeded.xml file with ilogic. Is this possibile?

 

Thanks for answering

 

Peter

 


 

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

Post to forums  

Autodesk Design & Make Report