I’m reading one huge excel file (5000 records) using Excel application scope, I want to trim any whitesapces in the data to avoid datatype mismatch error. I searched a lot but couldn’t find any useful resources. Is there any way to trim the entire excel file while reading it??
Thanks in advance.