private static ExcelRange AdjustRangeSize(this ExcelRange range, IListObjectDataObject data)
{
Range topLeft = range.GetLeftTopCell().GetInteropVersion();
var columnAbsoluteIndex = topLeft.Column;
var rowAbsoluteIndex = topLeft.Row;
var columnsWide = data.HeaderValues.Length;
var rowsHeight = data.DataValues.GetLength(yLengthIndex);
Range bottomRight = topLeft.Worksheet.Cells[rowAbsoluteIndex + rowsHeight + NumberOfHeaders - 1, columnAbsoluteIndex + columnsWide - 1]; // -1 reason one base
return(new ExcelRange(topLeft.Worksheet.get_Range(topLeft, bottomRight)));
}
public static ExcelListObject CreateListObject(this ExcelWorksheet worksheet, string leftTopTargetCellAddress, IListObjectDataObject data, string listObjectName)
{
return(worksheet.CreateListObject(worksheet.GetRange(leftTopTargetCellAddress), data, listObjectName));
}
public static ExcelListObject CreateListObject(this ExcelWorksheet worksheet, ExcelRange leftTopTargetCell, IListObjectDataObject data, string listObjectName)
{
return(leftTopTargetCell.CreateListObject(data, listObjectName));
}
private static bool isRangeSizeValid(ExcelRange range, IListObjectDataObject data)
{
return(isRangeSizeValid(range, data.AllValues));
}
public static ExcelRange WriteData(this ExcelRange range, IListObjectDataObject data)
{
range.GetInteropVersion().Value2 = data.AllValues;
return(range);
}
public static ExcelListObject CreateListObject(this ExcelRange range, IListObjectDataObject data, string listObjectName)
{
var workingRange = range.WriteData(data.AllValues);
return(workingRange.ConvertIntoTable(listObjectName));
}
