We have Windows Server 2018 R2 with 64 bit architecture and the Office installed on the same architecture is Office 2013 32 bit version. I have an Asp.Net application hosted on the server which takes and Excel file and parse it and accordingly. Now, the server is creating problems to create a new Excel Application object. Please give me a work around.
Get a library to do your office work.
Office Interop does not work - you could install Office 64 bit to work around, BUT....
...Office is EXPLICITLY not supported on server environments like that. Period. RTFM style period - no support, may stop overnight. Everyone else works around this by using either office server or more likely to use a thiurd party library to do the excel manipulation.