static void WriteXls()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
// string outputPath = Application.dataPath + "/Test/Test2.xlsx";
string outputPath = ExcelEditor.DocsPath + "/Test.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, "字段1");
xls.Tables[0].SetValue(1, 2, "字段2");
xls.Tables[0].SetValue(1, 3, "字段3");
for (int i = 2; i <= 11; i++)
{
for (int j = 1; j <= 3; j++)
{
xls.Tables[0].SetValue(i, j, Random.Range(1000, 100000).ToString());
}
}
xls.ShowLog();
ExcelTable table2 = new ExcelTable();
table2.TableName = "标签2";
xls.Tables.Add(table2);
xls.Tables[1].SetValue(1, 1, Random.Range(1000, 100000).ToString());
xls.Tables[1].SetValue(1, 2, "测试");
xls.Tables[1].SetValue(1, 3, "我勒个去我勒个去我勒个去我勒个去");
xls.Tables[1].SetValue(4, 3, "我在这里");
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
static void LoadXls()
{
string path = System.IO.Path.Combine(Application.streamingAssetsPath, "Test2.xlsx");
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
}
static void Read5()
{
string path = Application.dataPath + "/VavilichevGD/Tools/XLSReader//Example/Test5.xlsx";
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
}
static void LoadXls()
{
string path = Application.dataPath + "/Test/Test3.xlsx";
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
}
static void LoadXls()
{
// string path = Application.dataPath + "/Test/Test4.xlsx";
string path = ExcelEditor.DocsPath + "/数值平衡.xlsx";
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
Debug.Log(xls.Tables[0].TableName);
}
static void WriteXls()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = Application.dataPath + "/Test/Test2.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, Random.Range(1000,100000).ToString());
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
// Use this for initialization
void Start()
{
string excelPath = Application.dataPath + "/Test/Test.xlsx";
string outputPath = Application.dataPath + "/Test/Test2.xlsx";
Excel xls = ExcelHelper.LoadExcel(excelPath);
xls.ShowLog();
xls.Tables[0].SetValue(1, 1, "???");
ExcelHelper.SaveExcel(xls, outputPath);
}
static void WriteXls()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = Application.dataPath + "/Test/Test2.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, Random.Range(1000, 100000).ToString());
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
static void ShowWindow()
{
ExcelEditor window = EditorWindow.GetWindowWithRect <ExcelEditor>(new Rect(0, 0, 800, 400));
window.Show();
string path = System.IO.Path.Combine(Application.streamingAssetsPath, "Test3.xlsx");
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
window.Show(xls);
}
static void ShowWindow()
{
ExcelEditor window = EditorWindow.GetWindowWithRect <ExcelEditor>(new Rect(0, 0, 800, 400));
window.Show();
string path = Application.dataPath + "/Test/Test3.xlsx";
Excel xls = ExcelHelper.LoadExcel(path);
xls.ShowLog();
window.Show(xls);
}
static void WriteXls()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = System.IO.Path.Combine(Application.streamingAssetsPath, "Test2.xlsx");
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, Random.Range(1000, 100000).ToString());
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
static void test()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = Application.dataPath + "/Test/Test2.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, "1");
xls.Tables[0].SetValue(1, 2, "2");
xls.Tables[0].SetValue(2, 1, "3");
xls.Tables[0].SetValue(2, 2, "4");
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
static void test()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = ExcelEditor.DocsPath + "/Test2.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, "1");
xls.Tables[0].SetValue(1, 2, "2");
xls.Tables[0].SetValue(2, 1, "3");
xls.Tables[0].SetValue(2, 2, "4");
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
static void ReadWrite()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = Application.dataPath + "/VavilichevGD/Tools/XLSReader/Example/Test2.xlsx";
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, "1");
xls.Tables[0].SetValue(1, 2, "2");
xls.Tables[0].SetValue(2, 1, "3");
xls.Tables[0].SetValue(2, 2, "4");
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
// Use this for initialization
void Start()
{
string excelInPutFileName = "Test.xlsx";
string excelOutPutFileName = "Test2.xlsx";
string excelInPutFilePath = System.IO.Path.Combine(Application.streamingAssetsPath, excelInPutFileName);
string excelOutPutFilePath = System.IO.Path.Combine(Application.streamingAssetsPath, excelOutPutFileName);
Excel xls = ExcelHelper.LoadExcel(excelInPutFilePath);
xls.ShowLog();
print(xls.Tables.Count);
xls.Tables[0].SetValue(1, 1, "???");
ExcelHelper.SaveExcel(xls, excelOutPutFilePath);
outputText.text = "Save Success.";
}
static void test()
{
Excel xls = new Excel();
ExcelTable table = new ExcelTable();
table.TableName = "test";
string outputPath = System.IO.Path.Combine(Application.streamingAssetsPath, "Test2.xlsx");
xls.Tables.Add(table);
xls.Tables[0].SetValue(1, 1, "1");
xls.Tables[0].SetValue(1, 2, "2");
xls.Tables[0].SetValue(2, 1, "3");
xls.Tables[0].SetValue(2, 2, "4");
xls.ShowLog();
ExcelHelper.SaveExcel(xls, outputPath);
}
