excel table nightmare

[bengee5454]

I'm experiencing a bit of trouble; I go and create a table in Excel. This particular table is 5 columns x 4 rows.

In IV, Insert Object, browse to Excel table, Link, OK.

Now, sometimes, the table doesn't display correctly.....it displays blank rows/columns, or just part of the table. I have to open/close Excel or copy into new spreadsheet, or just keep trying, in order for it to work.

On other occasions, it displays the whole table!

Is there a way round this? Surely, it cant be just me!

Inventor Professional 2017.4.3

[mikegreslick6607]

Have you ever used the general table tool built in to Inventor?  You can create empty tables directly in Inventor without having to deal with excel. These are simple text tables though; you can't have functions in them (as far as I know).

You can also take this one step further and create a table from an already established excel document.

To create a general table:

http://help.autodesk.com/view/INVNTOR/2018/ENU/?guid=GUID-68E24C8A-B485-440E-8B06-7C34FF7071EB

To create a table using an .xls file:

http://help.autodesk.com/view/INVNTOR/2018/ENU/?guid=GUID-6ABFBD1A-4599-4DC2-B62A-1868F59E16E5

[bengee5454]

Thanks for the reply.

you're right, I could use a general table, but the trouble is, in the table there are merged rows - i'm not aware this can be done in IV (at least not that I'm aware of.

[johnsonshiue]

Hi! This could be related to your screen resolution. Inventor take a snapshot of the table on insert. Could you tell me what display resolution you are running?

Many thanks!

[bengee5454]

Hi Johnson,

The resolution is 1920x1080

Attached is an example of the table issue. You will notice the 2 extra columns to the right of the table. Also, not all the rows are shown.

Thanks

[bengee5454]

sorry, was checking the wrong monitor! The resolution is 1920x1200.

Thanks

[johnsonshiue]

Hi! Could you share the files here or send them to me (johnson.shiue@autodesk.com). I am using a Ultra HD monitor. I would like to see how the table behaves on my machine.

Many thanks!