We have a requirement to read excel files (xlsx, xls and csv) from SharePoint into the memory by using C# code and perform some operations.
To achieve this requirement, we have used "Microsoft.Office.Interop.Excel" assembly and written below code that we have found doing google.
Here, I am not sure whether this code is working or not, because after executing this code, I have been asked to enter user name and password into the new window. After providing a username and password, an error is occurring in user name and password screen. Please see below screen
There are two questions I have.
1. How do I provide username and password in a code itself, so that this will not prompt to enter?
2. Why is this type of error coming when I enter a username and password?
Any help would be much appreciated.
OR any one also suggests if I can use any other way to read excel files directly from SharePoint.