private static bool IsWysiwygFormattedRow(SpreadsheetRow row)
{
var key = row.MetadataKey;
// At this point we're treating all content rows except the headers (and some labels) as wysiwyg
return(key != InternalSpreadsheet.RowTypeColumnLabel && key.StartsWith("[") && key.EndsWith("]"));
}
public void AddRow(SpreadsheetRow row)
{
_rows.Add(row);
row.Spreadsheet = this;
}
private static void ReadRow(ExcelWorksheet worksheet, int rowIndex, int colCount, SpreadsheetRow row)
{
for (var c = 0; c < colCount; c++)
{
ExcelRange currentCell = worksheet.Cells[rowIndex + 1, c + 1];
// The first row is special because it contains the headers needed by IsWysiwygFormattedColumn
if (rowIndex > 0 && IsWysiwygFormattedColumn(row, c) &&
IsWysiwygFormattedRow(row))
{
row.AddCell(BuildXmlString(currentCell));
}
else
{
var cellContent = worksheet.Cells[rowIndex + 1, c + 1].Value ?? "";
row.AddCell(ReplaceExcelEscapedCharsAndEscapeXmlOnes(cellContent.ToString()));
}
}
}
private static bool IsWysiwygFormattedColumn(SpreadsheetRow row, int index)
{
var key = row.Spreadsheet.Header.GetRow(0).GetCell(index).Content;
return(!nonWysiwygColumns.Contains(key));
}
private static void ReadRow(ExcelWorksheet worksheet, int rowIndex, int colCount, SpreadsheetRow row)
{
for (var c = 0; c < colCount; c++)
{
var cellContent = worksheet.Cells[rowIndex + 1, c + 1].Value ?? "";
row.AddCell(cellContent.ToString());
}
}