Changing a file on the server using a local windows app

Question

Hey all,

I am writing an automation to update the contents on an excel sheet(in c#) present on our server. Our server has various portals and has different credentials. How could I fetch the file on my portal to my local computer to make some changes to it.

Answer 1

Is your computer on a domain with the server? If so...

Run as a user who has access and manipulate it via UNC paths just like normal paths... for example you would load @"\Servername\share\file.xls" instead of @"C:\path\file.xls".