C# Exporter un Datagridview dans un fichier HTML

Donc voici le code “brute de fonderie” comme on dit

  • principe :

Vous faites un copier coller du code (oui il comporte plusieurs fonction et il est un peu long ^^ )

Vous remplacez ce qui est en rouge dans votre code

2 éléments à remplacer :

  1. le nom de votre datagridview
  2. le chemin avec le nom compris du fichier html ou vous allez exporter votre datagrideview
 
 public void generationTableauHtml()
 {
 ConvertDataGridViewToHTMLWithFormatting(MyDatagridView);
 string text;
 StreamWriter sw = new StreamWriter(@"C:\Tableau.html");//création du fichier 
 text = ConvertDataGridViewToHTMLWithFormatting(MyDatagridView);
 sw.WriteLine("{0}", text);//enregistrement du message dans le fichier 
 sw.Close();
 }

#region TransferDatagriedViewToHTML
 
 public string ConvertDataGridViewToHTMLWithFormatting(DataGridView dgv)
 {
 StringBuilder sb = new StringBuilder();
 //create html & table
 sb.AppendLine("<html><body><center><p> Titre que je souhaite mettre</p><table border='1' cellpadding='0' cellspacing='0'>");
 sb.AppendLine("<tr>");
 //create table header
 for (int i = 0; i < dgv.Columns.Count; i++)
 {
 sb.Append(DGVHeaderCellToHTMLWithFormatting(dgv, i));
 sb.Append(DGVCellFontAndValueToHTML(dgv.Columns[i].HeaderText, dgv.Columns[i].HeaderCell.Style.Font));
 sb.AppendLine("</td>");
 }
 sb.AppendLine("</tr>");
 //create table body
 for (int rowIndex = 0; rowIndex < dgv.Rows.Count; rowIndex++)
 {
 sb.AppendLine("<tr>");
 foreach (DataGridViewCell dgvc in dgv.Rows[rowIndex].Cells)
 {
 sb.AppendLine(DGVCellToHTMLWithFormatting(dgv, rowIndex, dgvc.ColumnIndex));
 string cellValue = dgvc.Value == null ? string.Empty : dgvc.Value.ToString();
 sb.AppendLine(DGVCellFontAndValueToHTML(cellValue, dgvc.Style.Font));
 sb.AppendLine("</td>");
 }
 sb.AppendLine("</tr>");
 }
 //table footer & end of html file
 sb.AppendLine("</table></center></body></html>");
 return sb.ToString();
 }

public string DGVHeaderCellToHTMLWithFormatting(DataGridView dgv, int col)
 {
 StringBuilder sb = new StringBuilder();
 sb.Append("<td");
 sb.Append(DGVCellColorToHTML(dgv.Columns[col].HeaderCell.Style.ForeColor, dgv.Columns[col].HeaderCell.Style.BackColor));
 sb.Append(DGVCellAlignmentToHTML(dgv.Columns[col].HeaderCell.Style.Alignment));
 sb.Append(">");
 return sb.ToString();
 }

public string DGVCellToHTMLWithFormatting(DataGridView dgv, int row, int col)
 {
 StringBuilder sb = new StringBuilder();
 sb.Append("<td");
 sb.Append(DGVCellColorToHTML(dgv.Rows[row].Cells[col].Style.ForeColor, dgv.Rows[row].Cells[col].Style.BackColor));
 sb.Append(DGVCellAlignmentToHTML(dgv.Rows[row].Cells[col].Style.Alignment));
 sb.Append(">");
 return sb.ToString();
 }

public string DGVCellColorToHTML(Color foreColor, Color backColor)
 {
 if (foreColor.Name == "0" && backColor.Name == "0") return string.Empty;

StringBuilder sb = new StringBuilder();
 sb.Append(" style=\"");
 if (foreColor.Name != "0" && backColor.Name != "0")
 {
 sb.Append("color:#");
 sb.Append(foreColor.R.ToString("X2") + foreColor.G.ToString("X2") + foreColor.B.ToString("X2"));
 sb.Append("; background-color:#");
 sb.Append(backColor.R.ToString("X2") + backColor.G.ToString("X2") + backColor.B.ToString("X2"));
 }
 else if (foreColor.Name != "0" && backColor.Name == "0")
 {
 sb.Append("color:#");
 sb.Append(foreColor.R.ToString("X2") + foreColor.G.ToString("X2") + foreColor.B.ToString("X2"));
 }
 else //if (foreColor.Name == "0" && backColor.Name != "0")
 {
 sb.Append("background-color:#");
 sb.Append(backColor.R.ToString("X2") + backColor.G.ToString("X2") + backColor.B.ToString("X2"));
 }

sb.Append(";\"");
 return sb.ToString();
 }

