C# read CSV file from URL without downloading

20/08/2021- duocnt 1581 Views

STEPS TO DO

Create console application.
Create a class with the name ReadCsvOnline.
Read CSV from URL.
Result.

Source code.

https://github.com/ntduoc/ReadCSVFileFromURLWithoutDownload.git

Action.

1 - Create a console application.

2 - Create a class with the name ReadScvOnline.

Create Constructor method and URL properties for the class.

Create a method for reading the header of CSV.

        public string[] CsvHeaders()
        {
            HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
            HttpWebResponse resp = (HttpWebResponse)req.GetResponse();
            StreamReader sr = new StreamReader(resp.GetResponseStream());
            string[] headers;
            headers = sr.ReadLine().Split('\t');
            return headers;
        }

Create a method for reading the content of CSV.

        public StringBuilder CsvContent()
        {
            HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
            HttpWebResponse resp = (HttpWebResponse)req.GetResponse();
            StreamReader sr = new StreamReader(resp.GetResponseStream());
            StringBuilder stringBuilder = new StringBuilder();
 
            sr.ReadLine();
            string textline;
            while ((textline = sr.ReadLine()) != null)
            {
                stringBuilder.Append(textline);
                stringBuilder.Append(";");                
            }
            return stringBuilder;
        }