How to find Excel Page Break?
 

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-

How to find Excel Page Break?
 

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

NickHK

"Hasan Widjaya" <Hasan wrote in message
...
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-

How to find Excel Page Break?
 

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[i].Location.get_Offset(-1,0).Row;
SetBorder(xRow, 1, xRow, Columns, BorderIndex.EdgeBottom);

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

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




"NickHK" wrote:

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

NickHK

"Hasan Widjaya" <Hasan wrote in message
...
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-

How to find Excel Page Break?
 

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

NickHK

"Hasan Widjaya" wrote in message
...
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[i]
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" wrote:

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

NickHK

"Hasan Widjaya" <Hasan wrote in
message
...
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-