Text file & Excel file

[ankit.dutt]

My task is to

1. Read the Input Excel File provide by the User.
2. Read the Input Text File.
3. Based on the Keyword Provided in the Input File, search In the Text File provided and split it.
4. Create an excel file where file name will be the Keyword and make the Sheet as Keyword_1, Keyword_2 based on the results you will get after splitting.
5. For each Input Keyword there must be a different Excel File.
6. If the Keyword does not exist In the text file, it should give proper Message as the Keyword is not present instead of giving Exception.
   please guide me regarding this

[Anil_G (Anil Gorthi)]

@ankit.dutt

I have a project how we can do that anybody help please,

@Kailash_Singh read range activity read text file and store ins tr for each row in datatable inside loop use if condtion to first check if word is present str.contains(currentrow("ColumNname").ToString) on then side you can split string and write to datatable usign assign on else side do nothing write string not found cheers

cheers