Sheet names in Excel documents

new user Replied

8/28/2019 at 10:06 AM

Is there any way we can have it implemented? Or giving us event hook to implement desired functionality? This is pressing issue for our customers, as it's extremely difficult to review large Excels without knowing what sheet you are looking on

Cem Alacayir Replied

9/13/2019 at 8:40 AM

Employee Post

This is now possible with new version:

Version 4.9.0 - September 12, 2019

Added: RenderLeftHeader, RenderCenterHeader, RenderRightHeader, RenderLeftFooter, RenderCenterFooter and RenderRightFooterproperties to SpreadsheetInputOptions. Please refer to updated docs for special script and format codes that can be used forheader or footer strings. For example, "&A" prints the name of the workbook tab (worksheet name).

For viewer, you can use it like this:

documentViewer.InputOptions.Add(
  new SpreadsheetInputOptions
  {
    RenderLeftHeader = "Sheet name: &A"
  }
);

Or for converter like this:

var inputOptions = new SpreadsheetInputOptions
{
  RenderLeftHeader = "Sheet name: &A"
};

DocumentConverter.Convert(inputDocument, inputOptions, outputDocument);

The following special script and format codes can be included as a part of the header and footer properties:

Script code	Description
&D	Prints the current date.
&T	Prints the current time.
&F	Prints the name of the document.
&A	Prints the name of the workbook tab (worksheet name).
&P	Prints the page number.
&P+number	Prints the page number plus the specified number. E.g. &P+1
&P-number	Prints the page number minus the specified number.E.g. &P-1
&&	Prints a single ampersand.
&N	Prints the total number of pages in the document.
&Z	Prints the file path.

Format code	Description
&E	Turns double-underline printing on or off.
&X	Turns superscript printing on or off.
&Y	Turns subscript printing on or off.
&B	Turns bold printing on or off.
&I	Turns italic printing on or off.
&U	Turns underline printing on or off.
&S	Turns strike-through printing on or off.
&"font-name"	Prints the characters that follow in the specified font. Be sure to include the double quotation marks. E.g. &"Arial", &"Arial,Bold"
&nn	Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points. E.g. &14
&color	Prints the characters in the specified color. User supplies a hexadecimal color value. E.g. &FF0000 (red)

Reference:

https://docs.gleamtech.com/documentultimate/html/P_GleamTech_DocumentUltimate_SpreadsheetInputOptions_RenderLeftFooter.htm

new user Replied

10/15/2019 at 3:06 PM

it's causing the issues when Excel have it's own header already. Basically, 2 headers overlap each other

3 Replies

Reply to Thread

Related Knowledge Base Articles

3 Replies

Reply to Thread

Tags

Related Knowledge Base Articles