It’s a summary file that it has over 100 columns and the last row are the information of SUM value of each column.
I used for each to get rid of the empty columns that some of them are not amount, but other content.
And the last thing I’m doing at the present is just one cell that I need to change a value of cell “Total” to the “Date” the file released.
The cell of “Total” is in the Column Index 0. Even I tries to assign it directly “TestDT.Rows(TestDT.Rows.Count - 1).ItemArray(0) = 20190910”, it still shows me “Total”.
I tried to use “For each Row” instead of “For each” which makes me feel weird and wrong. But it could change the value when I assign it.
But still don’t understand why the “for each row” can achieve it, but “for each” can’t.
I want to know the reason or probably what detail i didn’t notice.