/// <summary> /// Class constructor /// </summary> /// <param name="document">Document to perform operations on</param> /// <param name="fullName">Full path name of document</param> public SpreadsheetDocument(OpenXmlSDK.SpreadsheetDocument document, string fullName) : base() { Document = document; FullName = fullName; InnerContent = new SpreadsheetDocumentManager(this); Worksheets = new WorksheetAccessor(this); Chartsheets = new ChartsheetAccessor(this); CustomProperties = new CustomPropertiesAccesor(this); Tables = new SpreadSheetTableAccesor(this); Style = new SpreadSheetStyleAccessor(this); }
/// <summary> /// Creates a new SpreadsheetDocument from a new or existing file /// </summary> /// <param name="filePath">Path of file</param> /// <param name="createNew">Whether create a new document or load from an existing one</param> public SpreadsheetDocument(string filePath, bool createNew) { try { if (createNew) { Document = OpenXmlSDK.SpreadsheetDocument.Create(filePath, DocumentFormat.OpenXml.SpreadsheetDocumentType.Workbook); } else { Document = OpenXmlSDK.SpreadsheetDocument.Open(filePath, true); } } catch (Exception e) { System.Diagnostics.Debug.Write(e.Message); } FullName = filePath; InnerContent = new SpreadsheetDocumentManager(this); Worksheets = new WorksheetAccessor(this); Chartsheets = new ChartsheetAccessor(this); CustomProperties = new CustomPropertiesAccesor(this); }
/// <summary> /// Creates a SpreadsheetDocument from a data table /// </summary> /// <param name="outputPath">Path of generated file</param> /// <param name="headerList">Header row contents</param> /// <param name="valueTable">Data values</param> /// <param name="initialRow">Row index to start copying data</param> /// <returns>Spreadsheet document</returns> public static SpreadsheetDocument Create(string outputPath, List <string> headerList, string[][] valueTable, int initialRow) { return(SpreadsheetDocumentManager.Create(outputPath, headerList, valueTable, initialRow)); }
/// <summary> /// Creates a SpreadsheetDocument with a chart from a data table /// </summary> /// <param name="outputPath">Path of generated file</param> /// <param name="headerList">Header row contents</param> /// <param name="valueTable">Data values</param> /// <param name="chartType">Chart type</param> /// <param name="headerColumn">Column to use as category for charting</param> /// <param name="columnsToChart">Columns to include in chart</param> /// <param name="initialRow">Row index to start copying data</param> /// <returns>Spreadsheet document</returns> public static SpreadsheetDocument Create(string outputPath, List <string> headerList, string[][] valueTable, ChartType chartType, string headerColumn, List <string> columnsToChart, int initialRow) { return(SpreadsheetDocumentManager.Create(outputPath, headerList, valueTable, chartType, headerColumn, columnsToChart, initialRow)); }