public string DGVCellFontAndValueToHTML(string value, Font font)
 {
 //If no font has been set then assume its the default as someone would be expected in HTML or Excel
 if (font == null || font == this.Font && !(font.Bold | font.Italic | font.Underline | font.Strikeout)) return value;
 StringBuilder sb = new StringBuilder();
 sb.Append(" ");
 if (font.Bold) sb.Append("<b>");
 if (font.Italic) sb.Append("<i>");
 if (font.Strikeout) sb.Append("<strike>");

//The <u> element was deprecated in HTML 4.01. The new HTML 5 tag is: text-decoration: underline
 if (font.Underline) sb.Append("<u>");

string size = string.Empty;
 if (font.Size != this.Font.Size) size = "font-size: " + font.Size + "pt;";

//The <font> tag is not supported in HTML5. Use CSS or a span instead. 
 if (font.FontFamily.Name != this.Font.Name)
 {
 sb.Append("<span style=\"font-family: ");
 sb.Append(font.FontFamily.Name);
 sb.Append("; ");
 sb.Append(size);
 sb.Append("\">");
 }
 sb.Append(value);
 if (font.FontFamily.Name != this.Font.Name) sb.Append("</span>");

if (font.Underline) sb.Append("</u>");
 if (font.Strikeout) sb.Append("</strike>");
 if (font.Italic) sb.Append("</i>");
 if (font.Bold) sb.Append("</b>");

return sb.ToString();
 }

public string DGVCellAlignmentToHTML(DataGridViewContentAlignment align)
 {
 if (align == DataGridViewContentAlignment.NotSet) return string.Empty;

string horizontalAlignment = string.Empty;
 string verticalAlignment = string.Empty;
 CellAlignment(align, ref horizontalAlignment, ref verticalAlignment);
 StringBuilder sb = new StringBuilder();
 sb.Append(" align='");
 sb.Append(horizontalAlignment);
 sb.Append("' valign='");
 sb.Append(verticalAlignment);
 sb.Append("'");
 return sb.ToString();
 }

private void CellAlignment(DataGridViewContentAlignment align, ref string horizontalAlignment, ref string verticalAlignment)
 {
 switch (align)
 {
 case DataGridViewContentAlignment.MiddleRight:
 horizontalAlignment = "right";
 verticalAlignment = "middle";
 break;
 case DataGridViewContentAlignment.MiddleLeft:
 horizontalAlignment = "left";
 verticalAlignment = "middle";
 break;
 case DataGridViewContentAlignment.MiddleCenter:
 horizontalAlignment = "centre";
 verticalAlignment = "middle";
 break;
 case DataGridViewContentAlignment.TopCenter:
 horizontalAlignment = "centre";
 verticalAlignment = "top";
 break;
 case DataGridViewContentAlignment.BottomCenter:
 horizontalAlignment = "centre";
 verticalAlignment = "bottom";
 break;
 case DataGridViewContentAlignment.TopLeft:
 horizontalAlignment = "left";
 verticalAlignment = "top";
 break;
 case DataGridViewContentAlignment.BottomLeft:
 horizontalAlignment = "left";
 verticalAlignment = "bottom";
 break;
 case DataGridViewContentAlignment.TopRight:
 horizontalAlignment = "right";
 verticalAlignment = "top";
 break;
 case DataGridViewContentAlignment.BottomRight:
 horizontalAlignment = "right";
 verticalAlignment = "bottom";
 break;

default: //DataGridViewContentAlignment.NotSet
 horizontalAlignment = "left";
 verticalAlignment = "middle";
 break;
 }
 }

#endregion
Étiquettes : ,

Laisser un commentaire

Votre adresse de messagerie ne sera pas publiée. Les champs obligatoires sont indiqués avec *