Setting IXLSheet.SplitPosition succeeds in code but has no effect on the exported spreadsheet. Have tried with various values without success.
The SplitPosition value persists right up to the moment the sheet goes out of scope (End Using) but the exported spreadsheet never has frozen columns or rows. I am simply trying to freeze the top few rows.