/// <summary>
/// Create the specified splitFlag and ignores.
/// </summary>
/// <param name="splitFlag">If set to <c>true</c> split flag.</param>
/// <param name="ignores">Ignores.</param>
public void Create(bool splitFlag, string[] ignores = null)
{
this.splitFlag = splitFlag;
maker = new ExcelImportMaker (excelFilePath);
IWorkbook book = maker.FileStream ();
if (book == null) {
return;
}
listSheet = new List<ISheet> ();
for (int i = 0; i < book.NumberOfSheets; i++) {
ISheet sheet = book.GetSheetAt (i);
if (Array.IndexOf (ignores, sheet.SheetName) < 0) {
listSheet.Add (sheet);
}
}
if (listSheet.Count <= 0) {
return;
}
path = Path.Combine (dbPath, dbName);
query = new Query (path);
query.Sqlite.CreateFile (true);
stringBuilder = new StringBuilder ();
index = 0;
EditorUtil.StartCoroutine (CreateTable ());
}
/// <summary>
/// Create the specified extension.
/// </summary>
/// <param name="extension">Extension.</param>
public static void Create()
{
ExcelImportMaker maker = new ExcelImportMaker (excelFilePath, outputJsonPath);
string[] ignores = ignoreSheetName.Split (new string[] { ",", "|" }, System.StringSplitOptions.None);
if (selected == 0) {
maker.Create (JsonImportType.NORMAL, ignores);
} else {
maker.Create (JsonImportType.ATTRIBUTE, ignores);
}
PlayerPrefs.SetString (HELLGATE_EXCEL_PATH, excelFilePath);
PlayerPrefs.SetString (HELLGATE_EXCEL_IGNORE_SHEET, ignoreSheetName);
PlayerPrefs.SetString (HELLGATE_EXCEL_OUTPUT_PATH, outputJsonPath);
PlayerPrefs.SetInt (HELLGATE_EXCEl_TYPE_SELECTED, selected);
}
/// <summary>
/// Create the specified extension.
/// </summary>
/// <param name="extension">Extension.</param>
public static void Create()
{
ExcelImportMaker maker = new ExcelImportMaker(excelFilePath, outputJsonPath);
string[] ignores = ignoreSheetName.Split(new string[] { ",", "|" }, System.StringSplitOptions.None);
if (selected == 0)
{
maker.Create(JsonImportType.NORMAL, ignores);
}
else
{
maker.Create(JsonImportType.ATTRIBUTE, ignores);
}
PlayerPrefs.SetString(HELLGATE_EXCEL_PATH, excelFilePath);
PlayerPrefs.SetString(HELLGATE_EXCEL_IGNORE_SHEET, ignoreSheetName);
PlayerPrefs.SetString(HELLGATE_EXCEL_OUTPUT_PATH, outputJsonPath);
PlayerPrefs.SetInt(HELLGATE_EXCEl_TYPE_SELECTED, selected);
}
/// <summary>
/// Create the specified splitFlag and ignores.
/// </summary>
/// <param name="splitFlag">If set to <c>true</c> split flag.</param>
/// <param name="ignores">Ignores.</param>
public void Create(bool splitFlag, string[] ignores = null)
{
this.splitFlag = splitFlag;
maker = new ExcelImportMaker(excelFilePath);
IWorkbook book = maker.FileStream();
if (book == null)
{
return;
}
listSheet = new List <ISheet> ();
for (int i = 0; i < book.NumberOfSheets; i++)
{
ISheet sheet = book.GetSheetAt(i);
if (Array.IndexOf(ignores, sheet.SheetName) < 0)
{
listSheet.Add(sheet);
}
}
if (listSheet.Count <= 0)
{
return;
}
path = Path.Combine(dbPath, dbName);
query = new Query(path);
query.Sqlite.CreateFile(true);
stringBuilder = new StringBuilder();
index = 0;
EditorUtil.StartCoroutine(CreateTable());
}
