*nix
based command prompt (but not the default Windows Command Prompt!)cd ~/.ssh
. This will take you to the root directory for Git (Likely C:\Users\[YOUR-USER-NAME]\.ssh\
on Windows).ssh
folder, there should be these two files: id_rsa
and id_rsa.pub
. These are the files that tell your computer how to communicate with GitHub, BitBucket, or any other Git based service. Type ls
to see a directory listing. If those two files don't show up, proceed to the next step. NOTE: Your SSH keys must be named id_rsa
and id_rsa.pub
in order for Git, GitHub, and BitBucket to recognize them by default.ssh-keygen -t rsa -C "your_email@example.com"
. This will create both id_rsa
and id_rsa.pub
files.id_rsa.pub
in your favorite text editor (you can do this via Windows Explorer or the OSX Finder if you like, tpying open .
will open the folder).id_rsa.pub
and paste it into GitHub and/or BitBucket under the Account Settings > SSH Keys. NOTE: I like to give the SSH key a descriptive name, usually with the name of the workstation I'm on along with the date.git push
again and see if it works. It should!$file = './files/test.xlsx'; //load the excel library $this->load->library('excel'); //read file from path $objPHPExcel = PHPExcel_IOFactory::load($file); //get only the Cell Collection $cell_collection = $objPHPExcel->getActiveSheet()->getCellCollection(); //extract to a PHP readable array format foreach ($cell_collection as $cell) { $column = $objPHPExcel->getActiveSheet()->getCell($cell)->getColumn(); $row = $objPHPExcel->getActiveSheet()->getCell($cell)->getRow(); $data_value = $objPHPExcel->getActiveSheet()->getCell($cell)->getValue(); //header will/should be in row 1 only. of course this can be modified to suit your need. if ($row == 1) { $header[$row][$columns] = $data_value; } else { $arr_data[$row][$col] = $data_value; } } //send the data in an array format $data['header'] = $header; $data['values'] = $arr_data;
//load PHPExcel library $this->load->library('Excel'); // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("mohamadikhwan.com") ->setLastModifiedBy("mohamadikhwan.com") ->setTitle("Office 2007 XLSX Test Document") ->setSubject("Office 2007 XLSX Test Document") ->setDescription("Test document for Office 2007 XLSX, generated by PHP classes.") ->setKeywords("office 2007 openxml php") ->setCategory("Test result file"); // Add some data $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A1', 'Hello') ->setCellValue('B2', 'world!') ->setCellValue('C1', 'bonjour') ->setCellValue('C2', 'monde') ->setCellValue('A4', 'tutorial from: mohamadikhwan.com'); // Rename worksheet (worksheet, not filename) $objPHPExcel->getActiveSheet()->setTitle('createdUsingPHPExcel'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client’s web browser (Excel2007) //clean the output buffer ob_end_clean(); //this is the header given from PHPExcel examples. //but the output seems somewhat corrupted in some cases. //header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); //so, we use this header instead. header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="mohamadikhwan_dot_com_phpexcel_tut.xlsx"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter->save('php://output');
Controllers can be loaded as class variables of other controllers using $this->load->module('module/controller'); or simply $this->load->module('module'); if the controller name matches the module name
//if controller name matches the module name $this->load->module('name_module'); $this->name_module->name_method(); //if controller name not matches the module name $this->load->module('name_module'/'name_controller'); $this->name_controller->name_method();
© SD Shared 2013 . Powered by Bootstrap Blogger Templates