Hi,
I am having an odd issue that is driving me crazy and I cant find anything in the documentation that can help explain what is happening.
We read in information from an email and dump it to a template excel file where the first row of the template contains the column labels. The bot then reads the excel file in its entirety to a table variable, sorts the data in the table variable and then dumps it out to a csv file using the Table write to file action.
Unfortunately on occasion we will get an email with hidden characters in it. This causes the Table write to file action to choke.
To get around this i decided to loop through the table instead and use the log to file command which worked great except for one thing. The column labels are not coming over. I tried everything i could think of. I even added a message box with something like $Table[0][0]$ . It did not display the column label. It displayed the value in the row below the column label.
