CSV to TextReader
/// <summary>
/// Take a file path and return a TextReader
/// </summary>
/// <param name="file_path"></param>
/// <returns></returns>
private TextReader OpenFile (string file_path)
{
try
{
// Read the CSV file in to a TextReader
TextReader _rdr = File.OpenText(file_path);
// Set file attributes
File.SetAttributes(file_path, FileAttributes.Normal);
return _rdr;
}
catch (Exception)
{
throw new Exception(String.Format(
"Error trying to open file {0}. Check file exists and is accessible<br /><br />" +
"Possible Issues:<br/><br />Files cannot be accessed via mapped network drives" +
"<br />The file is open<br />The file has been viewed and then saved in Excel",file_path));
}
}