Can someone tell me what I am doing wrong here. This is the AnyTellerDemo application trying to pull the cashin and notonuscheck from Excel to AnyTeller Application.
Is the option “IncludeColumnNames” checked in Read CSV activity?
Yes it was defaulted to it.
@Sohaib786, Confirm these things once,
- Check your CSV Column Names containing any space(s) ?
- Are you reading the correct sheet where your column is present ?
- Any spelling mistakes while accessing your column name ?
Note: If not, sharing your excel/xaml/screenshot would be helpful.
How to handle this exception
@Sohaib786, can you print and check the datatable by using Output Data table Activity and display it to a message box/write Line ? Share the result if possible !
Note : Possibly uncheck the IncludeColumnNames Property and try with index of the column name
@Dominic I have used Message Box and it is empty. In my message box I had put
dt.ToString Please see below:
@Sohaib786, you haven’t assigned any output variable in output data table activity
Hello, I have the same problem as Sohaib786, that ’ Column ‘CashIn’ does not belong to table.
@Sohaib786, did you find a solution?
Hello. Try to change Delimiter from Comma to Semicolon in Read CSV activity.
Hi, did you find a solution for column names that have space in it? Thanks!
i had the same problem, and i resolved it by changing the delimitator from comma to Semicolon.