Dump a two-dimensional array into an XLSheet

Dump a two-dimensional array into an XLSheet

Posted by: javier.garcia on 20 January 2022, 2:11 am EST

• 

  javier.garcia

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 January 2022, 2:11 am EST

  Hello, is it possible to dump a two-dimensional array of integers directly into an XLSheet object, or is it necessary to dump the values ​​cell by cell?

  I’ve tried to see if it’s possible using XLCellRange objects, but I haven’t been able to find any information or examples.

  Thank you!

• 

  kartik.sagar

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2022, 11:20 pm EST

  Hi Javier,

  We are sorry but C1Excel doesn’t have provide any method to load a 2d array so you need to do it cell by cell.

  However, you can take a look at our latest excel library which is more feature-rich, faster & customizable as compared to C1Excel. You can download the GrapeCity.Documents.Excel NuGet package to get the library and implement your requirement as follows:

  
  GrapeCity.Documents.Excel.Workbook workbook = new GrapeCity.Documents.Excel.Workbook();
  var array2d = new int[2, 2]
  {
                  {2, 3},
                  {2, 4},
  };
  workbook.ActiveSheet.Range[0, 0, array2d.GetLength(0), array2d.GetLength(1)].Value = array2d;
  
  

  You can refer here for more information regarding our latest excel library.

  https://www.grapecity.com/documents-api-excel

  JFYI, our new excel library is a standalone product so you would need to purchase a license for the same.

  Best Regards,
  
  Kartik

• 

  javier.garcia

  • Post Options:
  • Link
    Copy

  Posted 23 January 2022, 7:47 pm EST

  Hello, thanks for the answer. I’ll take a look at the documentation for the new library you suggest. Thanks a lot.