How does Betangel write to the Excel spreadsheet?

[GaryCook]

Hiii

How does Betangel write to the Excel spreadsheet?

Is it just writing directly to the saved file?

Looked under developer but I was surprised there was no VBA to reference it there.

[jimibt]

I believe that it uses COM Interop. so basically, the .net code (in BA) creates an Office interop session and writes out from there.

[GaryCook]

I believe that it uses COM Interop. so basically, the .net code (in BA) creates an Office interop session and writes out from there.

Thanks.

So we can tap into that directly or edit that call?

Doesnt really matter if not. Just working something out.

[GaryCook]

Actually I suppose the reason I asked that mostly is, are the spreadhseets other people make just reading the stats from that one and doing clever things with them?
Since you wrote what you did Im guessing they cant form their own in the sense of putting those cells reads into diffferent ones.