void ButtonExcelReadClick(object sender, EventArgs e) { if (!CheckExcelRowColValid()) { MessageBox.Show("please input excel row(1,2,3...) and col(A,B,C...)"); return; } string cell = this.textBoxExcelCol.Text + this.textBoxExcelRow.Text; string filename = Path.GetFileName(this.textBoxExcelPath.Text); ExcelUIA excel = new ExcelUIA(filename); string value = "not found"; bool ret = excel.GetValue(cell, ref value); this.textBoxExcelValue.Text = value; if (ret) { MessageBox.Show(cell + "读取成功: " + value); } excel.Close(); excel = null; }
void ButtonExcelWriteClick(object sender, EventArgs e) { if (!CheckExcelRowColValid()) { MessageBox.Show("please input excel row(1,2,3...) and col(A,B,C...)"); return; } string cell = this.textBoxExcelCol.Text + this.textBoxExcelRow.Text; string filename = Path.GetFileName(this.textBoxExcelPath.Text); ExcelUIA excel = new ExcelUIA(filename); if (excel.SetValue(cell, this.textBoxExcelValue.Text)) { MessageBox.Show(cell + "设置成功"); } excel.Close(); excel = null; }