When using "Write Cell" in excel application scope, it auto-saves every move


#1

Dear all,

I am processing a large amount of data in excel (about 0.3million rows). First, I use “excel application scope” to open the excel. When I use “Write Cell” to change the cell information. The excel auto-saved with every move (each time I use “Write Cell”). It causes inefficiency in data processing. I want to know why it causes auto-saving everytime? and is there any better solution? Thanks a lot!

Best Regards,


#2

Works as designed.
You could use WriteRange to modify in bulk.

Having control of saving is requested: