private void button13_Click(object sender, EventArgs e)
{
ExcelOp eop = new ExcelOp();
eop.Open(System.Environment.CurrentDirectory + "\\" + txt_excelfile.Text, true);
int i = 1;
while (i < 100)
{
txt_excelContext.AppendText(eop.GetCellValue("Sheet1", i, 2));
i++;
}
eop.Save();
eop.Close();
}
/// <summary>
/// 写入excel文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button12_Click(object sender, EventArgs e)
{
ExcelOp eop = new ExcelOp();
eop.Open(System.Environment.CurrentDirectory + "\\" + txt_excelfile.Text, true);
eop.SetCellProperty1("Sheet1", 1, 1, 100, 2, 10, "宋体", 3);
int i = 1;
while (i < 100)
{
eop.SetCellValue("Sheet1", i, 2, "hello" + i.ToString());
i++;
}
eop.Save();
eop.Close();
}
