public ExcelTableLoader(ExcelContext excelContext, string path, string filename)
{
_filepath = path;
_filename = filename;
_excelContext = excelContext;
_excelDataTable = new ExcelDataTable(_filepath, _filename.Remove(_filename.LastIndexOf(".")));
}
/// <summary>
/// 设置excel路径。
/// </summary>
/// <param name="directory"></param>
private void SetExcelDataDirectory(string directory)
{
if (!Directory.Exists(directory))
{
return;
}
ExcelPathText.Text = directory;
TableCheckBoxList.Items.Clear();
_excelContext.ExcelDataDirectory = directory;
_iniFile.IniWriteValue(IniSectionName, IniNameOfExcelDataDirectory, directory);
string filterWord = ExcelFilterTextBox.Text;
List <FileInfo> fileInfos = ExcelContext.FilterFile(directory, ExcelContext.ExcelSuffix);
foreach (var fileInfo in fileInfos)
{
if (filterWord.Equals(""))
{
TableCheckBoxList.Items.Add(fileInfo);
}
else if (fileInfo.Name.Contains(filterWord))
{
TableCheckBoxList.Items.Add(fileInfo);
}
}
}
public ExcelDataTableCheck(ExcelContext excelContext, ExcelDataTable excelDataTable)
{
_excelContext = excelContext;
_excelDataTable = excelDataTable;
}