setting one worksheet cell range reference to another worksheet

[erkapilbhatia]

I want to set one worksheet cell range reference to another worksheet using aspose.cells.For example i have two worksheet(wrk1 and wr2). I have some data on wrk1 and wrk2 is balnk.Now on wrk2 i want cells refrence of wrk1(like want cell reference of wrk1 sheet A1:A10 on wrk2 with same style as on wrk1) .
Please suggest.

 

[Jerry Sullivan]

Welcome to the board,

Could you clarify this a bit?

Do you want the formulas in wrk2 to be like this...
Cell A1: =wrk1!A1
Cell A2: =wrk1!A2
Cell A3: =wrk1!A3

Do you want this referencing of cells to cover the entire used range in wrk1 or just relating to cells in wrk1 that are not blank?