Can xlCoerce read UNICODE?
Fri, 21 Sep 2007 08:50:11 -0700
Hi, Is there any way to read unicode strings from Excel worksheet. The
code below
only reads ANSI c strings but I use Chinese strings in the excel?
void GetCell()
{
XLOPER xRef, xStr;
xRef.xltype = xltypeSRef;
xRef.val.sref.count = 1;
xRef.val.sref.ref.rwFirst = 0; xRef.val.sref.ref.rwLast = 0;
x ...
|
Is there a tool that convert VBA code into XLL C API?
Fri, 21 Sep 2007 10:52:34 +0800
Is there a tool that convert VBA code into XLL C API?
...
|
Which one is most powerful for developing a Excel Application
Fri, 21 Sep 2007 10:47:19 +0800
1. XLL SDK;
2. Shared Add-in (COM add-in)
3. Excel Add-in (C# VSTO)
4. Excel Workbook (C#)
5. Excel Template
6. VBA
and advatages and disadvatages?
I personal think C# is depend on .NET Framework 3.5, so it's not good for me
,but I also want to know it's advatages compare with other type Excel
applica ...
|
Re: Is this thread-safe in Excel 2007?
Thu, 20 Sep 2007 17:00:27 -0400
"Steve Dalton" <NOsteveSPAM(at)NOeigensysSPAM(dot)com> wrote in message
news:uiFCU9f9HHA.4476@TK2MSFTNGP06.phx.gbl...
> Hi Keith
>
> Quite apart from threading issues, this is a bug in the SDK code I think.
> Excel will try to free memory that the XLL allocated, which is a bad
> thing.
Microsoft has some ...
|
Can not find the docoument about xlc command ?
Thu, 20 Sep 2007 20:33:31 +0800
/* Excel command numbers */
#define xlcBeep (0 | xlCommand)
#define xlcOpen (1 | xlCommand)
#define xlcOpenLinks (2 | xlCommand)
#define xlcCloseAll (3 | xlCommand)
#define xlcSave (4 | xlCommand)
#define xlcSaveAs (5 | xlCommand)
#define xlcFileDelete (6 | xlCommand)
#define xlcPageSetup (7 | xlCommand)
...
|
Re: When Excel97 call xlAutoRegister function, and how?
Thu, 20 Sep 2007 18:23:19 +0800
hi,
thanks a lot, that's much clear about the xlAutoRegister funcntion.
best wishs
"Steve Dalton" <NOsteveSPAM(at)NOeigensysSPAM(dot)com> дÈëÏûÏ¢ÐÂÎÅ:eg9axi1%23HHA.5948@TK2MSFTNGP04.phx.gbl...
> If the function =REGISTER(SomeAddIn.XLL,SomeFunction) was entered into a
> command macro on a macro sheet, when ...
|
Steve Dalton: TempStr function is broke
Thu, 20 Sep 2007 18:11:36 +0800
///***************************************************************************
// TempStr()
//
// Purpose:
// Creates a temporary string XLOPER
//
// Parameters:
//
// LPSTR lpstr The string, as a null-terminated
// C string, with the first byte
// un ...
|
|
|
Re: how to Bind a .xll to a .xls file?
Thu, 20 Sep 2007 08:41:18 +0100
You could place VBA code into the XLS's Workbook_Open event, that opens the
XLL using the Add-In manager or by opening it as a document.
If you don't want the XLL to be there after closing the XLS, you can
uninstall it via the Workbook_Close event.
<LeighSword@tom.com> wrote in message
news:uPXRUE1%23H ...
|
Re: How to use Xll to Generate Rubbion UI?
Thu, 20 Sep 2007 08:37:41 +0100
Customisation of the 2007 Ribbon UI is done using XML embedded in a
document, such as an XLAM type add-in.
<LeighSword@tom.com> wrote in message
news:Ou2VoD1%23HHA.980@TK2MSFTNGP06.phx.gbl...
>
>
...
|
Modifying cells using the C API
Mon, 12 Mar 2007 15:52:00 -0500
Hello
I've been trying to write a function using the good old C API which takes a reference as a parameter (right now a single cell), which is then usedto return its extended status information (the function returns TRUE forsuccess and FALSE for error, and that cell should contain the error message if any).
...
|
