/// <summary>
/// Converts the Linq data to a commaseperated string including header.
/// </summary>
/// <param name="data">The data.</param>
/// <param name="delimiter">The delimiter.</param>
/// <param name="nullvalue">The nullvalue.</param>
/// <returns></returns>
public static string ToCSVString(this System.Linq.IOrderedQueryable data, string delimiter, string nullvalue)
{
StringBuilder csvdata = new StringBuilder();
string replaceFrom = delimiter.Trim();
string replaceDelimiter = ";";
System.Reflection.PropertyInfo[] headers = data.ElementType.GetProperties();
switch (replaceFrom)
{
case ";":
replaceDelimiter = ":";
break;
case ",":
replaceDelimiter = "¸";
break;
case "\t":
replaceDelimiter = " ";
break;
default:
break;
}
if (headers.Length > 0)
{
foreach (var head in headers)
{
csvdata.Append(head.Name.Replace("_", " ") + delimiter);
}
csvdata.Append("\n");
}
foreach (var row in data)
{
var fields = row.GetType().GetProperties();
int fieldsLength = fields.Length;
for (int i = 0; i < fieldsLength; ++i)
{
object value = null;
try
{
value = fields[i].GetValue(row, null);
}
catch { }
if (value != null)
{
csvdata.Append(value.ToString().Replace("\r", "\f").Replace("\n", " \f").Replace("_", " ").Replace(replaceFrom, replaceDelimiter) + delimiter);
}
else
{
csvdata.Append(nullvalue);
csvdata.Append(delimiter);
}
}
csvdata.Append("\n");
}
return(csvdata.ToString());
}
/// <summary>
/// Converts the Linq data to a commaseperated string including header.
/// </summary>
/// <param name="data">The data.</param>
/// <param name="delimiter">The delimiter.</param>
/// <returns></returns>
public static string ToCSVString(this System.Linq.IOrderedQueryable data, string delimiter)
{
return(ToCSVString(data, "; ", null));
}
/// <summary>
/// Converts the Linq data to a comma seperated string including header.
/// </summary>
/// <param name="data">The data.</param>
/// <returns></returns>
public static string ToCSVString(this System.Linq.IOrderedQueryable data)
{
return(ToCSVString(data, "; "));
}