In general, I am trying to generate an Excel file with names from the database. I managed to print and create sheets with each letter of the alphabet. But the names of the problem. How can you do this?

Here is what men have:

// Create new PHPExcel object $objPHPExcel = new PHPExcel(); $F = $objPHPExcel->getActiveSheet(); for($i=321; $i<347; $i++) { $Letter='B'; $Number=2; $F = $objPHPExcel->createSheet($i); //Setting index when creating $objPHPExcel->setActiveSheetIndex(1); $F->setCellValue('A1', "Username") ->setCellValue('B1', "Project") ->setCellValue('C1', "Processes"); $request="SELECT username FROM user WHERE username LIKE '".chr($i+32)."%'"; $result= $conn->query($request);//get the result (ressource) if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $username=$row["username"]; $F->setCellValue('A'.$Number, ' '.$username.' '); $F->getRowDimension('1')->setRowHeight(20); $F->getColumnDimension($Letter)->setWidth(30); ++$Number; } } else { echo "0 results"; } $F->setTitle(chr($i)); }

Thanks for the help.

    1 answer 1

    solved the problem by deleting the if statement

     $objPHPExcel = new PHPExcel(); $F = $objPHPExcel->getActiveSheet(); for($i=321; $i<347; $i++) { $Letter='B'; $Number=2; $F = $objPHPExcel->createSheet($i); //Setting index when creating $objPHPExcel->setActiveSheetIndex(1); $F->setCellValue('A1', "Username") ->setCellValue('B1', "Project") ->setCellValue('C1', "Processes"); $request="SELECT username FROM user WHERE username LIKE '".chr($i+32)."%'"; $result= $conn->query($request);//get the result (ressource) // output data of each row while($row = $result->fetch_assoc()) { $username=$row["username"]; $F->setCellValue('A'.$Number, ' '.$username.' '); $F->getRowDimension('1')->setRowHeight(20); $F->getColumnDimension($Letter)->setWidth(30); ++$Number; } $F->setTitle(chr($i)); }