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.
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
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.
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
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