how to import excel file with laravel maatwebsite?

Question

I'm trying to import a xls file which contains a date formula:

=DIA.LAB.INTL(FIN.MES(FECHA(C4;C3;1);-1);1)

But, i got this error:

PHPExcel_Calculation_Exception in Cell.php line 293: Sheet1!D7 -> Formula Error: Unexpected ','

I see that error is the comma but this comma does not exist in the formula.

did i missing something?

Such problems are usually caused by using the wrong delimiter (eg. ; instead of ,). Try changing your delimiter. See if any of these answers stackoverflow.com/a/31512333/2939061 stackoverflow.com/a/18217453/2939061 help. — quasoft
– quasoft, Commented Jan 29, 2017 at 19:09

alex.pulver · Accepted Answer · 2017-01-30 08:15:40Z

1

The formula is affected by your Spanish regional settings. The formula is actually

=WORKDAY.INTL(EOMONTH(DATE(C4,C3,1),-1),1)

that contains comma. MS Excel always store the formula using English regional settings.

Your formula is correct, but most probably PHPExcel might not recognize DIA.LAB.INTL function. You can try to change your regional settings and see if the error persist.

answered Jan 30, 2017 at 8:15

alex.pulver

2,1232 gold badges34 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to import excel file with laravel maatwebsite?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related