Reading EXCEL FILE in a collection using Open XML SDK 2.0

In my previous article I talked about Inserting in Excel file from C# collection using Open XML SDK 2.0 before you go ahead, I strongly recommend you to read this post. In this post, let us try to do the reverse process. We will read all the rows of Excel file List of Bloggers. Again … Continue reading Reading EXCEL FILE in a collection using Open XML SDK 2.0

Inserting in Excel file from C# collection using Open XML SDK 2.0

In this post I will show inserting rows in excel file from a c Sharp list using Open XML SDK. Open XML SDK is very useful when you don’t want to or cannot use Microsoft Office InterOP dll. You can download it from below URL http://www.microsoft.com/download/en/details.aspx?id=5124 Once you download and run the MSI follow the … Continue reading Inserting in Excel file from C# collection using Open XML SDK 2.0

Creating and updating EXCEL file in Windows Azure Web Role using Open XML SDK

Problem Statement You need to create and upload EXCEL file in Windows Azure Web Role. Since there is no MS Office present on AZURE VM so you cannot use Office InterOP Dll. So you are left with option of Open XML SDK to create and update Excel file. Solution Approach Create and update Excel file … Continue reading Creating and updating EXCEL file in Windows Azure Web Role using Open XML SDK