Author: Antoine Guigan (antoine@akeneo.com)
示例#1
0
 /**
  * reads the given sheet
  * @param $file
  * @param $sheet
  * @param $offset
  */
 protected function readSheet($file, $sheet, $offset = 0)
 {
     $this->logInfo(sprintf('Try to read sheet "%s" from file "%s"', $sheet, $file));
     $workbook = SpreadsheetParser::open($file);
     $worksheets = $workbook->getWorksheets();
     if (!array_key_exists($sheet, $worksheets)) {
         $this->logWarning(sprintf('Tried to read non existing sheet with index "%s" from file "%s"', $sheet, $file));
         return;
     }
     $properties = [];
     $rowIterator = $workbook->createRowIterator($sheet);
     foreach ($rowIterator as $rowIndex => $values) {
         if ($this->headerDetector->isHeader($rowIndex, $values)) {
             $properties = $this->describeProperties($values);
             continue;
         }
         if ($rowIndex < $offset) {
             continue;
         }
         if (!count($properties)) {
             continue;
         }
         $this->processValues($properties, $values);
     }
     if (empty($properties)) {
         $this->logWarning('No properties found to process');
     }
 }
示例#2
0
 public function testMacroMsOfficeFile()
 {
     $spreadsheet = SpreadsheetParser::open(__DIR__ . '/fixtures/msoffice.xlsm');
     $this->assertEquals(['Feuil1', 'Feuil2', 'Feuil3'], $spreadsheet->getWorksheets());
     $this->assertIteratesThrough([3 => ['value1', '', '2014-12-15 00:00', '2015-01-15 12:16'], 5 => ['', 'value5']], $spreadsheet->createRowIterator(0));
     $this->assertIteratesThrough([6 => ['', 'test1']], $spreadsheet->createRowIterator(1));
     $this->assertIteratesThrough([1 => ['', '', '', 'test4']], $spreadsheet->createRowIterator(2));
 }
示例#3
0
文件: Reader.php 项目: ymnl007/Clerk
 /**
  * Get all sheets/rows.
  *
  * @param array $columns
  *
  * @return \Illuminate\Support\Collection
  */
 public function get($columns = [])
 {
     // Load the file
     ini_set('auto_detect_line_endings', true);
     $this->driver = SpreadsheetParser::open($this->file);
     // Set selected columns
     $this->settings()->setColumns($columns);
     return (new WorkbookParser($this->settings()))->parse($this->getWorkbook());
 }
示例#4
0
 public function testReadFileWithForcedFormat()
 {
     $spreadsheet = SpreadsheetParser::open(__DIR__ . '/fixtures/test.txt', CsvParser::FORMAT_NAME);
     $this->assertEquals(['default'], $spreadsheet->getWorksheets());
     $this->assertIteratesThrough([1 => ['value', 'enclosed value', '15'], 2 => ['', 'value2', '']], $spreadsheet->createRowIterator(0));
 }