Guriddo » Topic: Export Excel on summary data footer

Export Excel on summary data footer

Guriddo
export excel summary footer
Export Excel on summary data footer

Tagged: export excel summary footer

This topic has 1 reply, 2 voices, and was last updated 10 years, 4 months ago by guriddo.support.

Creator

Topic

November 25, 2015 at 5:46 am #124585

ariadrianto

Participant

Hi…

I’m using adodb JqSuitePHP .

I’ve maintain for export excel manually, by eliminating summary footer. If not, export excel contains damage file.


$grid-&gt;setGridOptions(array(&quot;rowNum&quot;=&gt;99999,&quot;rowList&quot;=&gt;array(10,20,30),&quot;sortname&quot;=&gt;&quot;NOID&quot;, &quot;height&quot;=&gt;&#039;300&#039;,
&quot;footerrow&quot;=&gt;true,
&quot;userDataOnFooter&quot;=&gt;true,
&quot;autowidth&quot;=&gt;true,
&quot;shrinkToFit&quot;=&gt;false,
&quot;width&quot;=&gt;1000

));

$grid-&gt;setFilterOptions(array(&quot;stringResult&quot;=&gt;true));
$grid-&gt;setExcelOptions(array(
&quot;file_type&quot;=&gt;&quot;Excel5&quot;,
&quot;file&quot;=&gt;&quot;LKH.xls&quot;,
&quot;start_cell&quot; =&gt; &quot;A1&quot;,
&quot;font&quot;=&gt;&quot;Arial&quot;,
&quot;font_size&quot;=&gt;11,
&quot;header_title&quot;=&gt;&quot;Laporan Kas Bank Harian&quot;,
&quot;protect&quot; =&gt; false,

));
$grid-&gt;exportfile = &#039;LKH.xls&#039;;

$summaryrows = array(&quot;MASUK&quot;=&gt;array(&quot;MASUK&quot;=&gt;&quot;SUM&quot;), &quot;KELUAR&quot;=&gt;array(&quot;KELUAR&quot;=&gt;&quot;SUM&quot;));

if ($grid-&gt;oper == &#039;excel&#039;) {
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, null, null, true,true);
}
else {
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, $summaryrows, null, true,true);
}

$grid->setGridOptions(array("rowNum"=>99999,"rowList"=>array(10,20,30),"sortname"=>"NOID", "height"=>'300',

"footerrow"=>true,

"userDataOnFooter"=>true,

"autowidth"=>true,

"shrinkToFit"=>false,

"width"=>1000

));

$grid->setFilterOptions(array("stringResult"=>true));

$grid->setExcelOptions(array(

"file_type"=>"Excel5",

"file"=>"LKH.xls",

"start_cell" => "A1",

"font"=>"Arial",

"font_size"=>11,

"header_title"=>"Laporan Kas Bank Harian",

"protect" => false,

));

$grid->exportfile = 'LKH.xls';

$summaryrows = array("MASUK"=>array("MASUK"=>"SUM"), "KELUAR"=>array("KELUAR"=>"SUM"));

if ($grid->oper == 'excel') {

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

}

else {

$grid->renderGrid('#grid','#pager',true, $summaryrows, null, true,true);

}

Working fine without any summary rows,here is the result when using summary row :

summary field

https://drive.google.com/file/d/0B–Rb9zkH1bKTmZzSDBUSUt0eEE/view?usp=sharing

Thanks

This topic was modified 10 years, 4 months ago by ariadrianto. Reason: link picture

Creator

Topic

Viewing 1 replies (of 1 total)

Author

Replies
November 25, 2015 at 11:07 am #124588

guriddo.support
Participant

Hello,

Thanks. we will test this and let you know.

Kind Regards

Will

Guriddo Support Team
Author

Replies

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Export Excel on summary data footer

Search Forum

Recent Replies

Forum Statistics

UserOnline