Hi Team,
I'm trying to get data from Excel file which gets data from SharePoint and already connections are saved in Excel. I've set connects in excel to refresh Data when excel is opened.
My question is when I connect to excel with OleDbConnection and open connection, Do Data in excel will get refreshed?
Regards,
Harish
Hi Harish,
Just so I understand what you are saying, you are connecting to an Excel file via and OleDbConnection. That Excel file in turn connects to SharePoint. Which if you open the Excel file in Excel it auto refreshes the data, either through settings or a VBScript. But when you read the file via an OleDbConnection it does not refresh the data. Which I would assume should be the case because you are just attaching to the raw data file. you would need to open the file with either Excel or an Excel engine of some sort. I found this thread on Microsoft's site:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/8bce17fb-eacd-4df3-8c10-bf8ae8a93c55/c-code-to-refresh-excel-data?forum=csharpgeneral
But this is mostly out of my depth, I would recommend pinging https://social.msdn.microsoft.com/Forums/vstudio/ or http://stackoverflow.com/
Hope that helps,
Hi Michael, One more question about getting data from SharePoint List.
Is there any way using Infragistics libraries I can get sharepoint list to Datatable which will be fast and reliable by just passing sharepoint link and list name?
I'm using Infragistics 13.2 licensed version.
Hi Harish, There is nothing specific in our assemblies that does but there is in the base SharePoint assemblies. https://msdn.microsoft.com/en-us/library/Microsoft.SharePoint.SPList.aspx
Let me know if that helps,