None of the functions work
The latest info I have is that the Excel team is expecting to release a conclusion and solution to this issue this month. What that will be exactly I canât know for sure.
Hopefully itâs going to be support for retail excel or some way for us to update the add-in to include support. But I canât know for sure.
Hundasuupa
This is great news. Thanks for the update.
1 Like
Hey.
I would like to list all my assets. But the command â=EVEONLINE.CHARACTER_ASSETS()â doesnât work.
What can I do?
Seems like you need the character to get the list,
=EVEONLINE.CHARACTER_ASSETS(INDEX(EVEONLINE.ACTIVE_CHARACTER(),3))
should get you the 3 active character.
Like Elzig said you can use a character_id to display it. Itâs the first optional parameter.
You can inject into the character_id_or_entity parameter the cell from the active character list, or the functions dropdown in the sidebar for your logged in character, assets button in there will inject into your selected cell in the sheet the preset character_assets function with the character_id and the âRifterâ filter for an example of type_name_or_type_id parameter being applied.
(character_id, type_id_or_type_name, location_filter, page) is the order of parameters
There is also a location_filter parameter, that will only display things in certain stations or containers if you supply their IDs, the jita 4-4 being a popular choice
=EVEONLINE.CHARACTER_ASSETS(,,60003760) being all items for all logged in characters in Jita 4-4.
=EVEONLINE.CHARACTER_ASSETS(,32872) returns all your Algos.
=EVEONLINE.CHARACTER_ASSETS(,34,60003760) returns all your trit IN jita 4-4. If itâs in containers it should expose it per container etc.
However if you call the function like you commented, without a parameter supplied, it will fetch all logged in characters assets. It can take very long to do so if you have a lot of items, and even longer if they are in many different private structures. So having either paging or type_id/location_filter helps the performance a ton!
Sidenote: if you are on excel web, you might very likely get a forever #BUSY due to a payload size limit in web excel unless you use the pagination parameter that will split up the assets results into pages. (500 per page)
=EVEONLINE.CHARACTER_ASSETS(,,,1) if you have â,â as your excel seperator can help you display your items in excel web.
What exactly the error from the cell was would help us and if you were on web or a desktop client , if my message is getting to technical 
Can Corp Projects be added as Function? Definitely need tracking on that.
Once itâs been exposed in the ESI thatâs def doable 
Has the issue I started this post with been addressed? Last time I checked I still couldnât get the add-on to work.
in short, M365 is required for the desktop version.
2019/2021 did not get the features required.
So basically, the Excel Add-on will likely be useless to anyone who doesnât have Microsoftâs endless Annual software subscription. Iâm not blaming CCP here, but I am not entirely surprised that any collaboration with Microsoft would end up requiring the Annual Subscription version of Excel in order for the Add-on to work.
1 Like