How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-22-2010, 6:47 PM
Hi All

currently working on active report 4.3.0.1261 version

need solution for the below problem:

I used the SpreadBuilder to export a muliti sheets excel file.
I want to set the excel footer to print "page no/ page count",but I didn't found some way to do it.

Thanks in advance.

Highven

Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-23-2010, 5:27 AM
Highven,

The SpreadBuilder API is used to build up a spreadsheet cell by cell. So basically, you would use the code in the Format events of sections to place the report control data into cells. Could you kindly provide me some more information on how exactly you are looking to get the PageNumber on the sheets? As per your description the only way I can think off at the moment is to calculate the number of rows per sheet and set the value for the last cell as the PageNumber for that sheet.

Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics

Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-23-2010, 6:13 PM
Hi,Sankalp

Thanks for your answer.

Please see my problem at the attachment.

Regards,
Highven

Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-23-2010, 11:13 PM
Highven,

Unfortunately it is not clear from the screenshot what exactly you are looking for. The screenshot displays a dialog box with Japanese text on it. Are you looking to access the properties of this dialog box using SpreadBuilder? You have mentioned that you want to print "page no/ page count" on every excel sheet. Unfortunately the screenshot provided by you does not clarify it much. What is the dialog box which you have attached as a screenshot? Any further information provided to narrow down the issue would be appreciated.

Regards,
Sankalp
Sankalp Sen
GrapeCity- DataDynamics

Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-24-2010, 5:33 PM
Sankalp

I'm sorry for my poor English.

I only want to know how can I set the "page number / page count" on the footer of every sheet used SpreadBuilder API.

I know I can set the margin,fitToPage,Zoom,etc with the
DataDynamics.SpreadBuilder.Printing.PageSetup Class. (first screenshot in the attachment)
Unfortunately I didn't find the properties or method of the PageSetup Class that I can set the "page number/ page count" on the footer of excel sheet. (second screenshot in the attachment)

Thanks & Regards,
Highven

Re: How can I set the Excel footer to print "page no/ page count" by every sheet ?

02-26-2010, 3:18 AM
Hello,

When you are exporting to excel using SpreadBuilder, you are accessing the cells of the spreadsheet to write to it with code something like this.

sb.Sheets[0].Cell(1,2).SetValue("(614) 895-3142");

So, you would need to decide which cell you are going to write the pagenumber to; with code as

String s= this.PageNumber.ToString();
sb.Sheets[0].Cell(17,2).SetValue(s);

Regards,
Prantik