Build 3.5.0.29 of xlsgen makes it possible to insert arbitrary OLE objects in XLS and XLSX files.

Both a cell-based API and a pixel-based API are available, so you can pick which one you prefer.

Here is an example of how it works (C#) :

IXlsWorksheet worksheet = workbook.AddWorksheet( "Sheet1" );

IXlsOLEObject oleObject = worksheet.OLEObjects.NewOLEObjectInPixels("C:\\tmp\\cylinders.pdf", 
                                              100, //top
                                              50,  //left
                                              350, //bottom
                                              658 //right
                                              );

Build 3.5.0.28 of xlsgen improves OLE object reading from XLS and XLSX files.

In XLS files, OLE servers can actually store the internal OLE object in different streams than expected (such as Ole10Native). xlsgen supports this case as well as the regular case.

In XLSX files, Excel 2010 stores OLE objects differently than previous Excel versions. xlsgen supports this cases as well as all other cases.

xlsgen also improves the extraction of OLE object details in case they are stored neutrally (as Packages), instead of being stored with fully qualified identifiers (such as Acrobat.Document for a PDF document).

Build 3.5.0.27 of xlsgen fixes how Form elements in spreadsheets are preserved and mixed with other legacy drawing elements in XLSX files. When adding/deleting objects such as comments or OLE objects, there could have been a collision with existing Form elements (buttons, combo-boxes, ...).

Build 3.5.0.26 of xlsgen includes a fix for writing page breaks in XLSX files. The way page breaks are stored is now 100% compatible with the way Excel expects them.