Hi,
Thanks for the files.
I can find the issues using your new template file as mentioned in your attached docx file ("ExcelIssuesScreenshots.docx"-screen shots).
Sample code:
Aspose.Cells.Workbook book = new Aspose.Cells.Workbook("e:\\test2\\ExcelIssuesJan2.xlsx");
Aspose.Cells.Worksheet sheet;
Aspose.Cells.Rendering.ImageOrPrintOptions imgOptions;
Aspose.Cells.Rendering.SheetRender sr;
Bitmap bitmap;
string number = "";
string[] name = new string[100];
imgOptions = new Aspose.Cells.Rendering.ImageOrPrintOptions();
for (int i = 0; i < book.Worksheets.Count; i++)
{
sheet = book.Worksheets[i];
imgOptions.HorizontalResolution = 118;
imgOptions.VerticalResolution = 112;
imgOptions.OnePagePerSheet = true;
imgOptions.IsImageFitToPage = true;
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Tiff;
sr = new Aspose.Cells.Rendering.SheetRender(sheet, imgOptions);
if (i < 10)
{
number = "00" + i.ToString();
}
else if (i >= 10 && i < 100)
{
number = "0" + i;
}
else
{
number = i.ToString();
}
bitmap = sr.ToImage(0);
bitmap.Save("e:" + "\\test2\\convv\\qsheetimage" + sheet.Index + number + ".tiff");
}
I have reopened your issue now, we will look into it soon.
Thank you.