Posted 8 September 2017, 2:31 pm EST
I need to open an Excel file, show only the first sheet and put the first row into the column headers. This is a C# (VS2008 project).
I've tried to use fpSpread1.OpenExcel() and fpSpread1.ActiveSheet.OpenExcel(). It seems that using fpSpread1.ActiveSheet.OpenExcel(), I can open the correct worksheet but not populate the column titles. If I use fpSpread1.OpenExcel(), I can populate the column titles but it opens all sheets.
Is there a way to do both?
I also noticed that the only way to populate the column headers are with a frozen row. Is there any other way to do this?