How to save file to folder if excel cell contain embed object

ajay raju

Hi,

I have an excel file and one cell of every row contain embed pdf file object and remaining cells contain string values.

How to check if cell contain embed object then save that object file into folder and also save the file path and remaining values in database using asp.net with c#.

Any ideas will helpful.

Thanks,

Ajay.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

ajay raju4y ago
Thank you Amit and Leon for your suggestion, but I want to implement using "Microsoft.Office.Interop.Excel" namespace and "OLEObject" class. Please check my excel file looks like

I want to save this excel file data in sql database, I can read the cell data of Date, Store, Category, Cost, Total, Method columns using oledb provider or using Workbook and Worksheet classes and save it in database table fine.
but coming to the Receipt column it showing null value when reading from either oledb or worksheet,
1) I want to save embedded object in local folder row wise and get filepath
2) Insert excel row data and for 'Receipt' column I need to save filepath

I will show this data in grid, for Receipt column I will set hyperlink and give filepath, so user can view the pdf that saved of that row.

Any ideas how to implement this functionality will helpful, dont want to use third pary assembly references.

Thanks,
Ajay
+2
Leon D4y ago
You can use Free Spire.XLS to extract ole objects such as PDF, PowerPoint and Word files from Excel.
https://www.e-iceblue.com/Download/download-excel-for-net-free.html (also available on NuGet)

Code example:
//Create a workbook
            Workbook workbook = new Workbook();

            //Load the document from disk
            workbook.LoadFromFile(@"..\..\..\..\..\..\Data\ExtractOle2.xlsx");

            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Extract ole objects
            if (sheet.HasOleObjects)
            {
                for (int i = 0; i < sheet.OleObjects.Count; i++)
                {
                    var Object = sheet.OleObjects[i];
                    OleObjectType type = sheet.OleObjects[i].ObjectType;
                    switch (type)
                    {
                        //Word document
                        case OleObjectType.WordDocument:
                            File.WriteAllBytes("Ole.docx", Object.OleData);
                            break;
                        //PowerPoint document
                        case OleObjectType.PowerPointSlide:
                            File.WriteAllBytes("Ole.pptx", Object.OleData);
                            break;
                        //PDF document
                        case OleObjectType.AdobeAcrobatDocument:
                            File.WriteAllBytes("Ole.pdf", Object.OleData);
                            break;
                    }
                }
            }
+2
Amit Mohanty4y ago
This is the code snippets, how to save embedded pdf file.
var workbook = ExcelFile.Load("input.xlsx");
var worksheet = workbook.Worksheets[0];

var embeddedObjects = worksheet.EmbeddedObjects;

for (int index = 0; index < embeddedObjects.Count; index++)
{
    ExcelEmbeddedObject embeddedObject = embeddedObjects[index];
    if (embeddedObject.ContentType != "application/vnd.openxmlformats-officedocument.oleObject")
        continue;

    byte[] embeddedBytes;
    using (var memoryStream = new MemoryStream())
    {
        embeddedObject.Data.CopyTo(memoryStream);
        embeddedBytes = memoryStream.ToArray();
    }

    string embeddedContent = Encoding.ASCII.GetString(embeddedBytes);
    int pdfHeaderIndex = embeddedContent.IndexOf("%PDF");
    if (pdfHeaderIndex < 0)
        continue;

    byte[] pdfBytes = new byte[embeddedBytes.Length - pdfHeaderIndex];
    Array.Copy(embeddedBytes, pdfHeaderIndex, pdfBytes, 0, pdfBytes.Length);

    File.WriteAllBytes($"embedded-pdf-{index}.pdf", pdfBytes);
}
in the below line we check that the content is embaded or not
if (embeddedObject.ContentType != "application/vnd.openxmlformats-officedocument.oleObject")
+2