Freeze Rows In Excel

by ssi 13. January 2016 08:13
wb.PrintHCenter = true;
      int nTopFreezeRow = 0;
      int nIgnore = 0;
      int nBottomFreezeRow = 4;
     string stest = "$1:$3,$C:$C";
      stest = string.Format("${0}:${1},${2}:${2}", 1,   nBottomFreezeRow, "C"); //must  be 1
      wb.PrintTitles = stest; //Not  sure  about the $C:$C part
      wb.freezePanes(nTopFreezeRow, nIgnore, nBottomFreezeRow, nIgnore, false);
 
      if (BigPaper)
          wb.setPrintPaperSize((int)(8.5 * 1440), (int)(14 * 1440));
      RangeStyle rs = wb.getRangeStyle();

Tags: , , ,

CSharp | SmartXLS

Add comment

biuquote
  • Comment
  • Preview
Loading

Calendar

<<  July 2025  >>
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

View posts in large calendar

RecentComments

None

Development Team @ Shelbysys

We develop custom database applications for our clients. Our development tool of choice is MS Visual Studio. 

Quotations

"Courage is fear holding on a minute longer"
General George Patton Jr