Inventor Engineer-To-Order (Read-Only)
Welcome to Autodesk’s Inventor ETO Forums. Share your knowledge, ask questions, and explore popular Inventor ETO topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Reading data from existing Excel-Table

1 REPLY 1
Reply
Message 1 of 2
sebastian.cordes
316 Views, 1 Reply

Reading data from existing Excel-Table

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
1 REPLY 1
Message 2 of 2
Anonymous
in reply to: sebastian.cordes

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

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

Post to forums  

Autodesk Design & Make Report