❔ 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:
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: 8To 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.1 Reply
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.