public void FillDataHorizon <T>(List <T> listData, VTVector firstPosition, int length = 0)
{
if (listData != null)
{
if (length <= 0 || listData.Count <= length)
{
for (int i = 0; i < listData.Count; i++)
{
SetCellValue(firstPosition + new VTVector(0, i), listData[i]);
}
}
else
{
IRange range = Worksheet.Range[firstPosition.X, firstPosition.Y, firstPosition.X, firstPosition.Y + length - 1];
range.Merge();
range.ShrinkToFit = true;
StringBuilder data = new StringBuilder("");
for (int i = 0; i < listData.Count; i++)
{
data.Append(listData[i]);
if (i != listData.Count)
{
data.Append(" ");
}
}
SetCellValue(firstPosition, data);
}
}
}
public void SetCellValue(VTVector vector, object value)
{
SetCellValue(vector.X, vector.Y, value);
}
public void CopyPasteSameSize(IVTRange range, string cell)
{
VTVector vec = new VTVector(cell);
CopyPasteSameSize(range, vec.X, vec.Y);
}