Luis Vagner Postado Outubro 2, 2009 Denunciar Share Postado Outubro 2, 2009 Pessoal tenho esse seguinte script do componente slgrid, esse script é responsável por criar um arquivo excel com os dados, alguém poderia me ajudar informando como coloco uma imagem jpg no arquivo excel que é criado?<?php // ***************************************************************************** // * slGrid 2.0 * // * [url=http://slgrid.senzalimiti.sk]http://slgrid.senzalimiti.sk[/url] * // * * // * Copyright © 2006 Senza Limiti s.r.o. * // * * // * This program is free software; you can redistribute it and/or * // * modify it under the terms of the GNU General Public License * // * as published by the Free Software Foundation; either version 2 * // * of the License, or (at your option) any later version. * // * * // * This program is distributed in the hope that it will be useful, * // * but WITHOUT ANY WARRANTY; without even the implied warranty of * // * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * // * GNU General Public License for more details. * // * * // * For commercial licenses please contact Senza Limiti at * // * - [url=http://www.senzalimiti.sk]http://www.senzalimiti.sk[/url] * // * - info(at)senzalimiti.sk * // ***************************************************************************** set_time_limit(0); define("GRID_SOURCE", "./"); include("class/gridclasses.php"); //Include the grid engine. session_start(); $grid_id = $_GET["grid_id"]; header('Content-Type: application/vnd.ms-excel'); header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT'); $table_name = ""; if ($_SESSION[$grid_id]->sql_table_override != "") $table_name = $_SESSION[$grid_id]->sql_table_override; else $table_name = $_SESSION[$grid_id]->sql_table; header('Content-Disposition: attachment; filename="' . $table_name . '.xls"'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: no-cache'); ?> <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-type" content="text/html;charset=<?php echo isset($charset_of_file) ? $charset_of_file : $charset; ?>" /> <style id="Classeur1_16681_Styles"> </style> </head> <body> <div id="Classeur1_16681" align=center x:publishsource="Excel"> <table x:str border=1 cellpadding=0 cellspacing=0 width=100% style='border-collapse: collapse'> <?php $schema_insert = '<tr>'; foreach ($_SESSION[$grid_id]->columns as $objColumn) { if ($objColumn->show == true) { if ($objColumn->user_defined_name != "") $column_name = $objColumn->user_defined_name; else $column_name = $objColumn->name; $schema_insert .= '<td class=xl2216681 nowrap><b>' . htmlspecialchars($column_name) . '</b></td>'; } } $schema_insert .= "</tr>\n"; if ($_SESSION[$grid_id]->database->Connect() == false) { return "Could not connect to database..."; } $rows = $_SESSION[$grid_id]->database->GetRows($_SESSION[$grid_id]->sql_columns, $_SESSION[$grid_id]->sql_table, $_SESSION[$grid_id]->sql_where, $_SESSION[$grid_id]->columns[$_SESSION[$grid_id]->order_column_index]->name, $_SESSION[$grid_id]->columns[$_SESSION[$grid_id]->order_column_index]->is_asc_order, ""); while ($row = mysql_fetch_array($rows, MYSQL_ASSOC)) { $schema_insert .= '<tr>'; while(list($key, $val) = each($row)) { if(!isset($_SESSION[$grid_id]->user_defined_columns[$key]) || $_SESSION[$grid_id]->user_defined_columns[$key]->show != false) $schema_insert .= "<td class=xl2216681 nowrap> " . htmlspecialchars($val) . '</td>'; } $schema_insert .= "</tr>\n"; } print($schema_insert); ?> </table> </div> </body> </html> Citar Link para o comentário Compartilhar em outros sites More sharing options...
Pergunta
Luis Vagner
Pessoal tenho esse seguinte script do componente slgrid, esse script é responsável por criar um arquivo excel com os dados, alguém poderia me ajudar informando como coloco uma imagem jpg no arquivo excel que é criado?
<?php // ***************************************************************************** // * slGrid 2.0 * // * [url=http://slgrid.senzalimiti.sk]http://slgrid.senzalimiti.sk[/url] * // * * // * Copyright © 2006 Senza Limiti s.r.o. * // * * // * This program is free software; you can redistribute it and/or * // * modify it under the terms of the GNU General Public License * // * as published by the Free Software Foundation; either version 2 * // * of the License, or (at your option) any later version. * // * * // * This program is distributed in the hope that it will be useful, * // * but WITHOUT ANY WARRANTY; without even the implied warranty of * // * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * // * GNU General Public License for more details. * // * * // * For commercial licenses please contact Senza Limiti at * // * - [url=http://www.senzalimiti.sk]http://www.senzalimiti.sk[/url] * // * - info(at)senzalimiti.sk * // ***************************************************************************** set_time_limit(0); define("GRID_SOURCE", "./"); include("class/gridclasses.php"); //Include the grid engine. session_start(); $grid_id = $_GET["grid_id"]; header('Content-Type: application/vnd.ms-excel'); header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT'); $table_name = ""; if ($_SESSION[$grid_id]->sql_table_override != "") $table_name = $_SESSION[$grid_id]->sql_table_override; else $table_name = $_SESSION[$grid_id]->sql_table; header('Content-Disposition: attachment; filename="' . $table_name . '.xls"'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: no-cache'); ?> <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-type" content="text/html;charset=<?php echo isset($charset_of_file) ? $charset_of_file : $charset; ?>" /> <style id="Classeur1_16681_Styles"> </style> </head> <body> <div id="Classeur1_16681" align=center x:publishsource="Excel"> <table x:str border=1 cellpadding=0 cellspacing=0 width=100% style='border-collapse: collapse'> <?php $schema_insert = '<tr>'; foreach ($_SESSION[$grid_id]->columns as $objColumn) { if ($objColumn->show == true) { if ($objColumn->user_defined_name != "") $column_name = $objColumn->user_defined_name; else $column_name = $objColumn->name; $schema_insert .= '<td class=xl2216681 nowrap><b>' . htmlspecialchars($column_name) . '</b></td>'; } } $schema_insert .= "</tr>\n"; if ($_SESSION[$grid_id]->database->Connect() == false) { return "Could not connect to database..."; } $rows = $_SESSION[$grid_id]->database->GetRows($_SESSION[$grid_id]->sql_columns, $_SESSION[$grid_id]->sql_table, $_SESSION[$grid_id]->sql_where, $_SESSION[$grid_id]->columns[$_SESSION[$grid_id]->order_column_index]->name, $_SESSION[$grid_id]->columns[$_SESSION[$grid_id]->order_column_index]->is_asc_order, ""); while ($row = mysql_fetch_array($rows, MYSQL_ASSOC)) { $schema_insert .= '<tr>'; while(list($key, $val) = each($row)) { if(!isset($_SESSION[$grid_id]->user_defined_columns[$key]) || $_SESSION[$grid_id]->user_defined_columns[$key]->show != false) $schema_insert .= "<td class=xl2216681 nowrap> " . htmlspecialchars($val) . '</td>'; } $schema_insert .= "</tr>\n"; } print($schema_insert); ?> </table> </div> </body> </html>Link para o comentário
Compartilhar em outros sites
0 respostass a esta questão
Posts Recomendados
Participe da discussão
Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.