private static void AddRowBase(
this CellCursor cursor,
RowBase rowBase,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyRowFormat(rowBase.Format);
}
for (var x = 0; x < rowBase.Cells.Count; x++)
{
if (x > 0)
{
cursor.MoveRight(rowBase.Cells[x - 1].ColumnsSpanned ?? 1);
}
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyRowFormat(rowBase.Format);
}
cursor.AddCell(rowBase.Cells[x], context, passKind);
}
}
private static void AddDataRows(
this CellCursor cursor,
DataRows dataRows,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (dataRows == null)
{
return;
}
if (dataRows.Rows.Any())
{
for (var x = 0; x < dataRows.Rows.Count; x++)
{
cursor.ResetColumn();
cursor.MoveDown();
if (x == 0)
{
cursor.AddMarker(TopLeftDataCellMarker);
}
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyDataRowsFormat(dataRows.Format);
}
cursor.AddRow(dataRows.Rows[x], context, passKind, dataRows.Format);
}
cursor.AddMarker(BottomRightDataCellMarker);
}
}
private static void AddFooterRows(
this CellCursor cursor,
FooterRows footerRows,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (footerRows == null)
{
return;
}
if (footerRows.Rows.Any())
{
foreach (var flatRow in footerRows.Rows)
{
cursor.ResetColumn();
cursor.MoveDown();
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyFooterRowsFormat(footerRows.Format);
}
cursor.AddFlatRow(flatRow, context, passKind);
}
}
}
private static void AddFlatRow(
this CellCursor cursor,
FlatRow flatRow,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
cursor.AddRowBase(flatRow, context, passKind);
}
private static void AddCell(
this CellCursor cursor,
ICell cell,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (passKind == PassKind.Data)
{
if ((cell.ColumnsSpanned ?? 1) > 1)
{
// ReSharper disable once PossibleInvalidOperationException
var mergeRange = cursor.Worksheet.GetRange(cursor.RowNumber, cursor.RowNumber, cursor.ColumnNumber, cursor.ColumnNumber + (int)cell.ColumnsSpanned - 1);
mergeRange.SetMergeCells(true);
}
}
if ((passKind == PassKind.Formatting) && (cell is IHaveCellFormat haveCellFormat))
{
cursor.CellRange.ApplyCellFormat(haveCellFormat.Format);
}
var notSupportedException = new NotSupportedException(Invariant($"This type of cell is not supported: {cell.GetType().ToStringReadable()}."));
if (cell is INotSlottedCell)
{
if (cell is INullCell)
{
}
else if (cell is ConstCell <string> stringConstCell)
{
if (passKind == PassKind.Data)
{
cursor.Cell.Value = stringConstCell.Value;
}
}
else if (cell is ConstCell <int> intConstCell)
{
if (passKind == PassKind.Data)
{
cursor.Cell.Value = intConstCell.Value;
}
}
else
{
throw notSupportedException;
}
}
else if (cell is ISlottedCell)
{
throw notSupportedException;
}
else
{
throw notSupportedException;
}
}
private static void AddRow(
this CellCursor cursor,
DataStructure.Row row,
ReportToWorkbookProjectionContext context,
PassKind passKind,
DataRowsFormat dataRowsFormat)
{
cursor.AddRowBase(row, context, passKind);
if (cursor.HasMarker(BottomRightNonSummaryDataCellMarker))
{
cursor.RemoveMarker(BottomRightNonSummaryDataCellMarker);
}
cursor.AddMarker(BottomRightNonSummaryDataCellMarker);
if ((row.ChildRows != null) && row.ChildRows.Any())
{
foreach (var childRow in row.ChildRows)
{
cursor.ResetColumn();
cursor.MoveDown();
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyDataRowsFormat(dataRowsFormat);
}
cursor.AddRow(childRow, context, passKind, dataRowsFormat);
}
}
if (row.CollapsedSummaryRows != null && row.CollapsedSummaryRows.Any())
{
throw new NotSupportedException("collapsed summary rows are not supported");
}
if (row.ExpandedSummaryRows != null)
{
foreach (var expandedSummaryRow in row.ExpandedSummaryRows)
{
cursor.ResetColumn();
cursor.MoveDown();
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyDataRowsFormat(dataRowsFormat);
}
cursor.AddFlatRow(expandedSummaryRow, context, passKind);
}
}
}
private static void AddTreeTable(
this CellCursor cursor,
TreeTable treeTable,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (passKind == PassKind.Formatting)
{
// Format whole table
cursor.CanvassedRange.ApplyTableFormat(treeTable.Format);
// Format columns
var tableColumns = treeTable.TableColumns;
var topLeftDataCellReference = cursor.HasMarker(TopLeftDataCellMarker) ? cursor.GetMarkedCellReference(TopLeftDataCellMarker) : null;
var bottomRightNonSummaryDataCellReference = cursor.HasMarker(BottomRightNonSummaryDataCellMarker) ? cursor.GetMarkedCellReference(BottomRightNonSummaryDataCellMarker) : null;
var bottomRightHeaderCellReference = cursor.HasMarker(BottomRightHeaderCellMarker) ? cursor.GetMarkedCellReference(BottomRightHeaderCellMarker) : null;
foreach (var column in tableColumns.Columns)
{
var wholeColumnRange = cursor.Worksheet.GetRange(cursor.RowNumber, cursor.MaxRowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
// ReSharper disable once PossibleNullReferenceException
var dataCellsRange = topLeftDataCellReference == null
? null
: cursor.Worksheet.GetRange(topLeftDataCellReference.RowNumber, bottomRightNonSummaryDataCellReference.RowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
var lastHeaderCellToLastNonSummaryDataCellRange = bottomRightHeaderCellReference == null
? null
: dataCellsRange == null
? null
: cursor.Worksheet.GetRange(bottomRightHeaderCellReference.RowNumber, bottomRightNonSummaryDataCellReference.RowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
// Individual column format will override the format applied to all table columns,
// that's why we first apply the table columns format and then the individual column's format.
wholeColumnRange.ApplyColumnFormat(dataCellsRange, lastHeaderCellToLastNonSummaryDataCellRange, tableColumns.ColumnsFormat);
wholeColumnRange.ApplyColumnFormat(dataCellsRange, lastHeaderCellToLastNonSummaryDataCellRange, column.Format);
cursor.MoveRight();
}
cursor.ResetColumn();
}
// Add rows
cursor.AddTableRows(treeTable.TableRows, context, passKind);
}
private static void AddTableRows(
this CellCursor cursor,
TableRows tableRows,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (tableRows == null)
{
return;
}
cursor.AddHeaderRows(tableRows.HeaderRows, context, passKind);
cursor.AddDataRows(tableRows.DataRows, context, passKind);
cursor.AddFooterRows(tableRows.FooterRows, context, passKind);
}
public AsposeCellsDummyFactory()
{
AutoFixtureBackedDummyFactory.AddDummyCreator(() =>
{
// can't use General.CreateStandardWorkbook because it will throw without a license.
var workbook = new Workbook();
General.EnsureSizingOperationsHonorPixelsSpecified();
var result = workbook.Worksheets[0];
return(result);
});
AutoFixtureBackedDummyFactory.AddDummyCreator(() =>
{
var result = new CellCursor(A.Dummy <Worksheet>(), A.Dummy <PositiveInteger>(), A.Dummy <PositiveInteger>());
return(result);
});
}
private static void AddHeaderRows(
this CellCursor cursor,
HeaderRows headerRows,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (headerRows == null)
{
return;
}
if (headerRows.Rows.Any())
{
for (var x = 0; x < headerRows.Rows.Count; x++)
{
cursor.ResetColumn();
cursor.MoveDown();
if ((x == 0) && (passKind == PassKind.Data))
{
cursor.AddMarker(TopLeftHeaderCellMarker);
}
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyHeaderRowsFormat(headerRows.Format);
}
cursor.AddFlatRow(headerRows.Rows[x], context, passKind);
}
if (passKind == PassKind.Data)
{
cursor.AddMarker(BottomRightHeaderCellMarker);
}
}
}