search

xlladdins / xll24

Excel add-in library
2 stars 2 forks source link

How to create ribbon excel with xll sdk c/c++? #1

Closed Mabel328 closed 1 week ago

Mabel328 commented 1 week ago

I searched in your project how to create ribbon for excel with xll sdk c/c++ but didn't find. do you have any way to create it?

keithalewis commented 1 week ago

@Mabel328 The Excel C SDK does not provide any functionality for creating ribbons. I use VSTO for that. See https://github.com/xlladdins/xlladdin/ for a simple example.

Mabel328 commented 1 week ago

I want write by c/c++ I have referred to this project (1), it creates a ribbon "Add-ins", but can't add new buttons to the ribbon

(1) https://github.com/lionel-git/TestXll

Xloil also has the ability to create ribbons, but adding libraries is very difficult, can you refer to their code guide and simplify code?

keithalewis commented 1 week ago

@Mabel328 The project you reference does not create ribbons. You can only add menu items to call macros. The C API still has vestiges for dialog boxes, but those are no longer supported for 64-bit Excel. If you want to write C/C++ you will have to use the COM API to Excel.

Mabel328 commented 1 week ago

It is not an easy task, i will look into it Thank you