C# Discussion Boards - CodeProject

Edit excel text box using C#

29-Sep-04 2:47

There are several starter kits provided at asp.net:
http://www.asp.net/Default.aspx?tabindex=8&tabid=47[^]

One of them is commerce started kit. It includes all the source code.

manishoz28-Sep-04 14:40

manishoz

28-Sep-04 14:40

Hi,

I would like to edit a Excel TextBox using C#. I have done the selection using the following code:
((Excel.Shape)xa.ActiveWorkbook.ActiveSheet).Select("txtViews");

Next I want to edit the text in the TextBox. How do I do that? Any help would be highly appreciated.

Thanks,
Manish

iterating through xml created from a spreadsheet

wend28-Sep-04 12:51

wend

28-Sep-04 12:51

I'm trying to pick out individual cells in an xml document that has been created from an excel spreadsheet. The problem is that when a cell value is missing in the spreadsheet xml does not add a null value node to take the place of this, thus putting the xml out of synch - that is, what should be the 5th node in a row is now the 4th.

Does anybody know how to get around this? The only thing I can see extra in the xml is a new attribute ss:Index="5" for the cell after the one that has been missed.

wend

Re: iterating through xml created from a spreadsheet

Heath Stewart28-Sep-04 13:11

Re: Outlook sync component?

28-Sep-04 13:11

Use the attribute, then. Since you obviously already know the number of cells that should exist, you can author your loop so that if the ss:Index qualified attribute (don't forget about the XmlNamespaceManager) does not equal the current index in your loop, use continue (or just don't execute code a la your condition).

If you feel this is problematic, I suggest posting to the appropriate Office newsgroups on news://msnews.microsoft.com. Microsoft developers keep an eye on those and a discussion may already exist about that problem since I doubt it's uncommon.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Outlook sync component?

cmkWildsky28-Sep-04 11:53

cmkWildsky

28-Sep-04 11:53

Anyone recommend a good component to sync a sql database to Outlook's contacts/tasks/events? Intellisync looks great, but $50K(!) is a bit steep.

Thanks!

Chris

Heath Stewart28-Sep-04 13:12

C# COM object to TLB generation problem

28-Sep-04 13:12

This forum is for questions regarding C#. You might try and lounge.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna28-Sep-04 10:35

28-Sep-04 10:35

I'm trying to access C# object as COM object in C++ and I generate TLB file and use
#import in C++, but I'm having a bit of problems with return types.

For example if have method:
string GetValue()

the generated interface (*.tlh file) gets translated to:
virtual HRESULT __stdcall GetValue (/*[out,retval]*/ BSTR * pRetVal ) = 0;

the return argument always gets put as last parameter.
All the example I've seen (in books or MSDN) do not do that. They always return whatever is returned.
Is there maybe some attribute I have to apply? I'm using VS2005, so maybe it's new behaviour there?
Thanks.

Heath Stewart28-Sep-04 15:41

28-Sep-04 15:41

