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

<<  May 2024  >>
MoTuWeThFrSaSu
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

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

"A woman's guess is much more accurate than a man's certainty."
Rudyard Kipling