About the EVE x Microsoft Excel Add-in category

[Fedo_Foutou]

None of the functions work

[Hundasuupa]

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.

[Fedo_Foutou]

Hundasuupa

This is great news. Thanks for the update.

[pradamours]

Hey.
I would like to list all my assets. But the command “=EVEONLINE.CHARACTER_ASSETS()” doesn’t work.
What can I do?

[Elzig_Gloomyness]

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.

[Hundasuupa]

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

[Threv_Echandari]

Can Corp Projects be added as Function? Definitely need tracking on that.

[Hundasuupa]

Once it’s been exposed in the ESI that’s def doable

[Fedo_Foutou]

Has the issue I started this post with been addressed? Last time I checked I still couldn’t get the add-on to work.

[Hundasuupa]

Retail Excel 2019/2021 Compatibility Update

Hey guys, Initially we reported to Microsoft that the addin’s framework checks we used to detect if the Excel client could run the add-in wasn’t working properly for retail excel users. The checks said yes, but the functions didn’t work, #VALUE errors etc. They’ve looked into it and the conclusion is, that due to business concern, they can’t bring compatibility of rich data type features to non-subscription users of Excel. They are fixing the way the add-in can detect compatibility so at lea…

in short, M365 is required for the desktop version.
2019/2021 did not get the features required.

[Bao_Chi_Sandival]

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.