public void Close()
{
File = "";
Worksheets.Clear();
_workbook?.Close();
_sheet = null;
}
public void Open(string filepath)
{
if (string.IsNullOrEmpty(filepath))
{
return;
}
Close();
Microsoft.Office.Interop.Excel.Application app;
try
{
var filename = Path.GetFileName(filepath);
app = (Microsoft.Office.Interop.Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");
_workbook = app.Workbooks.Item[filename];
File = filepath;
}
catch (Exception ex)
{
try
{
//Start Excel and get Application object.
app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = true;
var workbooks = app.Workbooks;
_workbook = app.Workbooks.Open(filepath);
app.UserControl = true;
File = filepath;
}
catch (Exception)
{
_workbook = null;
}
}
Worksheets.Clear();
if (_workbook != null)
{
var enumerator = _workbook?.Worksheets.GetEnumerator();
while (enumerator.MoveNext())
{
var sheet = (Microsoft.Office.Interop.Excel.Worksheet)enumerator.Current;
Worksheets.Add(sheet.Name);
}
}
}
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 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);
}