Community
Navisworks Forum
Welcome to Autodesk’s Navisworks Forums. Share your knowledge, ask questions, and explore popular Navisworks topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Tabular HTML Report and Excel

11 REPLIES 11
SOLVED
Reply
Message 1 of 12
hand.jordan
4439 Views, 11 Replies

Tabular HTML Report and Excel

I am playing with the 2012 tabular report and excel import options. When I import into excel, the none of the images are properly aligned in the cells.

 

I am going to keep messing with excel to get it right, but if anyone else has run across a solution, please let me know.

 

 

Capture.PNG

11 REPLIES 11
Message 2 of 12
john.lipp
in reply to: hand.jordan

Hi hand.jordan,


W
hich version of Excel are you using?

Could you provide more details on the import options? Are these excel application options or some other options specific to importing HTML?  At first I thought you may be using Data > Get External Data > From Web, but that ignores images.  Are you opening the file through File > Open?

From the looks of it, it appears that the images have the “don’t move or size with cells” object positioning property.  If you right click on one of the clash images and select size and properties is this stated as such in the Properties tab?  By default, it should be set to Move but don’t size with cells.

I also found that unfortunately selecting a row and selecting Format > Autofit Row Height does not work with the clash images as the row height shrinks down and the images appear to collapse on one another.  Is that the same result in your case?

Would you be able to send an xls or xlsx file that shows how it is coming in?  If the data
is sensitive, you could use one of the examples in the Examples folder under Programs Files > Autodesk > Navisworks Manage 2012.

Best regards,

John Lipp
autodesk_logo_signature.png
Product Support Specialist
Autodesk Product Support

Message 3 of 12
hand.jordan
in reply to: john.lipp

I did everything in the video below from Autodesk.

 

http://youtu.be/YDtgXuDxs3Y

 

I am using excel 2007. I am opening through file->open. All of the images are set to "Move but don't size with cells". 

 

I experienced the same issue trying to uniformly resize all of the rows to accomodate the cells. 

 

On the video, it works with 2010. Unfortunately, there aren't a whole lot of settings in excel or Navis to modify the report.

 

I looked at using a macro to select all images on the worksheet and modify them at the same time, but I would like a cleaner solution.

 

Thanks,

Jordan

Message 4 of 12
john.lipp
in reply to: hand.jordan

Hi hand.jordan,  


Perhaps your Excel application is having issues with the Style Sheet contained in the HTML.  In the HTML, there is a class listed as:

 

table.mainTable tr.contentRow{

   height: 100px;

}

This should make the row 100 pixels in height which should allow the 95 pixel square image to fit properly.

I’ve attached a test file SIMPLETEST.HTML along with one of your images cd000001.jpg that should be placed in the same folder.  Try opening this SIMPLETEST.HTML in Excel.  It should look like this:

2011-06-24_1052.png


Best regards,

John Lipp
autodesk_logo_signature.png
Product Support Specialist
Autodesk Product Support

Message 5 of 12
hand.jordan
in reply to: john.lipp

Now we are getting somewhere. All of my row heights are correct (100px). The issue is related to the image size apparently as they are larger in excel 2007.

Message 6 of 12
john.lipp
in reply to: hand.jordan

Hi hand.jordan,

Could you post a screenshot of what you see in Excel when you open the SIMPLETEST.HTML file.  I am testing on MS Excel 2007, and the screenshot I previously posted is how it looks when I open it on my end.

Best regards,

John Lipp
autodesk_logo_signature.png
Product Support Specialist
Autodesk Product Support

Message 7 of 12
hand.jordan
in reply to: john.lipp

Capture.PNG

Message 8 of 12
john.lipp
in reply to: hand.jordan

Hi hand.jordan,  

I think I may have found the issue:  Please check your DPI setting in Control Panel by opening Control Panel > Appearance and Personalization > Display.

I think yours is set to Medium, as when I tested with this setting, I see the same results in Excel as your screenshots.

Try changing the setting to Smaller 100% and log off/on so the setting takes effect.  Then try opening the HTML files in Excel.

Please let us know if this solves the issue on your end.


Best regards,

John Lipp
autodesk_logo_signature.png
Product Support Specialist

Autodesk Product Support

Message 9 of 12
hand.jordan
in reply to: john.lipp

John,

 

That fixed it perfectly. Thank you for your help. 

Message 10 of 12
lauren.kerlin
in reply to: john.lipp

Hello,

I recognize this a very old thread however it's exactly the issue I'm having with my reports when exporting from Navisworks Manager 2019. Any chance there's an updated fix for the current Windows set-up since these instructions from 2011 don't translate to the current set-up? Thanks in advance!

Sincerely,

Lauren

Message 11 of 12
vania.n
in reply to: lauren.kerlin

I do exactly like @john.lipp did,
We can change the DPI setting, but now in windows 10, the location is different.
Go to setting --> System --> Display --> "Change the size of text, apps, and other items" = 100%

Then restart and you can try to open the html file again. It should fix the issue.

Message 12 of 12

Thank you so much for this tip! This is exactly what solved this bizarre issue!

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

Post to forums  

Rail Community


Autodesk Design & Make Report