Visible Cells From Inserted Excel Sheet

[Anonymous]

Hi all,

I've inserted an excel sheet from to my .idw file using the "create from file" option from the "insert object" button.

Though the spreadsheet is showing the information I've entered it is also showing a bunch of blank cells. 

Is there a way to choose which cells are visible in the .idw file? i.e. hide the blank cells?

Please see attached screen shot. 

Thank you in advance!

kelly.young has embedded your image for clarity.

[johnsonshiue]

Hi! Could you try something real quick for me? If you do the same workflow in Microsoft Word (Insert -> Objects -> pick the same Excel file), do you see the same behavior?

Many thanks!

[jhackney1972 · Accepted solution]

The cause of your issue is the cells that contain no data are showing up because they still have formatting applied.  If you delete these cells, only the ones containing data will be the only one imported.  Take a look at the screencast where I did this to prove my point.

[Anonymous]

That worked!

Thank you very much jhackney1972.

On a side note may I ask what software you used to record the video? It would be very helpful to be able to use a video to explain future questions / issues / topics. 

Thanks again!

[jhackney1972]

It is the standard Autodesk Screencast application.  I do not know what Inventor version you are using but it is installed by default with Inventor 2019, unless you skip it.  If you need to download it, you can find it here, it is free.

[Anonymous]

Thank you very much!

[andrea.miclausigVCVTY]

Dear @jhackney1972, I'm facing the same problem in Inventor 2022 and deleting the cells apparently doesn't solve the issue. Also, the screencast you've made was deleted.

Can you help me?

[johnsonshiue]

Hi Andrea,

I suspect you may need to change the scope of the spreadsheet page. Open the Excel file and go to Page Setup. Make sure the only needed cells are included.

Many thanks!

[arron.craig]

Have run into this same issue in Inventor 2023, clearing all contents from the "extra" cells hasn't solved it and I'm not 100% sure what @johnsonshiue is describing in the page set-up. Example table attached since the real table can't be shared.

[johnsonshiue]

Hi Arron,

I am on 2023.1 update. I cannot seem to reproduce the behavior (see attached drawing).

Many thanks!