How to update an excel file that is stored in sharepoint

You could use Free Spire.XLS to load the Excel from steam, update the Excel file and then upload to sharepoint.

using System.Net;
using Spire.Xls;
namespace UpdateExcel
{
class Program
{
static void Main(string[] args)
{
Workbook wb = new Workbook();
WebClient webClient = new WebClient();
using (MemoryStream ms = new MemoryStream(webClient.DownloadData("shaprepointUrl")))
{
wb.LoadFromStream(ms,ExcelVersion.Version2013);
Worksheet sheet = wb.Worksheets[0];
//delete row
int rowToRemove = 3;
sheet.DeleteRow(rowToRemove);
//insert row
int rowIndex = 3;
sheet.InsertRow(rowIndex);
//update a specific cell
sheet.Range["E2"].Value = "updated";
//save changes
wb.Save();
//upload to sharepoint
//....
}
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.