We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

ODS OLE Attachments

I am attaching an ODS file which when extracting the attachments does not extract them correctly. The storage files are being extracted and not the contents of the storage. The same file created in a XLSX format extracts the contents of the storage files (in this case txt, tif, docx and zip).

The following is an abridged piece of code which shows what we are doing.

            foreach (var worksheet in workbook.Worksheets)
            {
                var index = 0;
                var oleObjects = worksheet.OleObjects;
                foreach (var oleObject in oleObjects)
                {
                    FileStream fs = null;
                    try
                    {
                        var filePath = "Attachment" + index;

                        fs = File.Open(filePath, FileMode.Create, FileAccess.Write);
                        using (var bw = new BinaryWriter(fs))
                        {
                            fs = null;
                            bw.Write(oleObject.ObjectData);
                        }
                    }
                    finally
                    {
                        fs?.Dispose();
                        index++;
                    }
                }
            }

It would be great if the attachments in the ODS format files were saved out the same as the xlsx format.

AsposeCellsExamples.zip (1.3 MB)

@lawgb686,

Thanks for the sample ODS file and details.

Please notice, after an initial test, I am able to reproduce the issue as you mentioned by using your template ODS file. I found when extracting the attachments form ODS file, it does not extract them correctly. I have logged a ticket with an id “CELLSNET-50684” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@lawgb686
hi,
Your issue has been resolved and the fixed functionality will be released with version 22.4. If you need this feature urgently, you can also consult our hot fix.
Here is the resulting file I generated using the latest function:
CELLSNET-50684.zip (656.3 KB)

The issues you have found earlier (filed as CELLSNET-50684) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi