How to insert a collection directly into cells of xlsx file in WPF?

[Srinivas]

Is direct insertion possible??

[Petya]

Hello Srinivas,

While there is no out of the box method that would do this for you, inserting the entries of a collection should be pretty straightforward if you enumerate over the collections. For example, the next snippet inserts the entries from the myData collection in the first column (A) of the active worksheet.

List<string> myData = new List<string>() { "test", "TEST", "123" };

for (int i = 0; i < myData.Count; i++)
{
    this.radSpreadsheet.ActiveWorksheet.Cells[i, 0].SetValue(myData[i]);
}

I hope this is useful.

Regards,
Petya
Telerik

 

 

[Srinivas]

What you said is valid.. but...
When I write this code​
Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;

and append yours.I am getting output as xls file but I want xlsx file.

[Petya]

Hello Srinivas,

I'm not sure what you mean. The code you sent seems to use the Microsoft Office Interop assemblies, while my suggestion and the section where this forum thread is are related to the RadSpreadsheet control which is part of the Telerik UI for WPF suite. Are you using the component in your application? If you are, please provide more details on the issue which you are experiencing.

Regards,
Petya
Telerik