Home > Back-end >  How to get all elements from a List
How to get all elements from a List

Time:08-20

I add each day of the current month to a list in a specific format.

public static List<string> GetMonthDays()
{
    DateTime startTime = DateTime.Now;
    DateTime startOfMonth = new DateTime(startTime.Year, startTime.Month, 1);
    int daysInMonth = DateTime.DaysInMonth(startTime.Year, startTime.Month);
    List<string> currentMonth = new List<string>();
    //string[] currentMonth = new string[daysInMonth];
    for (int i = 0; i < daysInMonth;   i) {

        DateTime currentDate = startOfMonth.AddDays(i);
        currentMonth.Add(currentDate.ToString("dddd - dd.MM.yy", 
        CultureInfo.InvariantCulture));              
    }
    return currentMonth;
}

I am currently calling the method as follows, but I can only call a single index. How can I retrieve all the elements from the list?

var monthCurrent = new List<string> { GetMonthDays()[0] };
ws.Cells["A4:A34"].LoadFromArrays(new List<string[]>(new[] { monthCurrent.ToArray() }));

CodePudding user response:

Why not simply:

ws.Cells["A4:A34"].LoadFromArrays(GetMonthDays().ToArray());

Edit: I see, LoadFromArrays takes multiple. Then use LoadFromCollection:

ws.Cells["A4:A34"].LoadFromCollection(GetMonthDays());
  • Related