Dan's Code samples

//complete code sample using Mikes Knowlegebase libs     private static void WriteExcelFile(DataSet ds, SpreadsheetDocument spreadsheet)     {       //  Create the Excel file contents.  This function is used when creating an Excel file either writing        //  to a file, or writing to a MemoryStream.       spreadsheet.AddWorkbookPart();       spreadsheet.WorkbookPart.Workbook = new DocumentFormat.OpenXml.Spreadsheet.Workbook();       //  My thanks to James Miera for the following line of code (which prevents crashes in Excel 2010)       spreadsheet.WorkbookPart.Workbook.Append(new BookViews(new WorkbookView()));       //  If we don't add a "WorkbookStylesPart", OLEDB will refuse to connect to this .xlsx file !       WorkbookStylesPart workbookStylesPart = spreadsheet.WorkbookPart.AddNewPart<Workboo...