C# (CSharp) NPOIOperator.WriteTitle示例

示例#1

文件： NPOIOperatorTest.cs 项目： bosima/FireflySoft.Excel

        public void TestWriteTitleWithRow()
        {
            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);
            oper.WriteTitle(row, dt.Columns);

            var cols = oper.ReadTitle(sheet);
            Assert.AreEqual(5, cols.Length);
            Assert.AreEqual("姓名", cols[1].ColumnName);
        }