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(); }