将word表格读取出来，然后显示到gridview代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】将word表格读取出来，然后显示到gridview
作者:Dezai.CN / 发布于2011/8/23/ 657
<div>
先给gridview一个数据源，是什么呢 datatable
这个函数
public static DataTable WordTable(object path)
{
ApplicationClass cls = null;
Document doc = null;
Microsoft.Office.Interop.Word.Table table = null;
object missing = Missing.Value;
//object path = TextBoxPath.Text.Trim();
cls = new ApplicationClass();
//try
//{
doc = cls.Documents.Open
(ref path, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing);
table = doc.Tables[1];
float[] cellWith = new float[table.Rows.Count];
bool modOk = false;
#region 声明一个DataTable
DataTable dt = new DataTable();
int spaceCount = 1;
for (int ii = 0; ii < table.Columns.Count; ii++)
{
dt.Columns.Add("cl" + ii.ToString(), typeof(string));
}
for (int ii = 0; ii < table.Rows.Count; ii++)
{
DataRow rw = dt.NewRow();
for (int jj = 0; jj < table.Columns.Count; jj++)
{
rw["cl" + jj.ToString()] = "";
spaceCount++;
}
dt.Rows.Add(rw);
}
#endregion
#region

#endregion
#region 选一个没有任何合并的行，并把该行的单元格的宽作为标准
for (int ii = 0; ii < table.Rows.Count; ii++)
{
for (int jj = 0; jj < table.Columns.Count; jj++)
{
try
{
cellWith[jj] = (float)table.Cell(ii + 1, jj + 1).Width;
if (jj + 1 == table.Columns.Count)
{
modOk = true;
break;
}
}
catch
{
break;
}

}
if (modOk == true)
break;
}
#endregion
#region 读word表格，写入DataTable
float rowLength = 0;
for (int ii = 0; ii < cellWith.Length; ii++)
{
rowLength += cellWith[ii];
rowLength = float.Parse(rowLength.ToString("#0.00"));
}
for (int ii = 0; ii < table.Rows.Count; ii++)
{
float rowLengthCurrent = 0f;
for (int jj = 0; jj < table.Columns.Count; jj++)
{
bool IfBreak = false;
bool IfContinue = false;
try
{
rowLengthCurrent += (float)table.Cell(ii + 1, jj + 1).Width;
rowLengthCurrent = float.Parse(rowLengthCurrent.ToString("#0.00"));
if (table.Cell(ii + 1, jj + 1).Width != cellWith[jj])
{
float real = 0f;
for (int mm = jj; mm < cellWith.Length - 1 - jj; mm++)
{
real += (float)cellWith[mm];
real = float.Parse(real.ToString("#0.00"));
string txt = string.Empty;
if (mm == jj)
{
txt = table.Cell(ii + 1, jj + 1).Range.Text;
txt = txt.Substring(0, txt.Length - 2);
}
else
txt = "<a href="mailto:#!@#$%"><font color="#286446">#!@#$%</font></a>^";
dt.Rows[ii][mm] = txt;
if (real == table.Cell(ii + 1, jj + 1).Width)
{
if (mm + 1 == dt.Columns.Count)
{
IfBreak = true;
break;
}
else
{
jj = mm + 1;
IfContinue = true;
break;
}

//Response.Write("从"+jj.ToString()+"到"+mm.ToString());
}////////////////////////////////////////////////////////////////////
}
if (IfBreak == true)
break;
if (IfContinue == true)
continue;
}
string txtNor = table.Cell(ii + 1, jj + 1).Range.Text;
dt.Rows[ii][jj] = txtNor.Substring(0, txtNor.Length - 2);
if (rowLengthCurrent == rowLength)
{

continue;
}

}
catch
{
if (ii > 0)
{
rowLengthCurrent += cellWith[jj];
rowLengthCurrent = float.Parse(rowLengthCurrent.ToString("#0.00"));
//dt.Rows[ii][jj] = dt.Rows[ii - 1][jj].ToString();
dt.Rows[ii][jj] = "<a href="mailto:%5E!@#$%"><font color="#286446">^!@#$%</font></a>^";
}
continue;
}
}
}
if (doc != null)
doc.Close(ref missing, ref missing, ref missing);
cls.Quit(ref missing, ref missing, ref missing);
return dt;
#endregion
}

然后gridview绑定之后再调用一个合并单元格的方法，什么方法呢，如下
public static void GridViewMerAll(GridView gv)
{
for (int ii = 0; ii < gv.Rows.Count; ii++)
{
int m = 1;
int n = 1;
for (int jj = 0; jj < gv.Rows[ii].Cells.Count; jj++)
{
if (gv.Rows[ii].Cells[jj].Text.Contains("<a href="mailto:#!@#$%"><font color="#286446">#!@#$%</font></a>^"))
{
common.GridViewMergeCell.GroupRow(gv, ii, jj - m, jj + 1);
m++;
}
if (gv.Rows[ii].Cells[jj].Text.Contains("<a href="mailto:%5E!@#$%"><font color="#286446">^!@#$%</font></a>^"))
{
common.GridViewMergeCell.GroupCol(gv, jj, ii - n, ii + 1);
n++;
}
}
}
}
</div>
试试其它关键字
　读取word表格　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)