4 ms·
What makes Excel's Javascript API Excel specific is their schema for providing type information with the data. Such as: const myDate = { type: Excel.Cell
by wlesieutre 4y ago
What makes Excel's Javascript API Excel specific is their schema for providing type information with the data. Such as:
const myDate = {
type: Excel.CellValueType.formattedNumber,
basicValue: 32889.0,
numberFormat: "m/d/yyyy"
};
That's more Excel focused than a CSV export would be. I don't see any specifics about the API implementation but they may be using this in the provided JSON data. Maybe those average ISK prices for commodities are provided with more decimal digits, but with formatting to display two digits, etc.
Excel add-ins and data types: https://devblogs.microsoft.com/microsoft365dev/ignite-2021-excel-add-ins-and-data-types/ https://devblogs.microsoft.com/microsoft365dev/ignite-2021-e...
EVE Online and Data Type APIs: https://techcommunity.microsoft.com/t5/excel-blog/data-types-in-space-a-new-data-types-experience/ba-p/3328453 https://techcommunity.microsoft.com/t5/excel-blog/data-types...