[RESOLVED] Looking for excel type control (resolved)

[Beast777]

Are there any controls that have similiar functions as excel? My boss loves the idea for scheduling. It basically will have a column on the left with employees names, the next column will be a formula. This formula will the amount of vacation days minus all the days requested. Then 28-31 edittable squares for each month. This gives the boss an easy visual of who's out on what day and what weeks we are low on pers. I thought about a grid but was wondering if anyone has any other ideas.

[jmcilhinney]

You could use a DataGrid, or host an Excel file in a WebBrowser ActiveX control.

[Aspnot]

FarPoint has a nice Spread control if you don't want to use a DataGrid.

[Beast777]

Aspnot - thanks I will look into that control.

Jm - Have you done something like that with an excel spreadsheet? If so, can you give me any examples if possible.

[jmcilhinney]

The WebBrowser control can host any document that IE can (I believe), so it may well need Excel installed on the local system to be able to display an XLS file. If you want to use it just add a control to your form and call Navigate and pass the path to your file.

[Beast777]

Thank you both for your replies. The control is quite excellent and is probably what i will use.

[jmcilhinney]

Just don't forget to mention the price to your boss before incorporating it into your code.