I'm using VS2010 VB.NET and Aspose Version 22.214.171.124.
I'm trying to convert 9 small worksheets to images and then paste the images together in a new worksheet so that when it's complete it looks like a 3 x 3 grid with each grid cell holding one of the small worksheet images. (see attached)
I'm having several issues:
(1) when i convert the worksheets to an image, the columns to the right are missing from the image. I tried using the ImageOrPrintOptions OnlyArea, and also setting the print area on the template but that didnt seem to work.
(2) the images have large margins on the top and left. Can i get elimimate the margins?
(3) I want to resize the row that I put the image(s) in to be the height of the tallest image. Auto-resize doesn't seem to work in this case. Is there a way to set the rowheight of the column containing an image to equal the height of the image? I need to have 3 images across the top, aligned at the top...then under that the next 3, then under that the next 3.
(4) Whats the best way to scale these images without losing quality? Sometimes I may need to shrink them.
I've attached the source code, the excel template and some screen shots of the resulting pdf.
I would greatly appreciate any help you could provide on these questions/issues.