Displaying arraylist in Microsoft Excel

Question

How can i display created arraylist in ms excel? Please guide me..

Do you need assistance on how to write some value to an excel file? — Marco
– Marco, Commented Oct 18, 2011 at 8:46
@Marco..ya i created an arraylist but i have to display that arraylist in excel sheet..is it possible?if yes kindly let me know? — Satya
– Satya, Commented Oct 18, 2011 at 8:47

Marco · Accepted Answer · 2011-10-18 08:55:08Z

1

Add a reference to Microsoft.Office.Interop.Excel assembly.
Then try this (just an idea, not full and perfect code):

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excel = new Excel.Application();
Excel.Workbook wb = excel.Workbooks.Open("filename");
Excel.Worksheet sh = wb.Sheets[1]; // or wb.Sheets["name"]
int row = 2;
foreach (string item in array)
{
    sh.Cells[row,col].Value2 = item;
    row++;
}
wb.Save();
wb.Close();
excel.Quit();

answered Oct 18, 2011 at 8:55

Marco

57.7k15 gold badges135 silver badges159 bronze badges

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

5 Comments

Satya Over a year ago

I did :) once again Thanks for the answer Marco :)

Satya Over a year ago

@Marco..Now i need to get a window asking me where to save on disk ?

Marco Over a year ago

@Satya: you have to study a little bit, because this is a really basic action!! Anyway, create a SaveFileDialog and call it dlgSave and use if (dlgSave.ShowDialog() == DialogResult.OK) dlgSave.Filename...

Satya Over a year ago

Marco but the thing is I want Web application not the windows application?savefileDialog is for win app i guess?

Marco Over a year ago

@Satya: check this link: it's in italian, but solutions is there

Collectives™ on Stack Overflow

Displaying arraylist in Microsoft Excel

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related