how to calculate Image size in pixel to Print on A4 size sheet

Rohit Arora

hi
I am generating an image with GDI+ and pasting it in Excel work sheet. I am setting Excel sheet print size as A4 (8.27" X 11.69").
I want to generate image so that it should fit in A4 perfectly, but I am unable to calculate image size in pixels to fit perfectly in 8.27" X 11.69" inches. My system default setting is 96 dpi.

I applied some logic:-
            Dim g As Graphics = this.CreateGraphics()
            image.Width = CInt(8.27 * g.DpiX)
            image.Height = CInt(11.69 * g.DpiY)

but image is not still printing within A4. Is there anything that I am missing ?

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nicole Anderson16y ago
Hey hi friends,
This is Nicole.
The formula you have given is very useful to calculate the size of the image.
i.e width and height.
Thank you.
__________________________________________________________________

Discover the hidden source of targeted traffic that unearths eager buying customers, drives them straight to your site, and literally explodes your profits almost overnight at just simple click [url=http://uniquearticlepro.com/] unique article wizard.[/url]
0
Hirendra Sisodiya16y ago
hello Rohit
i think you need to resize image
but you can do this as above
you can try this code:
Dim g As Graphics = Me.CreateGraphics()
g.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic
g.DrawImage(Image, New Rectangle(0, 0, CInt(8.27 * g.DpiX), CInt(11.69 * g.DpiY)), New Rectangle(0, 0, Image.Width, Image.Height), GraphicsUnit.Pixel)

and use highlighted image
thanks

Plese mark as answer if it helps
0