|
Microsoft::Office::Interop::Excel::Application^ exl = gcnew Microsoft::Office::Interop::Excel::ApplicationClass();
FileInfo^ file = gcnew FileInfo("c:\\leonigah.xls");
Workbook^ wb = exl->Workbooks->Open("c:\\leonigah.xls", 0, false, 5,"", "", true, Microsoft::Office::Interop::Excel::XlPlatform::xlWindows, "\t", false, false,0, true, true, 0);
Worksheet^ ws = static_cast<Worksheet^> (exl->ActiveSheet);
Range^ rn = (Range^)ws->Cells[2, 4];//2=row;4=column
rn->Value2 = "leonigah";
Nigah M Manzoor
modified on Wednesday, July 23, 2008 8:13 AM
|
|
|
|
|
Hi, I'm using Visual Studio 2005 C++/CLI. This should be an easy one. I have a textBox that has some number in it. When I press the (+) or (-) key on the far right keypad I can use ::Keys::Add and Keys::Subtract to recognize that those keys had been pressed and I can increment and decrement the number, and then put number.ToString() back in the textBox but the "+" or "-" character gets added to the textBox (and I don't want that). How do I restrict the characters that can be added to a textBox->Text String^?
Thanks,
Buck
|
|
|
|
|
|
Yes, I've read that documentation and as usual when it comes to Microsoft they assume you are a WINDOWS programmer (worst operating system ever invented). Notice how they don't show you how to do it they just tell you to do it. That being aside, I AM using an event handler for when the keys are pressed (that is how I can recognize when the (+) and (-) keys are pressed with Keys::Add and Keys::Subtract), the question is how do you keep it out of the textBox->Text String? I guess I just have to let the character get added to the text string and then search the text string for the character I just typed and then delete it from the string.
Buck
|
|
|
|
|
BuckBrown wrote: Yes, I've read that documentation and as usual when it comes to Microsoft they assume you are a WINDOWS programmer (worst operating system ever invented)
Your kidding right? Who do you write your technical documentation for, used car sales men?
So you have produced a better operating system? Give me a link to it and I will try to help you. Or even give me a link to your technical documentation you produced that is better than Microsofts, then I will help you.
Ooops, I forgot to check my CodeProject.AVOID list, you are already on it, never mind, my bad.
led mike
|
|
|
|
|
Fine Mike, you win. I wont bother picking your brain anymore. I dont understand why you insist on being such an a**hole.
|
|
|
|
|
BuckBrown wrote: (worst operating system ever invented)
Yeah, I'm sure you're right though, I'm the a**hole. 
led mike
|
|
|
|
|
how in gods name did you get to be an MVP?
|
|
|
|
|
f*** off a**hole, go back to the soapbox
led mike
|
|
|
|
|
BuckBrown wrote: question is how do you keep it out of the textBox->Text String?
Does the sample code here do what you want?
KeyPressEventArgs::Handled Property[^]
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Hey, gang!
So, I was fooling around with asynchronous socket communication, and I hit an interesting issue. I found some sample code that showed me the correct way to do what I was after, but I don't understand why it worked. That bothers me a bit, and I'd really appreciate it if one of you fine CPians would help me out.
I wanted a call to Socket::BeginReceive() to use an instance method of a class as its callback method. I was creating an AsyncCallback delegate to pass in, and first tried gcnew AsyncCallback(&this->ClassName::MethodName). The compiler didn't like that, so I hunted around and learned that the proper way is gcnew AsyncCallback(this, &ClassName::MethodName).
It did exactly what I wanted, but my question is this: Why was I allowed to do that? Both Intellisense and MSDN report that the only two overloads for that constructor are AsyncCallback(void) and AsyncCallback(const AsyncCallback & ). Why did it accept a call with two arguments? I'm obviously missing something, and I'd like to know what. 
Thanks very much for the insight!
|
|
|
|
|
Interesting...I get this on VS 2008:
error C3350: 'System::AsyncCallback' : a delegate constructor expects 1 argument(s)
?
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Really? It compiles without complaint on my end, also with VS 2008. It executes properly, too.
Is it perhaps time to consider the possibility that I have finally lost my mind?
|
|
|
|
|
Oddball wrote: Is it perhaps time to consider the possibility that I have finally lost my mind?
Or I have...wait, I KNOW I have, or have I?
Beats me what's going on there 
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
I'm out of the office for the day. I'll take another look at it tomorrow. Maybe I'll see what insanity I have perpetrated, and we can all have a good laugh.
That or I'll schedule my commitment!
|
|
|
|
|
This whole thing is really starting to puzzle me. I'm just glad that what I have does work, and that I'm coming from the angle of curiosity, rather than desperation! 
The exact line that I am executing is socket->BeginReceive(state->buffer, 0, state->BUFFER_SIZE, SocketFlags::None, gcnew AsyncCallback(this, &IOS::OnHostDataReceived), state); (variable declarations excluded for space considerations). This compiles and executes just fine for me under Visual Studio 2008 in a C++/CLI Windows Forms Project.
For reference, I found the advice that led me to try it this way at http://forums.msdn.microsoft.com/en-US/vclanguage/thread/7a261f03-8a11-4ab2-b705-a5d2d6b57eef/[^] (second post).
I guess I'm glad that it works, but I'm still puzzled about why. This strikes me as the sort of knowledge that could come in really handy in similar situations in the future.
Do you have any insight, Mark, or are you still as stumped as I am?
|
|
|
|
|
|
Oooooh, I get it now. Thanks a million, Mark. I feel much better about that bit of code now.
|
|
|
|
|
I have modified my C++ code from Manged Extensions to C++/cli. My code is using a class called CRadio that is in a dll that is written in C#. When I was using Manged Extensions I was able to call the Dispose function in the CRadio class. I am not able to do this using C++/cli because the compiler does not allow it. If I call delete on my managed CRadio class, the Dispose function and the finalizer never get called in the CRadio class.
Is there a way to execute the Dispose function or the finalizer of a managed class that is being accessed from C++/cli?
Craig
|
|
|
|
|
CTaylor89 wrote: Is there a way to execute the Dispose function
Yes. It is called when the class destructor (in C++) is called.
From the docs, this occurs:
If an object created using stack semantics goes out of scope. For more information, see C++ Stack Semantics for Reference Types.
If an exception is thrown during the object's construction.
If the object is a member in an object whose destructor is running.
If you call the delete Operator (C++) on a handle (^ (Handle to Object on Managed Heap)).
If you explicitly call the destructor.
For best results, study these carefully 
Destructors and Finalizers in Visual C++[^]
Changes in Destructor Semantics[^]
Mark
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.freetls.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Statement #4 "If you call the delete Operator (C++) on a handle (^ (Handle to Object on Managed Heap))" is what I have been attempting, but it does not result in a call to the Dispose function on the managed heap. The Dispose function of the object on the managed heap is called when my C++ destructor is called, but that requires my application to be shut down.
All I am simply doing is this:
CRadio^ pcsRadio = gcnew CRadio();
...
delete pcsRadio;
According to Statement #4 shouldn't the Dispose function of the managed object be called?
Craig
|
|
|
|
|
CTaylor89 wrote: According to Statement #4 shouldn't the Dispose function of the managed object be called?
Yes.
Is CRadio implemented in C++ or another language?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
CRadio that is in a dll that is written in C#. It is being declared, initialized and used in a C++/cli application. I want to dispose of it from the C++/cli application. Microsoft however, does not want me to simply be able to call dispose on it.
Thier documentation states "Error C2039 can occur when attempting to write code that will deterministic release of your managed or unmanaged resources." Following their suggestion for further reading, I have not found an anser to this. Sometimes I think Microsoft hates C++ programmers.
Craig
|
|
|
|
|
No, you can't call Dispose() directly from C++.
Dispose() should be called when you use delete. Try this:
public class TestDisposable : IDisposable
{
private IntPtr handle;
private bool disposed = false;
public TestDisposable(IntPtr handle)
{
this.handle = handle;
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);
}
private void Dispose(bool disposing)
{
if(!this.disposed)
{
if(disposing)
{
}
handle = IntPtr.Zero;
disposed = true;
}
}
}
TestDisposable ^testdisposable = gcnew TestDisposable(IntPtr(3));
delete testdisposable;
A breakpoint in the C# Dispose() method should be hit when delete is used.
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Looking at your example got me to think about my managed class implementation. I had a Dispose method and it would even show up in intellisense. But I was not implementing IDisposable at the top of my class and apparently this matters to C++/cli even though it worked under managed extensions.
Thanks Mark for taking the time to help me.
Craig
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
