/// <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); }