I have text file containing 20 columns,need the exact data to be pasted in excel sheet with header.
Initially used hotkeys ctrl+a ,ctrl+c from notepad and tried ctrl+v in excel ,but it pasted the entire value in one cell.
Then I tried using generate data table,few columns are coming in one cell again.
can anyone help on the same,its not a complex task,still i am stuck.
Attaching the input and expected output excel and my xaml file as well.Main.xaml (14.2 KB)