Tabular HTML Report and Excel

[Anonymous]

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.

[john.lipp]

Hi hand.jordan,


Which 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

Product Support Specialist
Autodesk Product Support

[Anonymous]

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

[john.lipp]

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:




Best regards,

John Lipp

Product Support Specialist
Autodesk Product Support

[Anonymous]

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.

[john.lipp]

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

Product Support Specialist
Autodesk Product Support

[Anonymous]

[john.lipp · Accepted solution]

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

Product Support Specialist

Autodesk Product Support

[Anonymous]

John,

That fixed it perfectly. Thank you for your help. 

[Anonymous]

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

[vania.n]

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.

[dquennevilleXCQUT]

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