private WorksheetPart wsSheet = null; // WorkSheetPart #endregion Fields #region Constructors public LogGenerator(string fn) { //// get spreadsheet path from constructor //path = folder; //// File name is based on date and time //DateTime now = DateTime.Now; //// Construct the spreadsheet filename //string fn = string.Format("{0}\\report_{1}-{2}-{3}_{4}{5}{6}.xlsx", // path, now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); if (File.Exists(fn)) { doc = SpreadsheetDocument.Open(fn, true); } else { // // Create the Spreadsheet document // doc = SpreadsheetDocument.Create(fn, SpreadsheetDocumentType.Workbook); // // Add WoorkBookPart to the document // wbPart = doc.AddWorkbookPart(); wbPart.Workbook = new Workbook(); wbPart.Workbook.AddNamespaceDeclaration("x", "http://schemas.openxmlformats.org/spreadsheetml/2006/main"); // // Add WorkSheetPart to the WorkBookPart // wsSheet = wbPart.AddNewPart<WorksheetPart>(); wsSheet.Worksheet = new Worksheet(new SheetData()); wsSheet.Worksheet.AddNamespaceDeclaration("x", "http://schemas.openxmlformats.org/spreadsheetml/2006/main"); // // Add sheets to the WorkBook // sheets = doc.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets()); // // Append new sheet and associate it with the workbook // sheet = new Sheet() { Id = doc.WorkbookPart.GetIdOfPart(wsSheet), SheetId = 1, Name = wsName }; sheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); sheets.Append(sheet); wbPart.Workbook.Save(); //CreatePackage(fn); //if (File.Exists(fn)) //{ // TestXls(); //} } }
// Generates content of workbookPart1. private void GenerateWorkbookPart1Content(WorkbookPart workbookPart1) { Workbook workbook1 = new Workbook(); workbook1.AddNamespaceDeclaration("x", "http://schemas.openxmlformats.org/spreadsheetml/2006/main"); Sheets sheets1 = new Sheets(); sheets = sheets1; Sheet sheet1 = new Sheet() { Name = "oi_th", SheetId = (UInt32Value)1U, Id = "R3c8458136e1d4b6c" }; sheet1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); sheet = sheet1; sheets1.Append(sheet1); workbook1.Append(sheets1); workbookPart1.Workbook = workbook1; }