KA

How can I set header footer for excel using ARIS script? We get the output of some ARIS scripts in Excel. It will be better if we can set header footer for the same.

by Konstantin Seleznev
Posted on Sun, 04/25/2010 - 18:47

You have to use BeginHeader\BeginFooter and dependent methods in a script code.

0
by Kalimuthu Aruchamy Author
Posted on Fri, 04/30/2010 - 09:05

Thanks for your response Konstantin. I tried
BeginHeader\BeginFooter, OutputLn methods. It did not work for me. Could you please tell me what are the methods we can use inside BeginHeader\BeginFooter.

0
by Volker Eckardt
Posted on Fri, 04/30/2010 - 09:20

Hello Kalimuthu,

in the script help you can find the following:

Starts the report header All subsequent outputs up to the EndHeader command are written in the header.

Example:

var File = Context.createOutputObject();

var image = Context.createPicture("picture.jpg");

File.BeginHeader(); File.BeginTable(100,Constants.C_BLACK,Constants.C_WHITE,Constants.FMT_LEFT,0,true);

File.TableRow();

File.TableCell(" ",20,"Arial",10,Constants.C_BLACK,Constants.C_WHITE,0,Constants.FMT_CENTER,0,C_RED,Constants.BORDER_THIN); File.OutGraphic(image,100,15,15);

File.TableCell(" This is a test report ",60,"Arial",10,Constants.C_BLACK,Constants.C_WHITE,0,Constants.FMT_CENTER,0,Constants.C_RED,Constants.BORDER_THIN);

File.TableCell(" ",20,"Arial",10,Constants.C_BLACK,Constants.C_WHITE,0,Constants.FMT_CENTER,0,Constants.C_RED,Constants.BORDER_THIN);

File.EndTable("TESTSHEET1",100, "Arial",10,Constants.C_BLACK,Constants.C_BLACK,0,Constants.FMT_LEFT,0);

File.EndHeader();

 

Description: Writes a header with graphic in the report. The graphic is loaded from the default path.

Hope this helps!

Best Regards, Volker

0
by Kalimuthu Aruchamy Author
Posted on Fri, 04/30/2010 - 10:12

Thanks for your quick response Volker... I tried it. But still it doesn't work for me. It displays blank.

0
by Volker Eckardt
Posted on Fri, 04/30/2010 - 16:48

In reply to by ivo

Hi Kalimuthu,

the reason might be that you are using text only commands, instead of excel commands.

Can you please check if you get something if you change the output type to PDF?

Regards, Volker

0
by Kalimuthu Aruchamy Author
Posted on Fri, 04/30/2010 - 17:18

I tried it in PDF. It wasn't working in the first attempt. I removed the image and gave only text as Header. Then it worked

0
by Kalimuthu Aruchamy Author
Posted on Mon, 05/03/2010 - 13:40

I want to include Header/footer in Excel. If we go to Excel->View->Header/footer we can have customized header/footer. After setting  it, if we go to File->print preview it will have header/footer on the page. I have shown the sample page here. I have marked (rounded in Red) header / footer for this page.

0
by Volker Eckardt
Posted on Thu, 05/06/2010 - 16:11

Hi Kalimuthu,

it looks to me that perhaps header and footer in Excel are not yet supported. The command set above works,with some smaller changes in PDF, but in Excel it is always blank. Also changing to Output was not much better.

If someone knows how to solve this, please let us know.

Thanks in advance

Volker

0
by Patrick Perrin
Posted on Mon, 03/05/2012 - 17:11

Hi,

Did someone find a solution to insert header and footer text in Excel reports ?

Thanks in advance

Patrick

0
by Palash Nandi
Posted on Mon, 09/17/2012 - 17:20

 

Hi,         I have a Report(.doc and .pdf ) created with Aris Script in which multiple models are described. Details of a Model take a few pages and then the  next model starts.  Now I have to display the name of the current model in the header and when the details of the next model comes, that model name should reflect in the header.   However, it seems the header specific methods( i.e. BeginHeader() and EndHeader() ) are global and do not allow me to dynamically change them from page to page.  If I change them multiple times , even then the last change is reflected.    Is it possible to keep page( one page of a word doc/pdf ) specific changes in the header.   - Thanks and Regards - Palash Nandi  
0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock