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