I’m trying to delete all the data in the sheet using the Excel.Delete.Range activity.
I know that the current situation can be realized by specifying “A1: XFD1048576” which is the maximum value of Excel in the property of range specification, but if possible, delete up to the maximum location where the value is included think. (like opening Excel directly and selecting all by “Ctrl + A”)
Of course, if only want to realize the process, there is no problem that open Excel directly and “Ctrl + A” → “del”, but please let me know if there is a smart method using the Excel.Delete.Range activity is.
My English Sentence may be hard to read, but I would be glad if you answered it.