codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

Cannot map % character on Row Header to class property #76

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.  Create an excel file with with any header and data
2.  Use % on the Header like "Amount %"
3.  apply mapping  x.AddMapping<TrailerFeeModel>(c => c.Amount, "Amount %");

What is the expected output? What do you see instead?
   The value in the columne with a Header of "Amount %" will be mapped correctly, but the value is always null (not mapped)

What version of the product are you using? On what operating system?
1.6.3.0 > Windows XP

Please provide any additional information below.
I think an additional handler for special characters is required here

Original issue reported on code.google.com by Guer...@gmail.com on 17 Oct 2012 at 10:34

GoogleCodeExporter commented 8 years ago
The database engine probably maps the % character to another character.

You can find out the names of all the columns by using GetColumnNames() method 
(https://github.com/paulyoder/LinqToExcel#query-column-names)

Let me know if you have any more issues

Original comment by paulyo...@gmail.com on 10 Nov 2012 at 1:35

GoogleCodeExporter commented 8 years ago

Original comment by paulyo...@gmail.com on 10 Nov 2012 at 5:05