./admin/user/user_bulk_download.php:echo '
  • '.get_string('downloadexcel').'
  • '; ./admin/user/user_bulk_download.php: require_once("$CFG->libdir/excellib.class.php"); ./admin/cli/install.php://the problem is that we need specific version of quickforms and hacked excel files :-( ./admin/settings/language.php: $temp->add(new admin_setting_configselect('latinexcelexport', get_string('latinexcelexport', 'admin'), get_string('configlatinexcelexport', 'admin'), '0', array('0'=>'Unicode','1'=>'Latin'))); ./course/lib.php: require_once("$CFG->libdir/excellib.class.php"); ./course/lib.php: $formatDate->set_num_format(get_string('log_excel_date_format')); ./course/lib.php: $formatDate->set_num_format(get_string('log_excel_date_format')); ./course/report/log/index.php: case 'downloadasexcel': ./course/report/log/lib.php: 'downloadasexcel' => get_string('downloadexcel')); ./course/report/log/lib.php: 'downloadasexcel' => get_string('downloadexcel')); ./course/report/completion/index.php:$excel = ($format == 'excelcsv'); ./course/report/completion/index.php:$csv = ($format == 'csv' || $excel); ./course/report/completion/index.php: global $excel; ./course/report/completion/index.php: if($excel) { ./course/report/completion/index.php: if($excel) { ./course/report/completion/index.php:
  • '. ./course/report/completion/index.php: get_string('excelcsvdownload','completion').'
  • '; ./course/report/progress/index.php:$excel = $format == 'excelcsv'; ./course/report/progress/index.php:$csv = $format == 'csv' || $excel; ./course/report/progress/index.php: global $excel; ./course/report/progress/index.php: if($excel) { ./course/report/progress/index.php: if($excel) { ./course/report/progress/index.php:
  • '. ./course/report/progress/index.php: get_string('excelcsvdownload','completion').'
  • '; ./grade/export/xls/grade_export_xls.php: require_once($CFG->dirroot.'/lib/excellib.class.php'); ./install.php://the problem is that we need specific version of quickforms and hacked excel files :-( ./lang/en/admin.php:$string['configlatinexcelexport'] = 'Choose the encoding for Excel exports.'; ./lang/en/admin.php:$string['latinexcelexport'] = 'Excel encoding'; ./lang/en/table.php:$string['downloadexcel'] = 'a Microsoft Excel spreadsheet'; ./lang/en/moodle.php:$string['downloadexcel'] = 'Download in Excel format'; ./lang/en/moodle.php:$string['log_excel_date_format'] = 'yyyy mmmm d h:mm'; ./lang/en/completion.php:$string['excelcsvdownload'] = 'Download in Excel-compatible format (.csv)'; ./lang/en/mimetypes.php:$string['application/vnd.ms-excel'] = 'Excel spreadsheet'; ./lib/thirdpartylibs.xml: excel ./lib/zend/Zend/Gdata/Docs.php: 'XLS'=>'application/vnd.ms-excel', ./lib/zend/Zend/Gdata/Docs.php: 'XLSX'=>'application/vnd.ms-excel', ./lib/zend/Zend/Date.php: 'extend_month' => false, // false - addMonth like SQL, true like excel ./lib/zend/Zend/Service/Amazon/S3.php: $content_type = 'application/excel'; ./lib/filelib.php: 'csv' => array ('type'=>'text/csv', 'icon'=>'excel'), ./lib/filelib.php: 'xls' => array ('type'=>'application/vnd.ms-excel', 'icon'=>'excel'), ./lib/filelib.php: 'xlsm' => array ('type'=>'application/vnd.ms-excel.sheet.macroEnabled.12', 'icon'=>'xlsm'), ./lib/filelib.php: 'xltm' => array ('type'=>'application/vnd.ms-excel.template.macroEnabled.12', 'icon'=>'xltm'), ./lib/filelib.php: 'xlsb' => array ('type'=>'application/vnd.ms-excel.sheet.binary.macroEnabled.12', 'icon'=>'xlsb'), ./lib/filelib.php: 'xlam' => array ('type'=>'application/vnd.ms-excel.addin.macroEnabled.12', 'icon'=>'xlam'), ./lib/filelib.php: //No break, for example for 'excel' we don't want 'csv'! ./lib/excellib.class.php: * excellib.class.php ./lib/excellib.class.php: var $pear_excel_workbook; ./lib/excellib.class.php: $this->pear_excel_workbook = new Spreadsheet_Excel_Writer($filename); ./lib/excellib.class.php: if (empty($CFG->latinexcelexport)) { /// Only if don't want to use latin (win1252) stronger output ./lib/excellib.class.php: $this->pear_excel_workbook->setVersion(8); ./lib/excellib.class.php: make_upload_directory('temp/excel'); ./lib/excellib.class.php: $this->pear_excel_workbook->setTempDir($CFG->dataroot.'/temp/excel'); ./lib/excellib.class.php: $ws = new MoodleExcelWorksheet ($name, $this->pear_excel_workbook, $this->latin_output); ./lib/excellib.class.php: $ft = new MoodleExcelFormat ($this->pear_excel_workbook, $properties); ./lib/excellib.class.php: $this->pear_excel_workbook->close(); ./lib/excellib.class.php: $this->pear_excel_workbook->send($filename); ./lib/excellib.class.php: var $pear_excel_worksheet; ./lib/excellib.class.php: $this->pear_excel_worksheet =& $workbook->addWorksheet($name); ./lib/excellib.class.php: $this->pear_excel_worksheet->setInputEncoding('UTF-16LE'); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeString($row, $col, $str, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeNumber($row, $col, $num, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeUrl($row, $col, $url, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeNumber($row, $col, $value, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeFormula($row, $col, $formula, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->writeBlank($row, $col, $format); ./lib/excellib.class.php: $this->pear_excel_worksheet->setRow($row, $height, $format, $hidden, $level); ./lib/excellib.class.php: $this->pear_excel_worksheet->setColumn($firstcol, $lastcol, $width, $format, $hidden, $level); ./lib/excellib.class.php: $this->pear_excel_worksheet->hideGridLines(); ./lib/excellib.class.php: $this->pear_excel_worksheet->hideScreenGridlines(); ./lib/excellib.class.php: $this->pear_excel_worksheet->insertBitmap($row, $col, $bitmap, $x, $y, $scale_x, $scale_y); ./lib/excellib.class.php: $this->pear_excel_worksheet->mergeCells($first_row, $first_col, $last_row, $last_col); ./lib/excellib.class.php: return $format->pear_excel_format; ./lib/excellib.class.php: var $pear_excel_format; ./lib/excellib.class.php: $this->pear_excel_format =& $workbook->addFormat(); ./lib/excellib.class.php: $this->pear_excel_format->setSize($size); ./lib/excellib.class.php: $this->pear_excel_format->setBold($weight); ./lib/excellib.class.php: $this->pear_excel_format->setUnderline($underline); ./lib/excellib.class.php: $this->pear_excel_format->setItalic(); ./lib/excellib.class.php: $this->pear_excel_format->setStrikeOut(); ./lib/excellib.class.php: $this->pear_excel_format->setOutLine(); ./lib/excellib.class.php: $this->pear_excel_format->setShadow(); ./lib/excellib.class.php: $this->pear_excel_format->setScript($script); ./lib/excellib.class.php: $this->pear_excel_format->setColor($color); ./lib/excellib.class.php: $this->pear_excel_format->setFgColor($color); ./lib/excellib.class.php: $this->pear_excel_format->setBgColor($color); ./lib/excellib.class.php: $this->pear_excel_format->setPattern($pattern); ./lib/excellib.class.php: $this->pear_excel_format->setTextWrap(); ./lib/excellib.class.php: $this->pear_excel_format->setAlign($location); ./lib/excellib.class.php: $this->pear_excel_format->setHAlign($location); ./lib/excellib.class.php: $this->pear_excel_format->setVAlign($location); ./lib/excellib.class.php: $this->pear_excel_format->setTop($style); ./lib/excellib.class.php: $this->pear_excel_format->setBottom($style); ./lib/excellib.class.php: $this->pear_excel_format->setLeft($style); ./lib/excellib.class.php: $this->pear_excel_format->setRight($style); ./lib/excellib.class.php: $this->pear_excel_format->setBorder($style); ./lib/excellib.class.php: $this->pear_excel_format->setNumFormat($num_format); ./lib/portfolio/formats.php: mimeinfo_from_icon('type', 'excel', true), ./lib/setup.php://the problem is that we need specific version of quickforms and hacked excel files :-( ./lib/tablelib.php:class table_excel_export_format extends table_spreadsheet_export_format_parent { ./lib/tablelib.php: require_once("$CFG->libdir/excellib.class.php"); ./lib/tcpdf/barcodes.php: * Very capable code, excellent density, high reliability; in very wide use world-wide ./lib/pear/Spreadsheet/Excel/Writer.php: header("Content-type: application/vnd.ms-excel"); ./lib/pear/README_MOODLE.txt:* http://cvs.moodle.org/moodle/lib/excel/Parser.php.diff?r1=1.1&r2=1.2 ./lib/pear/README_MOODLE.txt:* http://cvs.moodle.org/moodle/lib/excel/Worksheet.php.diff?r1=1.1&r2=1.2 ./lib/pear/README.txt:see the excel.class.lib file, that includes code to build ./lib/excel/Workbook.php:require_once("$CFG->libdir/excel/Format.php"); ./lib/excel/test.php: header("Content-type: application/vnd.ms-excel"); ./lib/excel/README.txt:Homepage: http://freshmeat.net/projects/spreadsheet_writeexcel ./lib/excel/readme_moodle.txt:diff --git a/lib/excel/Parser.php b/lib/excel/Parser.php ./lib/excel/readme_moodle.txt:--- a/lib/excel/Parser.php ./lib/excel/readme_moodle.txt:+++ b/lib/excel/Parser.php ./lib/excel/readme_moodle.txt:diff --git a/lib/excel/Worksheet.php b/lib/excel/Worksheet.php ./lib/excel/readme_moodle.txt:--- a/lib/excel/Worksheet.php ./lib/excel/readme_moodle.txt:+++ b/lib/excel/Worksheet.php ./lib/excel/readme_moodle.txt:RCS file: /cvsroot/moodle/moodle/lib/excel/Parser.php,v ./lib/excel/readme_moodle.txt:RCS file: /cvsroot/moodle/moodle/lib/excel/Worksheet.php,v ./lib/phpmailer/class.phpmailer.php: 'xls' => 'application/vnd.ms-excel', ./lib/phpmailer/class.phpmailer.php: 'xl' => 'application/excel', ./mod/scorm/report.php: require_once("$CFG->libdir/excellib.class.php"); ./mod/scorm/report.php: echo $OUTPUT->single_button(new moodle_url('/mod/scorm/report.php', $pageoptions + $displayoptions + array('download' => 'Excel')), get_string('downloadexcel')); ./mod/wiki/db/migration/lib.php: array(2080, 29, 0, "Microsoft Excel 5.0 Worksheet", "application/vnd.ms-excel"), ./mod/wiki/db/migration/lib.php: array(2114, 5, 0, "Biff5", "application/vnd.ms-excel"), ./mod/feedback/lang/en/feedback.php:$string['export_to_excel'] = 'Export to Excel'; ./mod/feedback/analysis_course.php: //button "export to excel" ./mod/feedback/analysis_course.php: $aurl = new moodle_url('analysis_to_excel.php', array('sesskey'=>sesskey(), 'id'=>$id, 'coursefilter'=>$coursefilter)); ./mod/feedback/analysis_course.php: echo $OUTPUT->single_button($aurl, get_string('export_to_excel', 'feedback')); ./mod/feedback/analysis_to_excel.php:* prints an analysed excel-spreadsheet of the feedback ./mod/feedback/analysis_to_excel.php:// require_once('easy_excel.php'); ./mod/feedback/analysis_to_excel.php:require_once("$CFG->libdir/excellib.class.php"); ./mod/feedback/analysis_to_excel.php:$url = new moodle_url('/mod/feedback/analysis_to_excel.php', array('id'=>$id)); ./mod/feedback/analysis_to_excel.php://this prevents some output before the excel-header will be send ./mod/feedback/analysis_to_excel.php:// $worksheet1->pear_excel_worksheet->set_portrait(); ./mod/feedback/analysis_to_excel.php:// $worksheet1->pear_excel_worksheet->set_paper(9); ./mod/feedback/analysis_to_excel.php:// $worksheet1->pear_excel_worksheet->center_horizontally(); ./mod/feedback/analysis_to_excel.php:// $worksheet1->pear_excel_worksheet->set_header("&\"Arial," . $fstring->bold . "\"&14".$feedback->name); ./mod/feedback/analysis_to_excel.php:// $worksheet1->pear_excel_worksheet->set_footer($fstring->page." &P " . $fstring->of . " &N"); ./mod/feedback/analysis_to_excel.php:// $worksheet2->pear_excel_worksheet->set_landscape(); ./mod/feedback/analysis_to_excel.php:// $worksheet2->pear_excel_worksheet->set_paper(9); ./mod/feedback/analysis_to_excel.php:// $worksheet2->pear_excel_worksheet->center_horizontally(); ./mod/feedback/analysis_to_excel.php: $rowOffset1 = $itemobj->excelprint_item($worksheet1, $rowOffset1, $xlsFormats, $item, $mygroupid, $coursefilter); ./mod/feedback/analysis_to_excel.php://this is done by feedback_excelprint_detailed_items ./mod/feedback/analysis_to_excel.php:$rowOffset2 = feedback_excelprint_detailed_head($worksheet2, $xlsFormats, $items, $rowOffset2); ./mod/feedback/analysis_to_excel.php: $rowOffset2 = feedback_excelprint_detailed_items($worksheet2, $xlsFormats, $completed, $items, $rowOffset2); ./mod/feedback/analysis_to_excel.php:function feedback_excelprint_detailed_head(&$worksheet, $xlsFormats, $items, $rowOffset) { ./mod/feedback/analysis_to_excel.php:function feedback_excelprint_detailed_items(&$worksheet, $xlsFormats, $completed, $items, $rowOffset) { ./mod/feedback/analysis.php: //button "export to excel" ./mod/feedback/analysis.php: $aurl = new moodle_url('analysis_to_excel.php', array('sesskey'=>sesskey(), 'id'=>$id)); ./mod/feedback/analysis.php: echo $OUTPUT->single_button($aurl, get_string('export_to_excel', 'feedback')); ./mod/feedback/item/numeric/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/label/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) {} ./mod/feedback/item/textfield/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/textarea/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/captcha/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/feedback_item_class.php: abstract function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false); ./mod/feedback/item/feedback_item_class.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) {} ./mod/feedback/item/multichoicerated/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/info/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/item/multichoice/lib.php: function excelprint_item(&$worksheet, $rowOffset, $xlsFormats, $item, $groupid, $courseid = false) { ./mod/feedback/README.txt:- excelexport now uses the localwincharset from langconfig.php ./mod/feedback/README.txt: Now it is possible to export excel with utf8. But to many data will crash the excel ./mod/feedback/README.txt:- fixed excel-problem with tempfiles ./mod/feedback/README.txt:- added new field "idnumber" into excel detailed report ./mod/feedback/README.txt:- excelexport now use pear so cell-values can be greater then 255 chars ./mod/choice/report.php: require_once("$CFG->libdir/excellib.class.php"); ./mod/choice/report.php: $button = $OUTPUT->single_button(new moodle_url("report.php", $options), get_string("downloadexcel")); ./mod/data/lang/en/data.php:$string['excel'] = 'Excel'; ./mod/data/export_form.php: $typesarray[] = &MoodleQuickForm::createElement('radio', 'exporttype', null, get_string('excel', 'data'), 'xls'); ./mod/data/lib.php: require_once("$CFG->libdir/excellib.class.php"); ./mod/survey/lang/en/survey.php:$string['downloadexcel'] = 'Download data as Excel spreadsheet'; ./mod/survey/download.php: require_once("$CFG->libdir/excellib.class.php"); ./mod/survey/report.php: echo $OUTPUT->single_button(new moodle_url("download.php", $options), get_string("downloadexcel")); ./mod/workshop/form/accumulative/lang/en/workshopform_accumulative.php:$string['excellent'] = 'Excellent'; ./mod/workshop/form/accumulative/backup/moodle1/lib.php: '**** ' . get_string('excellent', 'workshopform_accumulative'))); ./mod/workshop/form/accumulative/backup/moodle1/lib.php: '***** ' . get_string('excellent', 'workshopform_accumulative'))); ./mod/workshop/form/accumulative/backup/moodle1/lib.php: '******* ' . get_string('excellent', 'workshopform_accumulative'))); ./mod/workshop/form/accumulative/db/upgradelib.php: '**** ' . get_string('excellent', 'workshopform_accumulative'))); ./mod/workshop/form/accumulative/db/upgradelib.php: '***** ' . get_string('excellent', 'workshopform_accumulative'))); ./mod/workshop/form/accumulative/db/upgradelib.php: '******* ' . get_string('excellent', 'workshopform_accumulative'))); ./question/format/gift/examples.txt:=no one#excellent answer! ./question/format/gift/examples.txt:=nobody#excellent answer!} ./question/format/gift/examples.txt:=no one#excellent answer! ./question/format/gift/examples.txt:=nobody#excellent answer!}