0

How can I append object[, ] data in Excel using EPPlus? I'm using the following code but it returns System.Object as the result in Excel. 

object[,] rowdate = new object[dt.Rows.Count, Nodes.Split(',').Length * 2 + 4];
ExcelRange _excelRange = _excelSheet.Cells[excelRange];
 _excelRange.Value = rowdate;
Jansi Rani
  • 1
  • 3
  • 2
    Welcome to SO Jansi. To help others help you, you need to provide little more details and show a verifiable code. Please read [ask] and [mcve]. – Arghya C Dec 09 '15 at 11:08
  • 1
    Setting the value of a range probably applies that value to all cells in that range. Looks like you'll just have to use a loop. – Pieter Witvoet Dec 09 '15 at 11:11
  • Hi, I'm adding the values into rowdate by looping and i needs to append the entire rowdate[, ] object into excel with the desired range. can any else option used than loop? – Jansi Rani Dec 09 '15 at 11:32
  • Yes. I have achieved this with looping. Thanks for your comments – Jansi Rani Dec 14 '15 at 11:11

0 Answers0