Freeze/lock first row in datatables excel export file

Freeze/lock first row in datatables excel export file

sramer123sramer123 Posts: 2Questions: 1Answers: 0

Hi, is it possible to freeze/lock first row in datatables excel export file? Any built-in option or custom code?

Answers

  • colincolin Posts: 8,013Questions: 0Answers: 1,348

    Do you mean you want to create a new row to go at the start of the file? Or do you want a specific row in the table to go to the top?

    Colin

  • sramer123sramer123 Posts: 2Questions: 1Answers: 0

    I mean exacly the "Freeze Top Row" function from excel (screenshot),

  • colincolin Posts: 8,013Questions: 0Answers: 1,348

    You would need to understand that XML format for the spreadsheet for that, that's beyond what's offered in the standard options.

    Colin

Sign In or Register to comment.