Skip to content

Instantly share code, notes, and snippets.

@jsmarble
Last active January 17, 2022 12:12
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jsmarble/d24fe77446c246ec2401f5c62962c72d to your computer and use it in GitHub Desktop.
Save jsmarble/d24fe77446c246ec2401f5c62962c72d to your computer and use it in GitHub Desktop.
Extension method to turn a DataTable into a Markdown table
public static StringBuilder AsMarkdownTable(this DataTable source)
{
StringBuilder sb = new StringBuilder();
foreach (DataColumn column in source.Columns)
sb.Append("|").Append(column.ColumnName.Trim());
sb.AppendLine("|");
for (int i = 0; i < source.Columns.Count; i++)
sb.Append("|----");
sb.AppendLine("|");
foreach (DataRow row in source.Rows)
{
foreach (object val in row.ItemArray)
sb.Append("|").Append(Convert.ToString(val).Trim());
sb.AppendLine("|");
}
return sb;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment