Linked Excel File - Can you only bring in so many lines?

[mslosar]

I'm working on something that can have anywhere from 5 to 100 parts.

I'm trying to set up a spreadsheet to pull the values from, but, if i'm only going to have 10 parts, i'd like to just have parameters needed for those 10 parts to be linked into excel. There's no reason to have a bunch of zero values for parts 11-100...

I've tried conditional statements in the excel file to show blanks in those situations, but it errors on the inventor side when I try and link the file.

Is there anything to get around that in inventor, or a method in vb that'll import from A1 to C11 type of thing?

[YuhanZhang]

Can you help to list steps for what you want to do and we can understand your requirement more easily?

[Anonymous]

Dear Mslosar

When you link Excel table with Inventor, only sheet1 is linked i.e. only data from sheet1 are imported. That mean, your real data should have to be on sheet2 from A2 to C101 and on sheet1 from A2 to C101 should be formulas =IF(sheet2!A2="0","",sheet2!A2). On A1 to C1 should be name for colomns.

Regards,

Nedeljko