I have an Excel file where the header is comming with wrap text
I am reading this excel file using oledb connection string and string it in datatable.
Is there a way to first unwrap the header text and read the excel file using oledb connection?
I have an Excel file where the header is comming with wrap text
I am reading this excel file using oledb connection string and string it in datatable.
Is there a way to first unwrap the header text and read the excel file using oledb connection?
Hi @Pinky_AG
Use Format Cells & remove the check box for wrap text. If it is already wrapped it will remove the wrapping
After doing this you can use the oledb connection string
Other way
Ref-https://forum.uipath.com/t/how-to-unwrap-text-in-whole-column/315505
Hope this helps
The first activity which you are using to unwrap, i am not getting that in my studio…where i can see this? And does it has any limitations?
Hi @Pinky_AG
This is the modern activity. There is no limitation.
You can turn on the modern experience in UiPath
& You can find this activity in Excel activities. You may need to update your Excel package.
Hope this helps