private List <Column> GetData() { List <List <Column> > tempLists = new List <List <Column> >(); List <Column> data = new List <Column>(); DirectoryInfo d = new DirectoryInfo(Utils.CURRENT_PATH); FileInfo[] Files = d.GetFiles("*.xlsx"); List <string> excelNames = new List <string>(); foreach (FileInfo file in Files) { if (file.Name.IndexOf("~$") == -1) { excelNames.Add(file.Name); } } foreach (string excelName in excelNames) { string filePath = Utils.CURRENT_PATH; string strRandom = Utils.RandomString(9); string copyFilePath = $@"{filePath}\temp\{strRandom}{excelName}"; string tempFolder = $@"{filePath}\temp"; Utils.CreateFolder(tempFolder); filePath = filePath + '\\' + excelName; File.Copy(filePath, copyFilePath); tempLists.Add(ExcelUtil.GetData(copyFilePath, excelName)); } foreach (List <Column> list in tempLists) { foreach (Column item in list) { data.Add(item); } } return(data); }
private List <Column> GetData(string originExcelFile) { List <List <Column> > tempLists = new List <List <Column> >(); List <Column> data = new List <Column>(); string filePath = Utils.CURRENT_PATH; string strRandom = Utils.RandomString(9); string copyFilePath = $@"{filePath}\temp\{strRandom}{originExcelFile}"; string tempFolder = $@"{filePath}\temp"; Utils.CreateFolder(tempFolder); filePath = filePath + '\\' + originExcelFile; File.Copy(filePath, copyFilePath); tempLists.Add(ExcelUtil.GetData(copyFilePath, originExcelFile)); foreach (List <Column> list in tempLists) { foreach (Column item in list) { data.Add(item); } } return(data); }