How to Import excel if it is stored in sharepoint
We recently moved from shared network drive to sharepoint portal. All of our test data sheet move to sharepoint. I am not really sure how to import data from sharepoint. I was trying to use following command but seems it is not the solution.
<font class="small">Code:</font><hr /><pre>
I am getting following error
The DataTable.Import (file) operation failed. http://XYZportal/AB/QA/Documents/test.xls is not a valid file name.
Is there anyone has solution ?
Re: How to Import excel if it is stored in sharepo
There are different ways you can do it. One is to open the link in IE and download the file and then use it.
2nd is to use API to download the file to