Method readData

lib/Datasource/LocalSpreadsheet.php:86–169

* Read the Data * @param $option * @return array * @throws NotFoundException * @throws \OCP\Files\NotPermittedException * @throws Exception * @throws \PhpOffice\PhpSpreadsheet\Exception */

($option)

	 * @throws \PhpOffice\PhpSpreadsheet\Exception
	 */
	public function readData($option): array {
		$header = $dataClean = $data = array();
		$headerrow = $error = 0;

		$file = $this->rootFolder->getUserFolder($option['user_id'])->get($option['link']);
		$cache = $this->getCacheMetadata($option, $file->getMTime());
		if ($cache['notModified'] === true) {
			return [
				'header' => [],
				'dimensions' => [],
				'data' => [],
				'error' => $error,
				'cache' => $cache,
			];
		}

		include_once __DIR__ . '/../../vendor/autoload.php';
		$fileName = $file->getStorage()->getLocalFile($file->getInternalPath());

		$inputFileType = IOFactory::identify($fileName);
		$reader = IOFactory::createReader($inputFileType);
		//$reader->setReadDataOnly(true); disabled as idDate is not working otherwise
		if (strlen($option['sheet']) > 0) {
			$reader->setLoadSheetsOnly([$option['sheet']]);
		}

		$rangeError = $this->validateRanges((string)$option['range']);
		if ($rangeError !== null) {
			return [
				'header' => [],
				'dimensions' => [],
				'data' => [],
				'error' => $rangeError,
				'cache' => $cache,
			];
		}

		$spreadsheet = $reader->load($fileName);

		// separated columns can be selected via ranges e.g. "A1:B9,C1:C9"
		// these ranges are read and linked
		$ranges = str_getcsv($option['range']);
		foreach ($ranges as $range) {
			$values = $spreadsheet->getActiveSheet()
								  ->rangeToArray($range, // The worksheet range that we want to retrieve
									  null,         // Value that should be returned for empty cells
									  true,   // Should formulas be calculated (the equivalent of getCalculatedValue() for each cell)
									  true,        // Should values be formatted (the equivalent of getFormattedValue() for each cell)
									  false       // Should the array be indexed by cell row and cell column
								  );

			$values = $this->convertExcelDate($spreadsheet, $values, $range);

			if (empty($data)) {
				// first range will fill the array with all rows
				$data = $values;
			} else {
				// further columns will be attached to the first ones