There is an easy way by creating xml file, this is an example to create 100k rows and excel will open it with no problem. Maybe a warning message. Attached in the zip is a txt file, copy the contents to the click event in a button and you will see it running.