Display Excel Spreadsheet in WinForms, C# -

i have been struggling last few hours trying excel spreadsheet/workbook displayed on windows form using visual studio 2012, c#. can retrieve data workbook , display on form, need functionality of excel in application, including stuff filtering, conditional formatting, formulas, etc.

i have read quite lot, , understand it, there no controls in visual studio embed these (office) files due licencing, makes sense. have found solution though, display file in webcontrol (i sure able work this), when try load excel file in web control, prompts user either open or save file, , when 'open file' chosen, file opened using microsoft excel.

as understand it, happens because contenttype (mime type, excel contenttype) of file needs set in browser (i need more research on not yet familiar concept, ).

the resources using:

• logic save contents excel file: epplus
• i working following project, among others: winforms excel example

the latter want achieve, keeps on asking save or open file, rather displaying in webcontrol

any on matter appreciated.

use datagridview , program functionnality if doesn't have it! or use excel com create instance of excel.