Accessing Page Number On A sheet

[Mohammad]

Hi ,

Q1. If I want to Put some information On page number 2 , How I can access a page by C# code?

Q.2 Or If I want to add a new page to the entier work sheet , I want to know the page number How I can do this by c# code.

[Administrator]

Hi Mohammad,

Here is some code snippet with comments

IWorkbook myWorkbook = excelEngine.Excel.Workbooks.Create(1);

//Accessing first sheet
IWorksheet mySheetOne = myWorkbook.Worksheets[0];
mySheetOne.Range["A1"].Text = "One";

//Insert one more sheet
myWorkbook.Worksheets.Create();

//Accessing second sheet[Newly added sheet]
IWorksheet mySheetTwo = myWorkbook.Worksheets[1];

mySheetTwo.Range["A1"].Text = "Two";

http://www.syncfusion.com/support/user/uploads/insertingpages.zip

Let me know if you have any questions.

Thanks,

Stephen.

>Hi ,
>
>Q1. If I want to Put some information On page number 2 , How I can access a page by C# code?
>
>Q.2 Or If I want to add a new page to the entier work sheet , I want to know the page number How I can do this by c# code.
>