Add document to Spreadsheet via OLE

What is OLE object for Spreadsheet?

The OLE technology provided by Microsoft allows to insert some other document content into the cell that is previosly selected by RowIndex and ColumnIndex of the currently editing Excel spreadsheet. For example, the PDF document can be inserted in the Excel spreadsheet document as image link inside of predefined cell as was presented in the example below.

Add document to Spreadsheet via OLE

GroupDocs.Merger provides an ability to add other single document as embedded document to Presentation. 
Here are the steps for it:

The following code sample demonstrates how to add other single document as embedded document to Excel spreadsheet:

string filePath = @"c:\sample.xlsx";
string filePathEmbedded = @"c:\embedded.pdf";
string filePathOut = @"c:\output\result.xlsx";

int pageNumber = 2;
OleSpreadsheetOptions oleSpreadsheetOptions = new OleSpreadsheetOptions(filePathEmbedded, pageNumber);
oleSpreadsheetOptions.RowIndex = 2;
oleSpreadsheetOptions.ColumnIndex = 2;

using (Merger merger = new Merger(filePath))
{
    merger.ImportDocument(oleSpreadsheetOptions);
    merger.Save(filePathOut);
}

More resources

Advanced Usage Topics 

To learn more about document merging features, please refer the advanced usage section.

GitHub Examples 

You may easily run the code above and see the feature in action in our GitHub examples:

Free Online App

Along with full featured .NET library we provide simple, but powerful free Apps.
You are welcome to merge your documents with our free online GroupDocs Merger App.