Hi,
I have an app which is using a SharePoint list as it's data source. This works fine, but now the client wants each row in the list to also be linked to an Excel file. Initially, for each row in the list it would be linked to an Excel file with no data filled in. The user would then be able to enter and edit data which would be saved to the Excel file (so, I guess, I need to have the Excel file as a data source). Each row in the SharePoint list would need it's own individual Excel file. So, is there a way to embed the file into the SharePoint list or would there need to be an Excel file for each row in a Document Library?
I guess that whenever a new row is created, a blank Excel file could be created in the Document Library with a unique name (based on a primary key in the list) and then this would need to be set as a data source in the app.
Is this possible? Or will I need a different method of doing what is required?
Thanks,
Pete