Please see my code
using (var ms = new FileStream("/tmp/various-objects.xlsx", FileMode.OpenOrCreate, FileAccess.Read))
{
ms.Position = 0;
using (var workbook = new Workbook(ms))
{
Stopwatch s = new Stopwatch();
s.Start();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.PageSetup.PrintArea = “A1:N50”;
// Set all margins as 0
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.BottomMargin = 0;
// Set OnePagePerSheet option as true
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.OnePagePerSheet = true;
options.ImageType = Aspose.Cells.Drawing.ImageType.Png;
options.OnlyArea = true;
//options.HorizontalResolution = 90;
//options.VerticalResolution = 90;
SheetRender sr = new SheetRender(worksheet, options);
using (var msImg = new MemoryStream())
{
sr.ToImage(0, msImg);
//Console.WriteLine(Convert.ToBase64String(msImg.ToArray()));
//Convert.ToBase64String(msImg.ToArray());
sr.ToImage(0, "/tmp/" + Guid.NewGuid() + ".png");
}
s.Stop();
Console.WriteLine(s.ElapsedMilliseconds);
}
}
Running under Linux always throw an error. We understand that this might be related to the missing culture or miss mapping the LCID. However, if you have ever experienced this issue before, please provide the workaround solution. Thanks
various-objects.xlsx.zip (1.2 MB)