Error 0x8002000A (DISP_E_OVERFLOW) on Excel read range

Sry for didn’t reply for quite some time. this is due to excel sometime will try to convert a number e.g. 20190019020 to date format, and if failed it will display as xxxxxxxxx(infinited long), and read range will encounter error when read this. After that I changed whole excel format to text the issue was resolved

6 Likes