Jul 21, 2015 09:07 AM|Weibo Zhang|LINK
Interop components force to have Excel installed on the server in order to work, while ADODB don't.
Yes, you’re right. The Microsoft. Office. Interop. Excel is not the best way to operate excel files on the server. Besides, the Open XML SDK could also be a better solution as ADODB you suggested above. But just about this issue, Microsoft. Office. Interop.
Excel is also an option to achieve the goal. Thank you for your reminder.
I hope it’s useful to you.