Using Aspose.Cells 7.5 and working with the attached spreadsheet, exceptions are thrown when either attempting to access the embedded ole object data (OverflowException), or saving the spreadsheet to PDF (CellsException). Is there any way to correct or work around theses issues? The primary concern is to still be able to render a PDF, even if certain embedded data is omitted.
Here is the repro code:
public void Test(string sourcePath)
{
var workbook = new Workbook(sourcePath);
foreach (Worksheet sheet in workbook.Worksheets)
{
foreach (OleObject obj in sheet.OleObjects)
{
try
{
if (obj.ImageData != null) //throws
{
Console.WriteLine("Embedded object image format: " + obj.ImageFormat);
}
}
catch (Exception ex)
{
Console.WriteLine("Unable to access ole image data " + ex.GetType().Name + ": " + ex.Message);
}
}
}
try
{
workbook.Save(sourcePath + “.pdf”, SaveFormat.Pdf);
Console.WriteLine(“Save to PDF successful”);
}
catch (Exception ex)
{
Console.WriteLine("Unable to save Excel to PDF " + ex.GetType().Name + ": " + ex.Message);
}
}