Creat Excel spreadsheet with WPF

Question

I need create excel spreadsheet with WPF.

I have a problem with DataGrid - creating rows and columns grammatically.

Can you help me with it?

May be you seen some similar open source applications? I interesting how realize it....

 

Thank you in advance!

Answer 1

Hi DioNNiS,

There is a .Net solution to create an exce sheet, not limitation to WPF. So we can use the same method in the general .Net application development.

 The following sample introduces how to use COM Interop to create an Excel Spreadsheet: http://msdn.microsoft.com/en-us/library/ms173186(VS.80).aspx

And other samples: http://www.c-sharpcorner.com/UploadFile/ggaganesh/CreateExcelSheet12012005015333AM/CreateExcelSheet.aspx

Perhaps, you need take a look at Office Development in Visual Studio: http://msdn.microsoft.com/en-us/library/d2tx7z6d.aspx

Sincerely,

Bob Bao

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

You can also create a .csv file and just rename to .xls and Excel will handle that just fine if you're not concerned about formatting.