Answer the question
In order to leave comments, you need to log in
How to solve the problem with filling PHPExcel xlsx templates?
Good day
I ran into a problem, I open the template using PHPExcel, I save, I get that the xlsx template has gone astray, i.e. if earlier it started to be filled from cell D3, then from D2 and subsequent lines already become without a list. There is a change in the template. Maybe someone has encountered such a problem.
GIS import templates, except for the LS import template
<?php
require_once('Classes/PHPExcel.php');
// Подключаем класс для вывода данных в формате excel
require_once('Classes/PHPExcel/Writer/Excel2007.php');
$objPHPExcel = new PHPExcel(); //Объект PHPExcel
$objPHPExcel = PHPExcel_IOFactory::createReader('Excel2007'); //Задаем ридер
$objPHPExcel = $objPHPExcel->load('qqqq.xlsx'); //Загружаем "шаблонный" xls
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$name=time().uniqid().'.xlsx';
$objWriter->save($name);
?>
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question