Writing a string list to excel using a range C#

Question

I have an excel range:

   Excel.Range range = Worksheet.get_Range("A1","A7");

And a string list:

// The list contains the same amount of elements as cells in the range
List<string> AcollumnValues = getList();

My code so far:

        Excel.Application App = new Excel.Application();
        Excel.Workbook Workbook = App.Workbooks.Open(sourceASettings["file"]);
        Excel._Worksheet Worksheet = Workbook.Sheets[1];


        Excel.Range range = Worksheet.get_Range("A1","A4") userSupliedRangeArray[1]);
        List<string> valuesToWrite = getValuesToWrite();

How can I write the string list to the excel using the range?

Maybe there's a way of doing it directly, but you can iterate through the list and write the values one by one . — sagi
– sagi, Commented Oct 3, 2018 at 9:45
If you are able to use EPPlus you might be able to use LoadFromCollection — user9401448
– user9401448, Commented Oct 3, 2018 at 9:48
Found an example of EPPlus LoadFromCollection stackoverflow.com/questions/34882275/… — user9401448
– user9401448, Commented Oct 3, 2018 at 9:53
I second using EPPlus. Makes working with Excel files a lot easier — trailmax
– trailmax, Commented Oct 3, 2018 at 9:53

sagi · Accepted Answer · 2018-10-03 09:51:06Z

2

You'll maybe need to adjust this and fix some minor issues, but it should do the trick (Uses EPPlus):

int counter = 1;
foreach (string str in AcollumnValues) {
   worksheet.Cells["A" + counter].Value = str;
   counter++;
}

answered Oct 3, 2018 at 9:51

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing a string list to excel using a range C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related