What steps will reproduce the problem?
This is not an issue but just felt that it could be more helpful to manipulate
data if we have an option to trim the leading/trailing whitespaces at one go
instead of doing it for each and every cell individually.
var Users = from user in excelQueryFactory.Worksheet("Users")
select user;
foreach (var user in Users)
{
User.FirstName = user["FirstName"].ToString().Trim();
User.MiddleName = user["MiddleName"].ToString().Trim();
User.LastName = user["Lastname"].ToString().Trim();
User.EmailId = user[EmailId].ToString().Trim();
}
This is painful to convert it to string and then trimming for each and every
cell value.
What is the expected output? What do you see instead?
The expected output is some sort of method to trim the entire data in the excel
or sheet
What version of the product are you using? On what operating system?
LinqToExcel_x64
Windows7 Professional
Please provide any additional information below.
NA
Original issue reported on code.google.com by sathya28...@gmail.com on 29 Nov 2013 at 7:02
Original issue reported on code.google.com by
sathya28...@gmail.com
on 29 Nov 2013 at 7:02