Laravel Excel Export with Vlookup formula multiple sheets

[tomekhun]

Hello All,

Thank you for this wonderful set of features for importing and exporting, I love to use your features.

I have a working environment with many exports and imports.

In an export I would like to achieve the following. I have multiple sheets and would like to have a sheet where i would use a Vlookup formula that searches values from another sheet.

The expected result would be the following:
in Column A user will type(scan) an SKU and in Colunm B the Vlookup formula would search the given sku from another sheet for the product name.

But in my export I have #N/A in all cells that contains the formula, not even have the formula in the field only #N/A as text. In my config file the 'pre_calculate_formulas' => false is set.
in the export which based on FromArray I use WithMapping function and for the specifig cell I use the following:
"=VLOOKUP("B{$thisRow}",#NAMEOFSHEET#::B:C,2,FALSE)",

where #NAMEOFSHEET# is the proper name of the other sheet and $thisRowId represents the currentRow.

if I put and simpler formula to a cell, such as SUM it creates the export with the proper formula in the cell and not with the calculated value.

Is there any idea what am I doing wrong?

thank you for your kind help!

regs

Tomi

[patrickbrouwers]

I think this question is best asked at PhpSpreadsheet

[tomekhun]

Ok. Thx :)

[tomekhun]

@patrickbrouwers

Sorry to bother you again, but I came to the following realization.
1., when i create an export single sheet and call the export directly the formula is present in my export
2., but when i create an export with WithMultipleSheets and calling the export as part of the sheets() function the vlookup formula becomes text. all other simpler formula is still present in my export but the vlookup becomes text.

I dont know if it concerns you or still should i try to ask for help @ phpsreadsheet

Thank you very much!!!

[tomekhun]

@patrickbrouwers Sorry I found the problem and it was on my end. the extension was wrongfully set to XLS and not XLSX in some export cases. and this caused the situation.

thanks