public void TestWriteCell() { var dt = GetTestData(); string dataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", "onesheetfile.xlsx"); NPOIOperator oper = new NPOIOperator(dataFilePath, true); var sheet = oper.GetSheet("Sheet3"); var row = sheet.CreateRow(0); var cell1 = row.CreateCell(0); oper.WriteCell(cell1, dt.Rows[1]["姓名"], CellDataType.Text); var cell2 = row.CreateCell(1); oper.WriteCell(cell2, dt.Rows[1]["性别"], CellDataType.Int); var readDT = oper.ReadSheet(sheet, false, true, 0); Assert.AreEqual(1, readDT.Rows.Count); Assert.AreEqual("李四", readDT.Rows[0]["列1"].ToString()); Assert.AreEqual(0, readDT.Rows[0]["列2"]); }