How to freeze the header row in an Excel spreadsheet exported from ASP.NET

I’m exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I’m really trying to avoid using a 3rd party Excel plugin for this, but unless there’s some archaic excel markup in my AddExcelStyling function.

Importing New Posts from Live Site into Local Dev Site

I’m currently developing an updated version of a live site in a local environment. It’s a very large site and the local dev site is using a entirely new theme without many of the live site’s plugins or functionality. The live site uses Avada Fusion and almost all content is wrapped in shortcodes forcing me to basically re-publish each post manually using the dev site’s new setup (using ACF Pro, custom fields). I’ve spent weeks removing the live site theme, unnecessary thumbnails, plugins, and all sorts of space hogging files. The only problem is bringing in the new posts from the live site. They are adding new posts weekly and I’m about 25 behind. 🙂