No, I didn't test with millions of Excel rows as my Excel files only contained 10-200 rows.

I already had the SSIS package loading Excel files to tables via data flow tasks components and doing many other tasks, but each time the users changed the Excel layout...