Get excel file from sharepointedit and save as CSV

Question

I am no where realted to sharepoint or microsoft. I am asked to get the excel file from sharepointedit value in itsave as CSV file. I have to use that CSV file to move ahead in this project. So i am struck with step 1. How can i get the excel file from sharepoint?Its going to be daily process. I heard that powershell can login to sharepoint and get the excel file?AM i correct? Someone please guide me with these steps.I am completely blank till i get my CSV file. Thank you.

Armstrong Linda · Answer

Yes I can download it from SharePoint directly. But we have to automate the process such that on daily basislogin from PowerShell to SharePointget the excel filerun through the workbooks and save them as individual CSV files. I am.able to run through the excel.file located in local folder and save as CSV file. But I am.not able to login to SharePoint to get the excel file . Please guide me how can I login to SharePointgo to particular folder to get the excel file.and proceed with rest of .

Leon D · Answer

Hi For saving Excel to CSV you can refer below article: Easiest Solution to Convert Excel to CSV in C# VB.NET https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/NET-Excel-to-CSV-Easiest-Solution-to-Convert-Excel-to-CSV-with-C-VB.NET.html

Ravishankar Singh · Answer

Hi Are you trying to export excel file from sharepoint? if yes you can download directly from sharepoint using download option. If no you have an option to export the file as an excel (refer if you have new version of sharepoint- http://sharepointmaven.com/export-sharepoint-excel/). Please let me know if that helps. Thank you

Get excel file from sharepoint,edit and save as CSV