Posts

Showing posts from February, 2020
Modifying Doc and Xls files If you want to edit Word or Excel files programatically, you need to install Microsoft Office products (Word or Excel) in the machine and then use C# COM InterOp reference library to do so through your programs. The problem with COM InterOp library is that it needs Word or Excel application to be installed in the machine where this program will run which is going to modify the Doc or Excel sheets. This is so because COM InterOp actually executes the Word or Excel application to modify the document or excel sheet. One more downside is that you can handle only one document at a time through your application even if you execute multiple instances of your application. The whole process gets stuck if one document gets stuck due to any problem or the Word or Excel instance remains in memory from the previous work. The whole process is a very slow one. Moreover Microsoft does not recommend to do so in any server. Open XML also lets you play with the content of...