Converting Excel Column with To SSRS (inch or pt)

I have report in Excel that I user gave me and wants the same exact format in the new SSRS report. So if I have a column in excel of the width 14.14 (103 pixels) what should that be for the width of that column in SSRS ( in, mm, cm, pt, or pc)?

I can't get the correct factor because it seems to differ based on size?

Excel Width     Pixels   Ratio  
0.08            1        0.08   
0.83            10       0.083  
13.57           100      0.1357 ??
142.14          1000     0.14214    
254.71          1788     0.142455257    

I understand pixels per inch is dpi dependent, but what I am looking for is a printable equivalent.


Excel (and many other MS related apps) default to 96 pixels per inch.

So your 103 pixel wide Excel column should be: 103 / 96 = 1.073 inches (Rounded to thousands.)

Of course many printing options will change this, such as "Fit on one page."

Here is what I found out about the relationship between excel and ssrs. It seems excel uses 96 pixels per inch. I also found using units of PT in ssrs translates much more accurately into excel and is actually mentioned somewhere in the MSDN documentaiton.

In excel a column of 10 = 75 pixels, 20 = 145 pixels, etc. Basically the units are 70 plus an additional 5 pixels.

So to set the column in ssrs I used:

[Width in PT] = ([width in excel] / 10 * 70 + 5) / 96 * 72)

For example: Width 10 in excel = 75 pixels = 56.25 pts = .78125"

I used RhodeHummels answer, however I had to change it because there is a missing parenthesis in the answer, I believe it should read:

[Width in PT] = (([Width in excel]/10 * 70 + 5)/ 96 * 72)

e.g. =((10/10*70+5)/96*72) gets the desired answer in excel

Need Your Help

XML parser skipping duplicate values JAVA

java xml parsing xml-parsing

I've written an XML parser which parses an XML documents and returns me a Map of and ID and Name. For some reason it's skipping duplicates IDs.

Can I extend lisp with c++?

c++ lisp extend

Can I call a function from lisp from a library written in c or c++? How can I extend lisp?