Hi Srinivasa,
Thank you for using Syncfusion Products
<<<
I have 3 worksheets in an excel that I am creating using IWorkbook. I am in worksheet number and I need to access data from Worksheet # 3 that is already built. So I am doing this:
IWorksheet etfSheet = workbook.Worksheets[2];
IRange etfPercentRange = etfSheet.Range["A6:A3000"];
>>>>
Could you please try with the below sample and let us know if this helps.
<<<<<
I need to access the row #6 on the Worksheet #2 in Worksheet #0. How can I do this?
>>>>>
we cannot access the row #6 on the Worksheet #2 in Worksheet #0, we can access only cells.
We have copied A1 Cell content of Worksheet#2 in Worksheet#0,
Code:
workbook.Worksheets[0].Range["F11"].Text = workbook.Worksheets[0].Range["Sheet3!A1"].Text;
And Other Copy Process
we have copied the row from Worksheet #2 to Worksheet #0
we copied the column from Worksheet #2 to Worksheet #1
Please try this and let us know if you have any questions.
CopySheet2Sheet2049508446.zipRegards
Sathish Babu R