internal Workbook(XlsDocument doc) { _doc = doc; _doc.Workbook = this; _worksheets = new Worksheets(_doc); _fonts = new Fonts(_doc); _formats = new Formats(_doc); _styles = new Styles(_doc); _xfs = new XFs(_doc, this); _palette = new Palette(this); }
public IXLWorksheet AddWorksheet(String sheetName, Int32 position) { return(Worksheets.Add(sheetName, position)); }
public IXLWorksheet AddWorksheet(String sheetName) { return(Worksheets.Add(sheetName)); }
public IXLWorksheet AddWorksheet(Int32 position) { return(Worksheets.Add(position)); }
public IXLWorksheet AddWorksheet() { return(Worksheets.Add()); }
private void GenerateExtendedFilePropertiesPartContent(ExtendedFilePropertiesPart extendedFilePropertiesPart) { if (extendedFilePropertiesPart.Properties == null) { extendedFilePropertiesPart.Properties = new DocumentFormat.OpenXml.ExtendedProperties.Properties(); } var properties = extendedFilePropertiesPart.Properties; if ( !properties.NamespaceDeclarations.Contains(new KeyValuePair <string, string>("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"))) { properties.AddNamespaceDeclaration("vt", "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"); } if (properties.Application == null) { properties.AppendChild(new Application { Text = "Microsoft Excel" }); } if (properties.DocumentSecurity == null) { properties.AppendChild(new DocumentSecurity { Text = "0" }); } if (properties.ScaleCrop == null) { properties.AppendChild(new ScaleCrop { Text = "false" }); } if (properties.HeadingPairs == null) { properties.HeadingPairs = new HeadingPairs(); } if (properties.TitlesOfParts == null) { properties.TitlesOfParts = new TitlesOfParts(); } properties.HeadingPairs.VTVector = new VTVector { BaseType = VectorBaseValues.Variant }; properties.TitlesOfParts.VTVector = new VTVector { BaseType = VectorBaseValues.Lpstr }; var vTVectorOne = properties.HeadingPairs.VTVector; var vTVectorTwo = properties.TitlesOfParts.VTVector; var modifiedWorksheets = Worksheets.Select(w => new { w.Name, Order = w.Position }).ToList(); var modifiedWorksheetsCount = modifiedWorksheets.Count; InsertOnVtVector(vTVectorOne, "Worksheets", 0, modifiedWorksheetsCount.ToString()); vTVectorTwo.Size = (UInt32)(modifiedWorksheetsCount); foreach (var vTlpstr3 in modifiedWorksheets.OrderBy(w => w.Order).Select(w => new VTLPSTR { Text = w.Name })) { vTVectorTwo.AppendChild(vTlpstr3); } }
protected override void CreateWorksheets(IEnumerable <BaseReportModel> baseReportModels) { Worksheets.Add(new ComparePdfWorksheet(baseReportModels.FirstOrDefault())); }
public IXLWorksheet AddWorksheet(DataTable dataTable, String sheetName) { return(Worksheets.Add(dataTable, sheetName)); }
public override bool DrawGUIList(EditorGUILayoutEx in_layout, bool in_showAll) { var ret = true; var spreadsheetVisibleString = "workbook" + WorkbookName.Replace(' ', '_') + "_Visible"; SpreadsheetVisible = Google2uGUIUtil.GetBool(spreadsheetVisibleString, SpreadsheetVisible); if ((SpreadsheetVisible == false) && !in_showAll) { return(true); } ShowSpreadsheet = Google2uGUIUtil.GetBool("workbook" + WorkbookName.Replace(' ', '_') + "_Open", ShowSpreadsheet); var mainFadeArea = in_layout.BeginFadeArea(ShowSpreadsheet, WorkbookName, "workbook" + WorkbookName.Replace(' ', '_'), in_layout.OuterBox, in_layout.OuterBoxHeader, spreadsheetVisibleString); ShowSpreadsheet = mainFadeArea.Open; Google2uGUIUtil.SetBool("workbook" + WorkbookName.Replace(' ', '_') + "_Open", ShowSpreadsheet); // We have to do this here. Otherwise there is a threading issue (Can't initialize from EditorPreferences outside the main thread) if (ExportOptions == null) { ExportOptions = new Google2uExportOptions("workbook" + WorkbookName.Replace(' ', '_') + "_Option_"); } if (mainFadeArea.Show()) { var showExport = false; var exportsheets = new List <Google2uWorksheet>(); switch (WorksheetQueryStatus) { case QueryStatus.Idle: { WorksheetQueryStatus = QueryStatus.Uninitialized; } break; case QueryStatus.Querying: EditorGUILayout.LabelField( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_MESSAGE_QUERYING_WORKSHEETS) + Google2u.Ellipses); break; case QueryStatus.QueryComplete: if (WorksheetsDisplay.Length > 0) { foreach (var google2UWorksheet in WorksheetsDisplay) { if (google2UWorksheet.DrawGUIList(in_layout)) { exportsheets.Add(google2UWorksheet); showExport = true; } } if (_OpenInvalidSheet) { var stillQuerying = false; for (var i = 0; i < Worksheets.Count; ++i) { if (!exportsheets.Contains(Worksheets[i])) { continue; } if (Worksheets[i].UpdateValidation || Worksheets[i].Validating) { stillQuerying = true; } if (Worksheets[i].IsDataValid == false) { var ed = EditorWindow.GetWindow <Google2uEditor>(); Google2u.ActiveWorkbookWindow = ed; ed.Workbook = this; ed.Layout = in_layout; #if (UNITY_4) ed.title = WorkbookName; #elif (UNITY_5_0) ed.title = WorkbookName; #else ed.titleContent.text = WorkbookName; #endif ed.wantsMouseMove = true; ActiveWorksheetIndex = i; Worksheets[i].HighlightFirstInvalidCell(); _OpenInvalidSheet = false; break; } } if (!stillQuerying) { _OpenInvalidSheet = false; } } EditorGUILayout.BeginHorizontal(); var content = new GUIContent(in_layout.RefreshButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_REFRESH_WORKBOOK)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { Worksheets.Clear(); WorksheetQueryStatus = QueryStatus.Uninitialized; } var querying = false; var bAllWorksheetsValid = true; foreach (var google2UWorksheet in exportsheets) { if (google2UWorksheet.IsDataValid == false) { bAllWorksheetsValid = false; } if (google2UWorksheet.WorksheetQueryStatus != QueryStatus.Idle) { querying = true; } } { var guiEnabled = GUI.enabled; if (querying) { GUI.enabled = false; } content = bAllWorksheetsValid ? new GUIContent(in_layout.ValidateButtonGreen, Google2u.LocalizationInfo.Localize( Localization.rowIds.ID_LABEL_VALIDATE_WORKBOOK)) : new GUIContent(in_layout.ValidateButtonRed, Google2u.LocalizationInfo.Localize( Localization.rowIds.ID_LABEL_VALIDATE_WORKBOOK)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { // Do Validation for the worksheets we will be exporting foreach (var google2UWorksheet in exportsheets) { google2UWorksheet.UpdateValidation = true; google2UWorksheet.Validating = true; } _OpenInvalidSheet = true; } GUI.enabled = guiEnabled; } content = new GUIContent(in_layout.EditButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_EDIT_WORKBOOK)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { var ed = EditorWindow.GetWindow <Google2uEditor>(); Google2u.ActiveWorkbookWindow = ed; ed.Workbook = this; ed.Layout = in_layout; #if (UNITY_4) ed.title = WorkbookName; #elif (UNITY_5_0) ed.title = WorkbookName; #else ed.titleContent.text = WorkbookName; #endif ed.wantsMouseMove = true; } GUILayout.FlexibleSpace(); if (showExport) { var oldEnabled = GUI.enabled; if (bAllWorksheetsValid == false) { GUI.enabled = false; } content = new GUIContent(in_layout.SaveButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_EXPORT)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { DoExport(exportsheets); } GUI.enabled = oldEnabled; } EditorGUILayout.EndHorizontal(); } else { EditorGUILayout.LabelField( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_MESSAGE_NO_WORKSHEETS)); } break; } } in_layout.EndFadeArea(); return(ret); }
public XMLWorksheetsModel(XMLWorkbookModel workbook, PartManager manager) { this.Workbook = workbook; this.Manager = manager; this._interface = new Worksheets(this); }
public void Dispose() { Worksheets.ForEach(w => w.Dispose()); }
public IEnumerable <string> GetAllSheetNames() { return(Worksheets.Select(i => i.Name)); }
public IWorksheet GetSheetByName(string name) { return(Worksheets.FirstOrDefault(i => i.Name == name)); }
public IXLWorksheet AddWorksheet(DataTable dataTable) { return(Worksheets.Add(dataTable)); }
public override void DrawGUIFull(EditorGUILayoutEx in_layout) { switch (WorksheetQueryStatus) { case QueryStatus.Idle: { WorksheetQueryStatus = QueryStatus.Uninitialized; } break; case QueryStatus.Querying: EditorGUILayout.LabelField( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_MESSAGE_QUERYING_WORKSHEETS) + Google2u.Ellipses); break; case QueryStatus.QueryComplete: if (WorksheetsDisplay.Length > 0) { EditorGUILayout.BeginHorizontal(); var worksheetNames = new string[WorksheetsDisplay.Length]; for (var i = 0; i < WorksheetsDisplay.Length; ++i) { worksheetNames[i] = WorksheetsDisplay[i].WorksheetName; } var activeWorksheet = WorksheetsDisplay[ActiveWorksheetIndex]; if (activeWorksheet == null) { throw new ArgumentNullException("ActiveWorksheet"); } var content = new GUIContent(in_layout.RefreshButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_REFRESH_WORKBOOK)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { Worksheets.Clear(); WorksheetQueryStatus = QueryStatus.Uninitialized; } { var guiEnabled = GUI.enabled; if (activeWorksheet.WorksheetQueryStatus != QueryStatus.Idle) { GUI.enabled = false; } content = activeWorksheet.IsDataValid ? new GUIContent(in_layout.ValidateButtonGreen, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_VALIDATE_WORKSHEET)) : new GUIContent(in_layout.ValidateButtonRed, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_VALIDATE_WORKSHEET)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { // Do Validation for the active worksheet activeWorksheet.UpdateValidation = true; _OpenInvalidSheet = true; } GUI.enabled = guiEnabled; } content = new GUIContent(in_layout.GoogleButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_OPEN_IN_GOOGLE)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { Application.OpenURL(WorkbookUrl); } GUILayout.FlexibleSpace(); var oldEnabled = GUI.enabled; if ((activeWorksheet.WorksheetExportType == ExportType.DoNotExport) || activeWorksheet.IsDataValid == false) { GUI.enabled = false; } content = new GUIContent(in_layout.SaveButton, Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_EXPORT)); if (GUILayout.Button(content, GUILayout.Height(EditorGUILayoutEx.ButtonHeight), GUILayout.Width(EditorGUILayoutEx.ButtonWidth))) { DoExport(new List <Google2uWorksheet> { activeWorksheet }); } GUI.enabled = oldEnabled; EditorGUILayout.EndHorizontal(); var newActiveWorksheetIndex = EditorGUILayout.Popup( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_ACTIVE_WORKSHEET) + ": ", ActiveWorksheetIndex, worksheetNames); if (newActiveWorksheetIndex != ActiveWorksheetIndex) { WorksheetsDisplay[ActiveWorksheetIndex].ActiveCell = null; ActiveWorksheetIndex = newActiveWorksheetIndex; } var newExportType = (ExportType) EditorGUILayout.EnumPopup( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_LABEL_EXPORT_AS) + ": ", activeWorksheet.WorksheetExportType); if (newExportType != activeWorksheet.WorksheetExportType) { activeWorksheet.WorksheetExportType = Google2uGUIUtil.SetEnum(activeWorksheet.Prefix + "ExportType", newExportType); } DrawSpreadsheetOptions(in_layout, activeWorksheet.WorksheetExportType, activeWorksheet); EditorGUILayout.Separator(); activeWorksheet.DrawGUIFull(in_layout); } else { EditorGUILayout.LabelField( Google2u.LocalizationInfo.Localize(Localization.rowIds.ID_MESSAGE_NO_WORKSHEETS)); } break; } }
public void AddWorksheet(DataSet dataSet) { Worksheets.Add(dataSet); }
public Boolean TryGetWorksheet(String name, out IXLWorksheet worksheet) { return(Worksheets.TryGetWorksheet(name, out worksheet)); }
/// <summary> /// Force recalculation of all cell formulas. /// </summary> public void RecalculateAllFormulas() { InvalidateFormulas(); Worksheets.ForEach(sheet => sheet.RecalculateAllFormulas()); }
public void Dispose() { Worksheets.ForEach(w => (w as XLWorksheet).Cleanup()); }
protected AbstractWorkbook AddWorksheet <T>() where T : AbstractWorksheet, new() { Worksheets.Add(new T()); return(this); }
// Used by Janitor.Fody private void DisposeManaged() { Worksheets.ForEach(w => (w as XLWorksheet).Cleanup()); }