Question Excel C API GET.CELL

[justhumm]

Stupid, newbie question...I'm messing around with ExcelDNA and found an old thread that states, "The GET.CELL function with...option 53 allows you to get the string as displayed in the cell."

So something like this works for what I want, right now:

string text = (string)XlCall.Excel(XlCall.xlfGetCell, 53, selection);

BUT I'd really like to find a good, general reference document for the Excel C API...that defines what the other 52 options for GET.CELL are.

I haven't been able to find anything, so far. Can anyone point me to a good reference?

Thanks!

 

[govert]

The C API is documented here: Welcome to the Excel Software Development Kit
But the macro functions like GET.CELL are only documented in the Excel Macro Help file. There's a .chm version here (remember to Properties -> Unblock after downloading): Theo's Blog and a .pdf version here: https://excel-dna.net/assets/files/...eference-7df97f7e896ff61d528847f9124b1927.pdf