I am currently evaluating your product. I have a project where I am trying to render spreadsheets to a PNG file. I am attaching a sample spreadsheet (TestSpreadsheet.xlsx), a file showing what the output should look like (TestSpreadsheet.png), and the output from the SheetRender method (SheetRender.png).
Since I am new to your product, there may be a better way to render the sheet, but here is the code I am using:
Dim book As New Workbook("TestSpreadsheet.xlsx")
Dim sheet As Worksheet = book.Worksheets("COMPLEX REC")
sheet.PageSetup.Orientation = PageOrientationType.Landscape
sheet.PageSetup.PaperSize = PaperSizeType.PaperLetterRotated
sheet.PageSetup.FitToPagesTall = 1
sheet.PageSetup.FitToPagesWide = 1
Dim imgOptions As New ImageOrPrintOptions()
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Png
imgOptions.HorizontalResolution = 300
imgOptions.VerticalResolution = 300
imgOptions.IsImageFitToPage = True
Dim sr As New SheetRender(sheet, imgOptions)
Dim bitmap As Bitmap = sr.ToImage(0)
The output from this snippet is an incomplete image (it is cut off on the right and the bottom). I have changed various PageSetup values and various ImageOrPrintOptions, but the attached sample is the best I have been able to accomplish. Is there a better way to render the spreadsheet to an image that contains the entire Print Area?
Note also that the text appears to be scaled improperly -- note the "B Metric Formula" block and the red notes on the center chart.