In my excel file my column is a general format.
I have various values in this column , ie:
Field |
0 |
FY21DP |
FY22DP |
FY20DP |
Y |
FYDP22 |
FY 22DP |
FY22DP (Y) |
Yes |
why is this being read in as a double? Can I read it in as a string without doing anything to the excel workbook?
@DQAUDIT I dont have access to alter the excel file itself, but i will keep that in mind if that changes.