/// <summary>
/// 获得cell信息并存入数据库
/// </summary>
public void getCellInfo()
{
axCell1.DoLogin("*********)", ***, "*************************************");
this.CellFileName = Application.StartupPath + "//prt//DispMeterPrt.cll";
this.Password = "";
axCell1.DoOpenFileEx(CellFileName, Password);
this.SetCellCurrentCell(2, 4);
axCell1.DoMoveToCell(2, 4);
SetCellDisplay(axCell1);
ArrayList a = new ArrayList();
getStringName = axCell1.DoGetPageCellString(1, 4, 0).ToString().Substring(0,10);
//Cols表格行数,真的
//Rows表格列数,没错
for (int i = 0; i < axCell1.Cols; i++)
{
for (int j = 0; j < axCell1.Rows; j ++)
{
//判断所取数据是否为空
if (axCell1.DoGetPageCellString(i, j, 0).ToString() != "")
{
//获得插入数据信息
Hashtable map = KingLib.HashMap.set(
"tableName", getStringName,
"rowNum",i,
"columNum",j,
"fieldValue", axCell1.DoGetPageCellString(i, j, 0));
//插入数据
KingLib.DataRecordManager.InsertRecord("PrtPotentiometer", map);
}
}
}
}