ralph wrote:
On Tue, 01 Jan 2013 21:45:28 -0600, witek
wrote:


my c++ code is an xll addin.
it must be a direct call to Excel API.
Everything else is too slow for me.
I was looking at xlc... commands and I did not find anything useful but
maybe I missed something.
it is hard to find any documentation.


Ok. You can still use Automation inside an XLL, directly or
indirectly. (There is nothing in programming that can't be resolved
with another layer of indirection. <g)

I just suggested an ActiveX wrapper, because I was thinking Excel VBA
code.

As for 'speed' ... ? Automation is always a tad slow/er than any
direct read. Not sure if it will meet your service requirements, you
just have to test.

Also Automation while it does not require the product to "open", it
does instantiate the ActiveX 'exe'. There can be sharing issues in
some scenarios.

Don't give up yet. The holiday will be over soon. The real gurus will
be showing up. <g

-ralph


there are two problems.
1.
speed. Function must be really fast. We are talking about time < 10 ms.
Excel file will be very large 100 MB, so I can't use any function
which requires opening or reading file from drive.

2.
Excel file must work on any computer without any installation process.
I can't install anything extra or assume that something is installed. It
must work on "fresh" windows + excel installation.

I will try it. Maybe I can use instance of Excel which is already in memory.