To do this you need:
- an instance of a design that inherits from :exceldoc. exceldoc takes in
templatedocpath and templatedocfilename to identify the excel file from
which to read.
- your design will have its own child, an instance of :exceldatareader.
Exceldatareader has 2 parameters you need to supply: 1) sheet = string which
is the name of the sheet and 2)range = string with excel formulation of
range. The celldata rule, when evaluated, will contain the data from those
cells.
Example of the design you might create:
Design MyExcelReader : Outputs ExcelDoc
Child myExcelData As :ExcelDataReader
Sheet = "sheet1"
Range = "A2:B200"
End Child
End Design
your instance of this design might look like this:
Child ExcelReader As :MyExcelReader
TemplateDocPath = iv_ProjectWorkspace() + "\ExcelData"
TemplateFilename = "CustomerData.xls"
End Child
wrote in message
news:6349300@discussion.autodesk.com...
Hello All,
I am looking for a small eexample how to read data from an excel-table,
using Intent 2010 with Inventor.
I'd apprichiate any hint.
Sebastian