How to write or append bulk data in existing workbook?

@suraj_gaikwad ,

For this Error, it is understood and we have the below post which has the method to handle the error :