I have this code:
List<wert> tempWerte = ...;
#region Tabelle füllen
int columnCounter = 1;
foreach (wert item in tempWerte)
{
//for (int i = 0; i < item.Werte.Length; i++)
//{item.Werte[i]}
worksheet.ImportArray(item.Werte, 1, columnCounter, true);
columnCounter++;
}
#endregion
#region Formatierung
int startRow = 1;
int startColumn = 1;
IRange usedRange = worksheet.UsedRange;
for (int i = startColumn; i <= usedRange.LastColumn; i++)
{
usedRange[startRow, i].CellStyle.Font.Bold = true;
usedRange[startRow, i].BorderAround(LineStyle.Thin);
}
usedRange.CellStyle.Font.FontName = "verdana";
usedRange.CellStyle.Font.Size = 10;