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