public static void ExportAsCsv(String a_FilePath, ExportedData a_Data)
{
StreamWriter file = new StreamWriter(a_FilePath);
for (int i = 0; i < a_Data.Rows.Length; i++)
{
ExportedRow currRow = a_Data.Rows[i];
StringBuilder sb = new StringBuilder();
for (int j = 0; j < currRow.Cells.Length; j++)
{
if (j != 0)
{
sb.Append(",");
}
String text = currRow.Cells[j];
sb.Append(CsvEncode(text));
}
file.WriteLine(sb.ToString());
}
file.Close();
}
public static void ExportAsHtml(String a_FilePath, ExportedData a_Data)
{
StreamWriter file = new StreamWriter(a_FilePath);
file.WriteLine("<html>");
file.WriteLine("\t<style type=\"text/css\">");
file.WriteLine("\ttable {");
file.WriteLine("\tborder-bottom-color: #c3c3c3;");
file.WriteLine("\tborder-bottom-style: solid;");
file.WriteLine("\tborder-bottom-width: 1px;");
file.WriteLine("\tborder-collapse: collapse;");
file.WriteLine("\tborder-left-color: #c3c3c3;");
file.WriteLine("\tborder-left-style: solid;");
file.WriteLine("\tborder-left-width: 1px;");
file.WriteLine("\tborder-right-color: #c3c3c3;");
file.WriteLine("\tborder-right-style: solid;");
file.WriteLine("\tborder-right-width: 1px;");
file.WriteLine("\tborder-top-color: #c3c3c3;");
file.WriteLine("\tborder-top-style: solid;");
file.WriteLine("\tborder-top-width: 1px;");
file.WriteLine("</style>");
file.WriteLine("</head>");
file.WriteLine("<body>");
file.WriteLine("<table cellspacing=\"0\" cellpadding=\"0\" border=\"1\">");
for (int i = 0; i < a_Data.Rows.Length; i++)
{
ExportedRow currRow = a_Data.Rows[i];
file.WriteLine("\t<tr bgcolor=\"#{0:X2}{1:X2}{2:X2}\">", currRow.Color.R, currRow.Color.G, currRow.Color.B);
for (int j = 0; j < currRow.Cells.Length; j++)
{
HorizontalAlignment align = a_Data.Aligns[j];
String text = currRow.Cells[j];
file.WriteLine("\t\t<td align=\"{0}\">{1}</td>", GetHtmlAlignName(align), HtmlEncode(text));
}
file.WriteLine("\t</tr>");
}
file.WriteLine("</table>");
file.WriteLine("</body>");
file.WriteLine("</html>");
file.Close();
}
