public static stringGetHtmlString(DataTable dt)
{
StringBuilder sb= newStringBuilder();
sb.Append("
");sb.Append("
Excel转换为Table");sb.Append("");
sb.Append("
sb.Append("td{font-size: 9pt;border:solid 1 #000000;}");
sb.Append("table{padding:3 0 3 0;border:solid 1 #000000;margin:0 0 0 0;BORDER-COLLAPSE: collapse;}");
sb.Append("");
sb.Append("");
sb.Append("
");sb.Append("
sb.Append("
");sb.Append("
");foreach (DataColumn column indt.Columns){
sb.Append("
" + column.ColumnName + "");}
sb.Append("
");int iColsCount =dt.Columns.Count;int rowsCount = dt.Rows.Count - 1;for (int j = 0; j <= rowsCount; j++){
sb.Append("
");sb.Append("
" + ((int)(j + 1)).ToString() + "");for (int k = 0; k <= iColsCount - 1; k++){
sb.Append("
");object obj =dt.Rows[j][k];if (obj ==DBNull.Value){
obj= " ";//如果是NULL则在HTML里面使用一个空格替换之
}if (obj.ToString() == "")
{
obj= " ";
}string strCellContent =obj.ToString().Trim();
sb.Append("" + strCellContent + "");
sb.Append("
");}
sb.Append("
");}
sb.Append("
");//点击单元格 输出 行和列sb.Append("");
sb.Append("
sb.Append("$('table tbody').on('click', 'td', function (e) {");
sb.Append("var row = $(this).parent().prevAll().length-1 ;");
sb.Append("var column = $(this).prevAll().length-1 ;");
sb.Append("var str = 'dt.Rows[' + row + '][' + column + '].ToString()';");
sb.Append("console.log(str);alert(str);");
sb.Append("});");
sb.Append("");
sb.Append("");returnsb.ToString();
}