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.
Solved! Go to Solution.
Solved by jhackney1972. Go to Solution.
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!
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.
"If you find my answer solved your question, please select the Accept Solution icon"
John Hackney
Retired
Beyond the Drafting Board
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!
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.
"If you find my answer solved your question, please select the Accept Solution icon"
John Hackney
Retired
Beyond the Drafting Board
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?
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!
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.
Hi Arron,
I am on 2023.1 update. I cannot seem to reproduce the behavior (see attached drawing).
Many thanks!
Can't find what you're looking for? Ask the community or share your knowledge.