I am in the process of evaluating Cells and Words and I have a need to export a range to an image for later import into Word. I am working with .net and C#, VS2013.
I need the image to be sized in a specific way. For example, 6"x6" at 300dpi
I have tried the following code :
sheet.PageSetup.PrintArea = "A1:CH41";ImageOrPrintOptions options = new ImageOrPrintOptions();
options.OnePagePerSheet = true;
options.VerticalResolution = 300;
options.HorizontalResolution = 300;
options.ImageFormat = System.Drawing.Imaging.ImageFormat.Png;ImageFormat.Png;
This certainly gives me an image but it is 14" by 30" image so I have to resize.
What I can't find is a property to set an explicit size for width and height so that I can set width as, for example, "width = 6.0 * dpi".
Any suggestions?