I am fairly new to doing anything in SharePoint, other than basic operations. I have been tasked with creating a SharePoint 2013 site with the following operations:
- Upload a selected Excel Spreadsheet.
- Create a list item from each row in the spreadsheet, after some basic processing that was originally done using VBA in Excel.
Would I create a Library, upload the file, and then add some code that would do the processing? If so, where would I put the code and what would it look like?
I think that if I could get the file uploaded successfully and then open the spreadsheet, I can figure out the rest. Could be incorrect, though. Can anyone help me out here?