We are evaluating the .Cells and .Grid component and I have a few technical questions. We have a very complex model developed in Excel/VBA. We are writing a wrapper application in .Net Winforms to provide some control/flow for inputing data and displaying the results. I need to be able to read data from a specific sheet in excel and load it into the Grid for display. The sample I saw loaded an entire workbook and displayed all sheets.
Here are my questions:
Can the Grid be used to display a single sheet from a workbook instead of all sheets in the workbook?
If only all the sheets can be shown, can sheets be hidden in the grid or excel before showing?
Can the Grid be used to quickly load a range of data from a sheet in an excel workbook?
Can a Grid be marked Read Only to just display results from a sheet calculated in Excel?