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