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?