Creating Excel spreadsheet from C#

Question

First timer to c-sharpcorner   From a visual studio C# solution  I need to create an Excell spreadsheet from an array int [] [] 512x512.

roman kris · Answer

Hope this will help you. Before going to create new Excel file programmatically in C#, you must have Excel installed on your system for this code to run properly.   http://csharp.net-informations.com/excel/csharp-create-excel.htm

Steven Peterson · Answer

You can use ZetExcel, It is easy to use and very handy

Bidyasagar Mishra · Answer

Hi , Go through the below link . you will get crud application of excel using c#  https://www.c-sharpcorner.com/article/create-update-delete-and-reading-the-excel-file-in-c-sharp/

Leon D · Answer

You can use Free Spire.XLS library to easily create an excel from an array by using sheet.InsertArray method.   https://www.e-iceblue.com/Introduce/free-xls-component.html  (Also available on NuGet) Workbook workbook =  new  Workbook();   workbook.CreateEmptySheets(1);      Worksheet sheet = workbook.Worksheets[0];      int  maxRow = 10000;   int  maxCol = 200;      object [,] myarray =  new   object [maxRow + 1, maxCol + 1];   bool [,] isred =  new   bool [maxRow + 1, maxCol + 1];   for  ( int  i = 0; i  for  ( int  j = 0; j  {       myarray[i, j] = i + j;        if  (( int )myarray[i, j] > 8)       isred[i, j] =  true ;   }      sheet.InsertArray(myarray, 1, 1);      workbook.SaveToFile( "test.xls" ,ExcelVersion.Version97to2003);

Priyanka Jain · Answer

Please refer below link   https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Set-an-Array-of-Values-into-a-Range-in-Excel-Worksheet.html    https://brandewinder.com/2010/10/17/Write-data-to-an-Excel-worksheet-with-C-fast/

Amit Gupta · Answer

You can use Interop.Excel or oledb to read/write on an excel sheet (OleDB is recommended because it is much faster than Interop   http://dotnetstep.blogspot.com/2012/05/create-and-read-excel-file-using-oledb.html