❔ Syncfusion XlsIO for Blazor
I have a workbook with a mainsheet ("OverzichtJumbo") and multiple other sheets which I need to get some data from.
I'm trying to use the formula XLOOKUP to get this data, formula works when I try it in Excel directly, but it gives me following error:
To add the formula to the sheet I use following code:
Am I doing something wrong here or do I need a different approach if I want to use the XLOOKUP formula?
Thank you for the help.
I'm trying to use the formula XLOOKUP to get this data, formula works when I try it in Excel directly, but it gives me following error:
Error: Syncfusion.XlsIO.Implementation.Exceptions.ParseException: XLOOKUP isn't custom function. at position 1. Formula: XLOOKUP(OverzichtJumbo!$A2;FirstTab!$A:$A;FirstTab!$B:$B;na;0;1), Position: 8
To add the formula to the sheet I use following code:
worksheetOverzicht.Range[$"C{count}"].Formula= $"=XLOOKUP(OverzichtJumbo!$A{count};FirstTab!$A:$A;FirstTab!$B:$B;na;0;1)"; Am I doing something wrong here or do I need a different approach if I want to use the XLOOKUP formula?
Thank you for the help.
