Excel interop, what page a certain cell is?

rjgagui

Member
Joined
Nov 5, 2014
Messages
18
Programming Experience
Beginner
hi guys,
can you help with my problem on formating my excel report.
this is what i want to do..

1. i will load records from database to excel .
2. if a certain row is identical to previous then the cell will no be added (specific column only not entire row.)


my problem is if ever the last row of the previous page is identical to the value of column in the 1st row of the current page , the column value is not added since it is identical to previous.

is there a way to know on what page a certain cell is???

i can do this using CRYSTAL REPORT but i'm required to do it on excel.

please help guys. thanks in advance..
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,520
Location
Norway
Programming Experience
10+
Top Bottom