This is the documented and expected behavior. All COM methods (and, by extension, properties) are supposed to return HRESULTs (as yours does), and what COM clients like VB and .NET via COM interop see is return values (although in .NET you can attribute your methods with PreserveSigAttribute - among other ways - to make sure an HRESULT is returned as an Int32 since the return result code might be important and may not be an error (like S_FALSE).

I recomend that you read Creating a CCW for COM enabled non .NET applications[^] here on CodeProject, as well as Exposing .NET Framework Components to COM[^]. Make sure that you hard-code GUIDs with the GuidAttribute and never change published interfaces (i.e., interfaces you've released unto the world). Always derive new ones. Also never use auto-generated class interfaces. Define your interfaces explicitly and implement your class interface as the first interface in your implementation list.

Also, what examples are you looking at? I've read about every article and API doc in MSDN and COM methods are all return HRESULTs or SCODEs (legacy) - it's part of the COM spec to do so. VB (pre-.NET) interprets [retval]s as return values, just like tlbimp.exe and VS.NET do when importing a typelib. Other late-bound clients like Windows Script (VBScript, JScript) do so as well.

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna28-Sep-04 16:00

28-Sep-04 16:00

Thanks for response. As usual Heath you provided excelent response.
I saw in MSDN example (COM Interop Part 2: C# Server Tutorial) at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csref/html/vcwlkCOMInteropPart2CServerTutorial.asp?frame=true[^]
where they have public int PrintHi(string name) method and call it with only one parameter (string) and use return int value.

Heath Stewart28-Sep-04 18:34

28-Sep-04 18:34

You're actually supposed to use the PreserveSigAttribute when you do this. Some times the samples are incorrect. Try compiling the following:

using System;
using System.Runtime.InteropServices;
 
[assembly: ComVisible(true)]
[assembly: Guid("519a4822-f224-47fa-bdc7-8037829365dc")]
 
[InterfaceType(ComInterfaceType.InterfaceIsDual)]
[Guid("f9b77b61-b4f0-4be4-9c53-ded9592e90c6")]
public interface ITest
{
  [DispId(0)]
  int Foo(string value);
}
 
[ClassInterface(ClassInterfaceType.None)]
[Guid("ae5e53c8-54d6-4667-9396-582f5c8611bf")]
public class Test
{
  public int Foo(string value)
  {
    return value.Length;
  }
}

Compile using:

csc.exe /t:library test.cs

Next, register the library and generate a typelib:

regasm.exe /tlb test.dll

Finally, view the typelib:

oleview.exe test.tlb

You'll see the following:

// Generated .IDL file (by the OLE/COM Object Viewer)
// 
// typelib filename: test.tlb
 
[
  uuid(519A4822-F224-47FA-BDC7-8037829365DC),
  version(1.0),
  custom(90883F05-3D28-11D2-8F17-00A0C9A6186D, Test, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null)
 
]
library Test
{
    // TLib :     // TLib : mscorlib.dll : {BED7F4EA-1A96-11D2-8F08-00A0C9A6186D}
    importlib("mscorlib.tlb");
    // TLib : OLE Automation : {00020430-0000-0000-C000-000000000046}
    importlib("stdole2.tlb");
 
    // Forward declare all types defined in this typelib
    interface ITest;
 
    [
      odl,
      uuid(F9B77B61-B4F0-4BE4-9C53-DED9592E90C6),
      version(1.0),
      dual,
      oleautomation,
      custom(0F21F359-AB84-41E8-9A78-36D110E6D2F9, ITest)    
 
    ]
    interface ITest : IDispatch {
        [id(00000000), propget,
          custom(54FC8F55-38DE-4703-9C4E-250351302B1C, 1)]
        HRESULT Foo(
                        [in] BSTR value, 
                        [out, retval] long* pRetVal);
    };
 
    [
      uuid(AE5E53C8-54D6-4667-9396-582F5C8611BF),
      version(1.0),
      custom(0F21F359-AB84-41E8-9A78-36D110E6D2F9, Test)
    ]
    coclass Test {
        [default] interface _Object;
    };
};

If you used PreserveSigAttribute, then it would simply be HRESULT Foo(BSTR value).

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna29-Sep-04 4:33

29-Sep-04 4:33

Also, while we're on the subject.
How do strings returned from .net work?
If I have a method string getSomething()
I have to call it as: HRESULT getSomething(BSTR* result);

It seems I have to allocate the string for the result.
I'm doing:
CComBSTR result(20);
and call it:
getSomething(&result.m_str);

what happens if I return string longer than 20 characters? Does CLR allocate more chars?

I tried looking in MSDN, but I couldn't find any information. It seems all examples I can find only deal with ints or doubles.

Heath Stewart29-Sep-04 5:51

29-Sep-04 5:51

It's an [out, retval]. Most often, you don't allocate these as the caller. Merely declare a variable and pass the address of the variable. Also, if you read the documentation for the CComBSTR class, you'll see the following remarks:

Memory Leak Issues

Passing the address of an initialized CComBSTR to a function as an [out] parameter causes a memory leak.

In the example below, the string allocated to hold the string "Initialized" is leaked when the function OutString replaces the string.

CComBSTR bstrLeak(L"Initialized");
HRESULT hr = OutString(&bstrLeak);

To avoid the leak, call the Empty method on existing CComBSTR objects before passing the address as an [out] parameter.

Note that the same code would not cause a leak if the function's parameter was [in, out].

So, as you see - don't initialize it. You also don't need to mess with m_str. Since the CComBSTR contains only one member - m_str - passing the address of the CComBSTR instance is passing the address of the m_str (because of the way the class/struct is aligned).

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]

Werdna29-Sep-04 6:17