Inventor General Discussion

Inventor General Discussion

Reply
New Member
1 Posts
0 Kudos
Registered: ‎09-20-2013
Post 1 of 2

iLogic - replace or refresh embedded excel spreadsheet

240 Views, 1 Replies
09-20-2013 02:01 AM

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?

 

New Member
1 Posts
0 Kudos
Registered: ‎01-07-2014
Post 2 of 2

Re: iLogic - replace or refresh embedded excel spreadsheet

01-07-2014 05:50 AM 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

 


 

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!