While working on document generation on server side, where Open XML SDK is the tool for a developer, I came across a scenario where the requirement was to generate Open XML based Excel Workbooks (XLSX), from older format of Excel Workbooks (XLS) files which contained a huge amount of data, like million rows in a [...]

Posted in Office (General), Open XML | 1 Comment »

Hello everyone! In the last post we left off with a small example of how to automate Microsoft Office applications from our custom solutions. This week we are going to discuss about what does Microsoft Office object model means, and will discuss about various classes/interfaces available in the Office applications. As I had mentioned earlier, [...]

Posted in Office Automation | 3 Comments »

It has been a while when I last posted something… and with this post I am making a comeback While working with Word during these days, I encountered a scenario where, if I had an Alternate Data Stream (ADS) associated with Word 97-2003 format document and I converted it to the newest format (DOCX format) [...]

Posted in Office Automation | 1 Comment »

While working with PowerPoint 2007 today I noticed a strange behavior: If you have a Chart in an Excel workbook, and you want to insert this chart as link in a PowerPoint Slide by using Paste Special, it may fail to paste anything in the slide if the current view is Outline View. Also, even [...]

Posted in Office (General) | 5 Comments »

Let’s say we have created an ActiveX control using the wizard in Visual Studio 2008, and have checked the “Available in Insert Object Dialog” checkbox on the last page of the wizard as shown below: As the name suggests, this setting enables the ActiveX control to be in “Insert Object” dialog box, which is available [...]

Posted in Office Automation | 1 Comment »