public function open()
{
if (!isset($this->handler) || !is_resource($this->handler)) {
$filename = $this->getDSN();
if (!file_exists($filename)) {
throw new \Exception(sprintf('File not exist (%s)', $filename));
}
if (!is_readable($filename)) {
throw new \Exception(sprintf('File is not readable(%s)', $filename));
}
$this->handler = new \SpreadsheetReader($filename, false, false, $this->getOption('options'));
// changing worksheet if needed
$sheet = $this->getOption('worksheet');
if (!empty($sheet)) {
if (!is_numeric($sheet)) {
$index = $this->getSheetIndexForName($sheet);
// the rewing is done only if index > 0 then move next before
$this->handler->next();
$this->handler->ChangeSheet($index);
} else {
$this->handler->next();
$this->handler->ChangeSheet($sheet);
}
}
if ($this->reporter) {
$this->reporter->setTotalLines($this->handler->count());
}
$this->line = 0;
}
}
public function open()
{
if (!isset($this->handler) || !is_resource($this->handler)) {
$filename = $this->getDSN();
if (!file_exists($filename)) {
throw new \Exception(sprintf('File not exist (%s)', $filename));
}
if (!is_readable($filename)) {
throw new \Exception(sprintf('File is not readable(%s)', $filename));
}
$this->handler = new SpreadsheetReader($filename, false);
$this->nbRow = $this->handler->rowcount();
$this->nbCol = $this->handler->colcount();
$this->currentRow = 1;
if ($this->reporter) {
$this->reporter->setTotalLines($this->nbRow);
}
}
}
public function open()
{
if (!isset($this->handler) || !is_resource($this->handler)) {
$filename = $this->getDSN();
if (!file_exists($filename)) {
throw new \Exception(sprintf('File not exist (%s)', $filename));
}
if (!is_readable($filename)) {
throw new \Exception(sprintf('File is not readable(%s)', $filename));
}
$this->handler = fopen($filename, 'r');
if (!is_resource($this->handler)) {
throw new \Exception(sprintf('Could not open (%s) for reading', $filename));
}
}
$this->line = 0;
if ($this->reporter) {
$this->reporter->setTotalLines($this->getTotalLines());
}
}
