Read & Write on Excel file in WPF using C#

Question

User-633378705 posted

Hi all,

I want to write & read data on Excel file from my application and display records into a DataGrid in WPF. 

Excel file should be created at run time if there is no any excel file in the application root path and then create required columns with specific datatype and size. 

And also create new sheet for every month on the same file. Can it be possible at runtime?

How can I do this task, plz help.......

I'll be very thankful..

Thanks....

Answer 1

User1401801381 posted

Hi

For the Excel part you can use a library such as CloseXML (https://closedxml.codeplex.com/) it's really easy to use (check the doc) : you can read,write,create new sheets, etc

To check if the file exist, you can use File.Exists("your path")

Answer 2

User61956409 posted

Hi Tarun,

This article explained how to read and write Data to Excel files with WPF, hoping it will be helpful.

http://www.dotnetcurry.com/wpf/988/read-write-excel-files-using-wpf

Best Regards,

Fei Han