public void VisualizeIndexedColors() { string path = PathToTestFolder.Get(TestFolders.Db) + "Data\\"; var excelFileWrapper = new ExcelFileWrapper(new HSSFWorkbook()); var sheet = excelFileWrapper.Workbook.CreateSheet(); for (short i = 0; i < 64; i++) { var row = sheet.CreateRow(i); var cell = row.CreateCell(0); var style = excelFileWrapper.Workbook.CreateCellStyle(); style.FillPattern = FillPattern.SolidForeground; style.FillForegroundColor = i; cell.CellStyle = style; cell.SetCellValue(i); } excelFileWrapper.Save(path + "IndexedColors.xls"); }
public void ExcelReaderTest() { var excelFileWrapper = new ExcelFileWrapper(); string path = PathToTestFolder.Get(TestFolders.Db) + "Data\\"; excelFileWrapper.Read(path + "506FileUploadGood.xlsx"); var sheet = excelFileWrapper.Workbook.GetSheetAt(0); for (int rowNum = sheet.FirstRowNum; rowNum <= sheet.LastRowNum; rowNum++) { var row = sheet.GetRow(rowNum); excelFileWrapper.SetupErrorCell(row.Cells[rowNum], "Comment " + rowNum + "\r\nComment 2\r\nComment 3 line long long long long long long long long"); foreach (var cell in row.Cells) { var value = excelFileWrapper.GetCellValue(cell); var str = excelFileWrapper.GetCellText(cell); } if (rowNum % 2 != 0) { excelFileWrapper.SetupErrorRow(row, "Test comment"); } } excelFileWrapper.Save(path + "test.xlsx"); }