Forum Discussion
gehrig44
14 years agoOccasional Contributor
Sorry about the repost, but I dont see any edit buttons.
My main issue now is I can't figure out what value is being used on blank Excel cells. I setup an If/Then like above. I tried making the Data Table value equal an empty string, Null, and null but those didn't work. The only thing that works is if I create another Excel spreadsheet with blank cells in it and compare a blank cell in that table to my other Data Table.
I printed the value of the empty cell to my log file, and it is indeed bank. Any ideas what the value of a blank cell would be?
Thanks
My main issue now is I can't figure out what value is being used on blank Excel cells. I setup an If/Then like above. I tried making the Data Table value equal an empty string, Null, and null but those didn't work. The only thing that works is if I create another Excel spreadsheet with blank cells in it and compare a blank cell in that table to my other Data Table.
I printed the value of the empty cell to my log file, and it is indeed bank. Any ideas what the value of a blank cell would be?
Thanks
Related Content
- 3 years ago
- 5 years ago
- 14 years ago
Recent Discussions
- 13 hours ago
- 2 days ago