I just (yet again) ran into this Excel 'feature' and it managed to irritate me just as much as it always has.
This time, however, I tried a different solution: I added calculated columns to the right of the main data that forced the datatypes of the data to the left.
So - if column A contains a 1, but might also contain non-numeric data, add a calculated column to force it to be read as text and use that in your import (=Text(An,0)).
Note - this worked within a VBScript import of Excel data. Not tried it in SSIS, but should work ...
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.