public string parseFiles(string strDirectory, string[] fileNames) { // we only want the month and year from the file name string[] strName = fileNames[0].Split(' ').Where((x, index) => index != 2).ToArray(); string strWBName = string.Join("", strName) + ".xlsx"; XLWorkbook xlWB = new XLWorkbook(); for (int j = 0; j < fileNames.Length; j++) { string shtName = fileNames[j].Replace(".txt", ""); if (shtName.Length > 30) { clsUnZip objUnzip = new clsUnZip(); shtName = objUnzip.RenameFile(shtName); } IXLWorksheet xlSht = xlWB.Worksheets.Add(shtName); int iRow = 2; iRow = streamFile(ref iRow, strDirectory, fileNames[j], ref xlSht, "C"); addFormulas(xlSht, iRow, iRow + 2, "Debit"); addFormulas(xlSht, iRow, iRow + 3, "Credit"); addFormulas(xlSht, iRow, iRow + 5, "Grand Total"); formatSheet(xlSht, iRow + 5); } string strFile = strDirectory + "//" + strWBName; xlWB.SaveAs(strFile); return(strFile); }
private void UnzipFiles(string strPath) { string[] FileNames; string[] filePaths = Directory.GetFiles(strPath, "*.zip"); if (filePaths.Count() == 0) { MessageBox.Show("There were no zip files in the directory selected, please navigate to the appropriate directory"); } else { clsUnZip objUnZip = new clsUnZip(); FileNames = objUnZip.UnzipFiles(strPath, filePaths); if (FileNames.Length > 0) { strXL = parseFiles(strPath, FileNames); butExcel.Enabled = true; lblStatus.Text = ""; } else { MessageBox.Show("The files did not unzip properly. Try again, if the problem persists contact IT."); } } }