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