[Feature Request] Support for EXCEL Formula Arguments Syntax on `xlsx`

Hello friends !!!!

My FR is about a little feature to be added when using the syntax xlsx or xls .

In many cases we need to present the argument of an EXCEL formula instead of the cell.

=FORMULA(argument_1,argument_2)

=VLOOKUP(lookup_value,table_array,col_index_num, [range_lookup])

We only get syntax highlight when inserting cells

=FORMULA(A1,A2)

=VLOOKUP(A1,A2,A3,A4)

Why I am asking this ?

The Note-taking App Obsidian uses PrismJS to highlight code syntax .

I am creating a documentation about my EXCEL formula knowledge and I want to describe the formula arguments as a code block.

Suggestion of Implementation

I was talking about this idea with ganesshkumar on this Issue here

ganesshkumar suggests these approach:

Little more context, a rendered syntax like the below

We can see that the arguments are not wrapped inside span elements and are not annotated with classes - token, argument or text. If they can wrap the arguments in span with some css classes then we can use some custom css in obsidian to show the alternating arguments in different colors as you are expecting.

This the original comment with all the details.

I was not able to insert images in this issue (I don’t know why) but I tried the best to show my FR.

• If you take a look at my original FR about this topic it will be easier to understand my FR by looking at the images
• https://github.com/ganesshkumar/obsidian-table-editor/issues/41

Thanks for reading this. Let me know if something is not clear.

Have a great day!

Start by locating PrismJS's xlsx/xls language definition and review the examples and discussion linked in this issue. Determine how formula arguments should be represented for syntax highlighting, then add coverage for the requested argument form and verify that existing cell-reference highlighting remains unchanged.