private void btnCompileSelect_Click(object sender, EventArgs e)
{
//编译选定的表
Console.Clear();
var startPath = Environment.CurrentDirectory;
Console.WriteLine("当前目录：{0}", startPath);
var compiler = new Compiler();
int comileCount = 0;
foreach (var filePath in fileList)
{
Console.WriteLine(filePath);
var savePath = GenTmlPath + "\\" + SimpleExcelFile.GetOutFileName(filePath) + TmlExtensions;
//编译表时，生成代码
TableCompileResult compileResult = compiler.Compile(filePath, savePath);
Console.WriteLine("编译结果:{0}---->{1}", filePath, savePath);
Console.WriteLine();
//生成代码
BatchCompiler batchCompiler = new BatchCompiler();
//NOTE 替换成相对路径(保证最后只有文件名)
string repStr = Directory.GetParent(compileResult.TabFileRelativePath).FullName + "\\";
compileResult.TabFileRelativePath = compileResult.TabFileRelativePath.Replace(repStr, "");
batchCompiler.GenCodeFile(compileResult, DefaultTemplate.GenSingleClassCodeTemplate, GenCodePath, NameSpace, TmlExtensions, null, true);
if (compileResult != null)
{
comileCount += 1;
}
}
ShowCompileResult(comileCount);
}
public void TestModifyXls()
{
var file = new SimpleExcelFile("TestSettings/TestExcel.xls");
file.Save("TestSettings/TestExcelSave.xls");
Assert.True(File.Exists("TestSettings/TestExcelSave.xls"));
}
public void TestModifyXlsx()
{
var file = new SimpleExcelFile("TestSettings/TestExcel2.xlsx");
file.Save("TestSettings/TestExcel2Save.xlsx");
Assert.True(File.Exists("TestSettings/TestExcel2Save.xlsx"));
// File.Delete("TestSettings/TestExcel2Save.xlsx"); // TODO: Save NPOI xlsx cannot open
}
public void TestSimpleExcelFile()
{
var excelFile = new SimpleExcelFile("./test_excel.xlsx");
Assert.IsTrue(excelFile.ColName2Index.ContainsKey("Id"));
Assert.IsTrue(excelFile.ColName2Index.ContainsKey("Name"));
Assert.AreEqual(excelFile.ColName2Index["Name"], 1);
Assert.AreEqual(excelFile.HasColumn("Name"), true);
}
