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();