Two Dimensional array to Excel Spreadsheet

Question

Hi I have a 2 dimensional array  I want to convert it to an Excel document using C# . Any clue!

Jack Baker · Answer

If you want to write Excel file in C# try Excel Jetcell .NET component. http://www.devtriogroup/ExcelJetcell It read write excel XLSX XLS files. Very easy in use API function set + C# examples. See C# code to write an array to Excel file: using DTG.Spreadsheet; ... ExcelWorkbook Wbook = new ExcelWorkbook(); Wbook.Worksheets.Add(Excelarray); for (int i = 0; i for (int j = 0; j { Wbook.Worksheet[0].Cells[ij].Value = arr[ij]; } Wbook.WriteXLSX(@ExcelSpreadsheet.xlsx);

harry peter · Answer

You can do this using Spire.XLS just one line of code. call method insertarray http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

Roy S · Answer

You can do that with something called Excel automation more info here: http://support.microsoft.com/kb/302084 Or you could use gembox.spreadsheet which is faster (266 times faster) easier to use and just better: http://www.gemboxsoftware.com/GBSpreadsheet.htm