private int GetIndexEmptyRow(IXLWorksheet worksheet, IXLRows rowUsed, IXLColumns colUsed, int workingRow, int workingCol)
{
int countEmptyCell = 0;
int countCell = 0;
foreach (var col in colUsed)
{
if (col.ColumnNumber() > 1 && col.ColumnNumber() > workingCol)
{
if (common.GetValue(worksheet, workingRow, col.ColumnNumber()) == "")
{
countEmptyCell++;
}
else
{
return(-1);
}
countCell++;
}
}
if (countEmptyCell == countCell)
{
return(workingRow);
}
return(-1);
}
private void CopyColumns(IXLColumns newColumns)
{
foreach (var newColumn in newColumns)
{
var internalColumn = Worksheet.Internals.ColumnsCollection[newColumn.ColumnNumber()];
internalColumn.Width = Width;
internalColumn.InnerStyle = InnerStyle;
internalColumn.Collapsed = Collapsed;
internalColumn.IsHidden = IsHidden;
internalColumn._outlineLevel = OutlineLevel;
}
}
private void CopyColumns(IXLColumns newColumns)
{
foreach (var newColumn in newColumns)
{
var internalColumn = Worksheet.Internals.ColumnsCollection[newColumn.ColumnNumber()];
internalColumn._width = Width;
internalColumn.SetStyle(Style);
internalColumn._collapsed = Collapsed;
internalColumn._isHidden = IsHidden;
internalColumn._outlineLevel = OutlineLevel;
}
}
