public static bool processHandleData(String[] filePaths) { foreach (String filepath in filePaths) { string htmlCode = ""; int index = 0; String searchResult = ""; DataTable metadata_table = new DataTable(); ReadExcel readExcel = new ReadExcel(); // metadata_table = readExcel.ReadExcelFile(@"C:\Users\ponnaga\source\repos\shareOkForms\shareOkForms\rm_check_262.xlsx", "xlsx"); metadata_table = readExcel.ReadExcelFile(filepath, "xlsx"); //creating column names foreach (DataColumn column in metadata_table.Columns) { string cName = metadata_table.Rows[0][column.ColumnName].ToString(); if (!metadata_table.Columns.Contains(cName) && cName != "") { column.ColumnName = cName; } } metadata_table.Rows[0].Delete(); metadata_table.Columns.Add("isFileValid", typeof(String)); //removing unwanted columns DataView view = new DataView(metadata_table); DataTable filtered_metadata_table = view.ToTable(false, "id", "collection", "dc.contributor.author", "dc.identifier.uri", "dc.title", "osu.filename", "isFileValid"); foreach (DataRow row in filtered_metadata_table.Rows) { try { htmlCode = Form1.client.DownloadString(row["dc.identifier.uri"].ToString()); searchResult = htmlCode.IndexOf(row["osu.filename"].ToString()) == -1 ? "No" : "Yes"; } catch { searchResult = "No"; } finally { row["isFileValid"] = searchResult; //row["Status"] = constructed_uri=constructFileURL.ConstructURL(row["dc.identifier.uri"].ToString(),row["osu.filename"].ToString()); index++; // label1.Text = "Procesing record " + index + " of " + filtered_metadata_table.Rows.Count; // label1.Refresh(); } } //binding it to the dataview // dataGridView1.Visible = true; // dataGridView1.DataSource = filtered_metadata_table; //some helper variables int LastIndex = filepath.LastIndexOf('\\'); int PathLength = filepath.Length; int LastIndexFileExtension = filepath.LastIndexOf('.'); String Path_without_fileName = filepath.Substring(0, LastIndex); //String fileName = openFileDialog1.FileName.Substring(LastIndex, PathLength - LastIndex-1); String fileName_without_extension = filepath.Substring(LastIndex, LastIndexFileExtension - LastIndex); //writing output to excel WriteToExcel writeToExcel = new WriteToExcel(); writeToExcel.writeExcel(filtered_metadata_table, fileName_without_extension + "_output.xlsx", Path_without_fileName + "\\output"); } return(true); }