public static void DataToColumnHead(DataRow[] drs, Worksheet sheet, int StartRow, int StartCol, int ColHeight, int ColWidth, string[,] Fields, ref int RowNum)
{
if ((drs.Length != 0) && (Fields != null))
{
int num = StartRow;
int num2 = StartCol;
int length = drs.Length;
for (int i = 0; i < length; i++)
{
DataRow dr = drs[i];
for (int j = 0; j < ColHeight; j++)
{
for (int k = 0; k < ColWidth; k++)
{
string columnName = Fields[j, k];
if ((columnName != null) && (columnName.Trim() != ""))
{
Excel.Range range = TExcel.GetCell(sheet, num + j, num2 + k);
try
{
string str;
if (((str = columnName.ToUpper()) != null) && (string.IsInterned(str) == "@@ROWNUM"))
{
RowNum++;
range.Value = (int)RowNum;
}
else
{
range.Value = TExcel.GetItemValue(dr, columnName, false);
}
}
catch
{
}
finally
{
TExcel.DisposeObject(range);
}
}
}
}
num2 += ColWidth;
}
}
}