C# 读取world表格信息
public void ReadWord()
{
//Give the value to the tow Int32 params.
Open();
if (txtBBTYPE.Value.ToString() == "单位月报")
{
try
{
if (openState == true)
{
table = doc.Tables[1];
string danwei = table.Cell(1, 1).Range.Text.ToString().Trim().Substring(0, table.Cell(1, 1).Range.Text.ToString().Trim().Length - 2);
// string danwei1 = table.Cell(0, 0).Range.Text.ToString().Trim().Substring(0, table.Cell(0, 0).Range.Text.ToString().Trim().Length - 2);
txtSQDW.Value = danwei.Substring(2, danwei.IndexOf("单"));
txtJBQK.Value = table.Cell(2, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
txtGZJZ.Value = table.Cell(3, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
txtZYCG.Value = table.Cell(4, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
txtZYWT.Value = table.Cell(5, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
txtGZAP.Value = table.Cell(6, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
txtQT.Value = table.Cell(7, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
Textarea1.Value = table.Cell(9, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
Textarea2.Value = table.Cell(10, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
Textarea3.Value = table.Cell(11, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
Textarea4.Value = table.Cell(12, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(2, 2).Range.Text.ToString().Trim().Length - 2);
Close();
}
else
{
//return "";
Close();
}
}
catch
{
// return "Error";
Close();
}
}
if (txtBBTYPE.Value.ToString() == "周报") {
try {
if (openState == true)
table = doc.Tables[1];
txtGZJZ.Value = table.Cell(3, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(3, 2).Range.Text.ToString().Trim().Length - 2);
txtJBQK.Value = table.Cell(4, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(4, 2).Range.Text.ToString().Trim().Length - 2);
txtZYCG.Value = table.Cell(5, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(5, 2).Range.Text.ToString().Trim().Length - 2);
txtZYWT.Value = table.Cell(6, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(6, 2).Range.Text.ToString().Trim().Length - 2);
txtGZAP.Value = table.Cell(7, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(7, 2).Range.Text.ToString().Trim().Length - 2);
txtQT.Value = table.Cell(8, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(8, 2).Range.Text.ToString().Trim().Length - 2);
txtPJ.Value = table.Cell(9, 2).Range.Text.ToString().Trim().Substring(0, table.Cell(9, 2).Range.Text.ToString().Trim().Length - 2);
Close();
}
catch {
Close();
}
}
}
/**//// <summary>
/// 关闭Word文档
/// </summary>
public void Close()
{
if (openState == true)
{
if (doc != null)
doc.Close(ref missing, ref missing, ref missing);
cls.Quit(ref missing, ref missing, ref missing);
}
}
/**/
/// <summary>
/// 打开Word文档
/// </summary>
public void Open()
{
object path = UploadReport.PostedFile.FileName;
cls = new ApplicationClass();
cls.Visible = false;//不打开wrod
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);
openState = true;
}
catch
{
openState = false;
}
}
