Skip to content

Conversation

@mature-woman
Copy link

@mature-woman mature-woman commented Jun 18, 2023

Change Log

Added

just options array nothing more

Fixed

Changed

Removed

Deprecated

Security


Description

from

code
изображение
new GoogleSheetExtractor($sheets, $document, new Columns($sheet, 'A', 'X'), true, 1000, 'row');

result
изображение
... ["Тип"]=> string(20) "дискаунтер" ["Адрес"]=> string(57) "г.Красноярск ул. Свердловская 35" ...

to

code
изображение
new GoogleSheetExtractor($sheets, $document, new Columns($sheet, 'A', 'X'), true, 1000, 'row', ['valueRenderOption' => 'FORMULA']);

result
изображение
... ["Тип"]=> string(94) "=IF(EXACT(I2;"");""; IFNA(VLOOKUP(K2;part_import_KRSK!$B$2:$E$15603;2;);"Нет в базе"))" ["Адрес"]=> string(94) "=IF(EXACT(I2;"");""; IFNA(VLOOKUP(K2;part_import_KRSK!$B$2:$E$15603;4;);"Нет в базе"))" ...

@norberttech
Copy link
Member

Resolved by #488, sorry for long waiting time 🙏

@norberttech norberttech closed this Oct 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants