How to read non fixed excel column and their values and print in notepad


#1

Hi Team,
I have one requirement where i need to read excel file and print excel data into notepad.
In notepad i have to add metadata keyword with the header and same keyword with the rows .
But issue is the excel coulmns are not fixed they can change and may increase column count.
Please help me to fulfill this requirement.


#2

Hi tanuj_saini,

1.Read Excel using read range activity and it will give datatable
2. UI Path output data table then you will get the data table details to string
3. Write the string value to notepad using write text file activity

Now the notepad contains all details present in the excel sheet.

regards,
Sarath.


#3

Hi Sarathkadan,

Could you please share your email id so that i can share the exact requirement with you now customer changed his requirement and it become more complex