PHPExcel

[almore3]

(PHPExcel)Paano po iset na hanggang Cell 'F' lang mag aadd yung row kasi may nakalagay po sa Cell 'G' so sa tuwing may laman yung Cell 'A-F' nagkakaspace yung Cell 'G'. I hope di magulo

Cell 'D' is blank po talaga kaya wala dyan.

$objWorksheet = $objPHPExcel->getActiveSheet();
$objWorksheet->insertNewRowBefore(21, 1);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('C21', $var['DATE_ROUTED'])
->setCellValue('B21', getDivision($var['ROUTED_TO']))
->setCellValue('A21', getDivision($var['ROUTED_FROM']))
->setCellValue('E21', $var['UNAME'])
->setCellValue('F21', $var['REMARKS']);

}
$objWorksheet->removeRow(20,1);
}

 

[godwars777]

TS mag kaka space talaga yan or walang laman kc nag escape ka ng LETTER

C,B,A,E,F = see wla kang G

$objWorksheet->removeRow(20,1); //ito namn is for removing the row not COLUMN

Question:
bakit kailangan mong e escape ung G?

pwde namang
A= date,
B = to,
C = from,
D = uname,
E = remarks

well kung gusto mo tlagang alisin ung G
try this.
removeColumn('F');


littel info:

ung CODES mo above is for INDEX which for TITLE not for data or List of Data (not advisable lalo na pag array(data) or list of data).

this is the right way to insert DATA not Title for COlumn

$objPHPExcel->getActiveSheet()->setCellValue('A22','Value');


View attachment 339429

 

[almore3]

TS mag kaka space talaga yan or walang laman kc nag escape ka ng LETTER

C,B,A,E,F = see wla kang G

$objWorksheet->removeRow(20,1); //ito namn is for removing the row not COLUMN

Question:
bakit kailangan mong e escape ung G?

pwde namang
A= date,
B = to,
C = from,
D = uname,
E = remarks

well kung gusto mo tlagang alisin ung G
try this.
removeColumn('F');


littel info:

ung CODES mo above is for INDEX which for TITLE not for data or List of Data (not advisable lalo na pag array(data) or list of data).

this is the right way to insert DATA not Title for COlumn

$objPHPExcel->getActiveSheet()->setCellValue('A22','Value');


View attachment 1249281

Sir itong yung table ko yung G is for reference lang. Gusto ko lang na hanggang F lang mag removerow

View attachment 339442