Inventor General Discussion

Inventor General Discussion

Reply
New Member
TopAce80
Posts: 1
Registered: ‎09-20-2013
Message 1 of 2 (217 Views)

iLogic - replace or refresh embedded excel spreadsheet

217 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
HOLDflash
Posts: 1
Registered: ‎01-07-2014
Message 2 of 2 (127 Views)

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
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.