Hello, any help would be greatly appreciated. I am running a process that reads a range from a csv, then writes that range to an xlsx inside and excel application scope. I add some columns and formulas and read the range again, filter it, and write that range to a new tab in the same workbook. From there I filter the data again based on a new formula and read the range again. This is where the process is failing due to the format of the data I just wrote from the first xlsx tab.
When Initial wrote from the csv the data looks like this:
Then after reading this range and filtering, it gets written like this:
This format and the infinite #### signs that are in the cell no matter how wide I expand it are causing a read range error.
Read Range: Could not read range A1:H20.
I have tried both excel application scope and workbook activities and I have tried with both preserve formatting checked and unchecked and I can’t seem to get this to work.