First I would like to start CSV Import at row 10 to allow for my image at the top. I've searched but can't find the solution.
Secondly I would like to set the column widths wider but nothing seems to work.
thanks for your help!
/** PHPExcel_IOFactory */
// set headers to redirect output to client browser as a file download
//-----Create a reader, set some parameters and read in the file-----
$objReader = PHPExcel_IOFactory::createReader('CSV');
$objPHPExcel = $objReader->load('detail.csv');
$gdImage = imagecreatefromjpeg('logo.jpg');
// Add a drawing to the worksheetecho date('H:i:s') . " Add a drawing to the worksheet\n";
$objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
$objDrawing->setName('Sample image');$objDrawing->setDescription('Sample image');
//$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
//-----Create a Writer and output the file to the browser-----
$objWriter2007 = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter2007->save('php://output'); //push out to the client browser
Feb 19, 2012 at 10:10 PM
Edited Feb 19, 2012 at 10:10 PM
Load the CSV as normal, and then insert 10 new rows at the top of the worksheet using
Set the drawing in a page heading rather than in the worksheet itself (may or may not be an appropriate solution depending on whether the image is only needed for printing or not)
Tweak the CSV reader code. There is a boolean flag called _contiguous that is used if you want to load multiple csv files into the same worksheet without overwriting. When this flag is set to true using the CSV Reader's setContiguous(true) method, then the
code uses the value of the private _contiguousRow attribute to identify the row where it should start loading the CSV file. If you add a method allowing you to set this attribute to 10, of change the setContiguous() to accept a second rowNumber argument, then
you have another solution.