I have to read data from excel and put in datatable … and perform concatenation of all rows using linq query … First two rows are integers and getting added instead of concatenation. How can I convert it into string ?
- First step → Reading data from excel and storing in data table
- Second step → Using linq query to concat all the values in a row and put in final row
- Third step → Write concated data in excel
→ Expected o/p for concatenation
999100SAKOCred.of the entrepr.Creditors of the enterprise, 3rd party securities
→ Actual o/p for concatenation
1099SAKOCred.of the entrepr.Creditors of the enterprise, 3rd party securities
→ Attached input file and xaml file
Linq.xaml (10.1 KB)
Can someone please help me in resolving this ?
I have to perform only using linq query bcoz I have huge data