If i hard code the table name using custom value then the below error is seen
No table was found with the name 'Semister'.
clientRequestId: 5cd7ac3d-a019-43bd-a05e-789ee960d573
serviceRequestId: 6bdd7514-82e3-4e04-8d81-052b15e53abb
If i refer the excel using SharePoint Get File Properties then the below error is seen
Action 'Process_Tables' failed -- Get tables is not displaying any table info even if the excel files contains tables
Can anyone provide solution for this issue.
I cannot share this file out from my official account as part of security reasons
That's the wrong (local) end of the OneDrive stick. And you probably don't want to use your work account for this anyway
do let me know whether you can download this file
You can use one of the file services like OneDrive or Google Drive.
Do let me know how to attach a table in this post i am not able to find one over here. Kindly assist
Can you provide a sample Excel file for testing?
Yes , as you rightly stated need to access tables that will present in the excel file but the excel files along with table will be created dynamically on a given period and once it is read this excel needs to be deleted .
Can you confirm that you want to access tables that you have previously defined in the Excel file? Or are you trying to access ranges? or sheets?