Пример #1
0
        public void Init()
        {
            var _xssfsheet = Substitute.For <XSSFSheet>();
            var _workbook  = Substitute.For <SXSSFWorkbook>();
            var _sheet     = Substitute.For <SXSSFSheet>(_workbook, _xssfsheet);

            _row  = Substitute.For <SXSSFRow>(_sheet);
            _cell = Substitute.For <ICell>();
        }
Пример #2
0
        public void IfWritingRowWithCustomHeightShouldIncludeCustomHeightXml()
        {
            _objectToTest = new SheetDataWriter();
            var row = new SXSSFRow(null);

            row.Height = 1;

            _objectToTest.WriteRow(0, row);
            _objectToTest.Close();

            var lines = File.ReadAllLines(_objectToTest.TemporaryFilePath());

            Assert.True(lines.Length == 2);
            Assert.AreEqual("<row r=\"" + 1 + "\" customHeight=\"true\"  ht=\"" + row.HeightInPoints + "\">", lines[0]);
            Assert.AreEqual("</row>", lines[1]);
        }
Пример #3
0
        public void ChangeRowNum()
        {
            SXSSFWorkbook wb    = new SXSSFWorkbook(3);
            SXSSFSheet    sheet = wb.CreateSheet() as SXSSFSheet;
            SXSSFRow      row0  = sheet.CreateRow(0) as SXSSFRow;
            SXSSFRow      row1  = sheet.CreateRow(1) as SXSSFRow;

            sheet.ChangeRowNum(row0, 2);

            Assert.AreEqual(1, row1.RowNum, "Row 1 knows its row number");
            Assert.AreEqual(2, row0.RowNum, "Row 2 knows its row number");
            Assert.AreEqual(1, sheet.GetRowNum(row1), "Sheet knows Row 1's row number");
            Assert.AreEqual(2, sheet.GetRowNum(row0), "Sheet knows Row 2's row number");
            Assert.AreEqual(row1, sheet.GetEnumerator().Current, "Sheet row iteratation order should be ascending");

            wb.Close();
        }
Пример #4
0
 public void Init()
 {
     _objectToTest = new SXSSFRow(null);
 }
Пример #5
0
 public void Init()
 {
     _row  = Substitute.For <SXSSFRow>();
     _cell = Substitute.For <ICell>();
 }