How to find Excel Page Break?

[Guest]

I have found on internet to get information how to find cell page break, but
i can't found it. can you help me?

thank you very much

Best Regards
Hasan Widjaya
fujitsu system indonesia
-Analyst Programmer-

 

[NickHK]

Hasan,
Each WS has a .Horizontal/VerticalPageBreaks collection you can enumerate,
each giving details about its type, position etc.

NickHK

 

[Guest]

thanks NickHK, i found this function and i have to try it. but there is some
problems here.

if in one sheet have two pagebreak, there is error while getting the second
row pagebreak.



public string SetPageBreak(int Columns)
{
int xRow;
string RowPage = "";

try
{
for(int i = 1; i <= xlWorksheet.HPageBreaks.Count; i++)
{
xRow = xlWorksheet.HPageBreaks.Location.get_Offset(-1,0).Row;
SetBorder(xRow, 1, xRow, Columns, BorderIndex.EdgeBottom);

RowPage += xRow.ToString() + ",";
}

return RowPage;
}
catch(Exception ex)
{
return RowPage;
}
}

 

[NickHK]

Hasan,
Should you be working with the Vertical PageBreaks, instead of the
Horizontal ?

NickHK

thanks NickHK, i found this function and i have to try it. but there is some
problems here.

if in one sheet have two pagebreak, there is error while getting the second
row pagebreak.



public string SetPageBreak(int Columns)
{
int xRow;
string RowPage = "";

try
{
for(int i = 1; i <= xlWorksheet.HPageBreaks.Count; i++)
{
xRow = xlWorksheet.HPageBreaks.Location.get_Offset(-1,0).Row;
SetBorder(xRow, 1, xRow, Columns, BorderIndex.EdgeBottom);

RowPage += xRow.ToString() + ",";
}

return RowPage;
}
catch(Exception ex)
{
return RowPage;
}
}

Hasan,
Each WS has a .Horizontal/VerticalPageBreaks collection you can enumerate,
each giving details about its type, position etc.

NickHK

break,
but