Inventor General Discussion

Inventor General Discussion

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

iLogic - replace or refresh embedded excel spreadsheet

207 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 (117 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

 


 

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

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