|
Hi there,
i have a problem with excel automation. I am using excel 2007 and Visual Studio 2005 with a dialog based MFC app. My code runs fine under excel 2000 but now i can't export any value to excel. Here now a code snippet of what i am doing:
pXL.CreateInstance(L"Excel.Application.12");
pXL->Visible[0] = VARIANT_TRUE;
WorkbooksPtr pBooks = pXL->Workbooks;
pBook = pBooks->Add((long)xlWorksheet);
pSheet = pXL->ActiveSheet;
pSheet->Name = "testname";
pSheet->Range["A1"]->Value = "1234";
this works fine to the pSheet->Range line. Excel opens, a new sheet is opened and this sheet is renamed to testname. But if i would write 1234 in the A1 excel cell a unhandled exception occurs and when i debug this the IDE jumps to the excel.tli file and displays this line:
#pragma implementation_key(1001)
inline void Excel::Range::PutValue ( const _variant_t & RangeValueDataType, const _variant_t & _arg2 ) {
_com_dispatch_method(this, 0x6, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL,
L"\x000c\x080c", &RangeValueDataType, &_arg2);
}
Now i don't now what to do, in the RangeValueDataType is the value i would write to the A1 cell and in _arg2 is a VT_ERROR value. I have searched the web and google groups, all people there using this pSheet->Range function and they don't have any problems with it. Anybody out there an idea whats going wrong there?
TIA and best regards,
Frank
|
|
|
|
|
LeMauvais1089 wrote: pXL.CreateInstance(L"Excel.Application.12");
Do you have both Excel 2000 and Excel 2007 on the same machine?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
No, i have got a new laptop, there is only excel 2007 installed on it.
Thanks for the response and best regards,
Frank
|
|
|
|
|
So what happens if you use pXL.CreateInstance(L"Excel.Application") instead?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
exactly the same, excel starts and crash at Range->Value. Perhaps there is something wrong in my initialisation? Here is again a code snippet from my header file:
#import "progid:Excel.Sheet.12" auto_search auto_rename rename_search_namespace("Office12")
using namespace Excel;
i must admit that my knowledge of com is minimal. Perhaps you can see something on the code above
Thanks for your help,
Frank
|
|
|
|
|
LeMauvais1089 wrote: Perhaps you can see something on the code above
No, but I've got plenty of Excel 2003 examples.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Hi all,
I have made one application in VC++. I want to make installer of that application so that I can deploy it on all client machines from server machine. Can I know any tool to make Installer or any method to make setup like this?
Thank in advance,
Priyank
|
|
|
|
|
Hi,
NSIS is a opensource freeware installer generator for windows. I used it for simple installation. I hope it has features that support your requirement. It has scripting to customise installer. please check this
http://nsis.sourceforge.net/Main_Page[^]
|
|
|
|
|
I have began to using directshow now,because VFW is not compatible on different devices. But another problem come up,that,I want to using H263 protole to compress and decompress the vedio data.But how should I do this?
The older codes running on VFW seems not suit for directshow.
Someone would give me a advice.
Thanks.
GOOD LUCK
|
|
|
|
|
Unfortunately, DirectBlow - er - DirectShow is not widely discussed here, mostly because it's a royal pain in the ass to deal with and nobody really likes doing it. Working with it is such a pain in the ass that I've turned down 6-figure salaries to avoid doing it.
I recommend that you use Google to find DirectShow help. Help is out there, but you REALLY have to look hard for it.
And I'm sure all the rules will have changed when dealing with Vista.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
DirectShow isn't quite as bad as Mr. Simmons states (maybe he should have held out for the 7-
figure jobs  ) but its COM interfaces and semi-confusing documentation can make the learning curve
tough.
I've found it superior to its predecessor VFW, mostly because of WDM driver support. It's also
very flexible once you get the hang of it. That, unfortunately, can take some time (I mean
blood, sweat, and many tears) 
That said, h.263 is no longer supported on DirectShow. As always with DirectShow, you WILL have
a hard time if you need to use a certain codec and you don't have one. The codecs included with
Windows are extremely limited. If you have a 3rd-party codec that is wrapped in a DirectShow
filter then you're in good shape.
My advice is get the Platform SDK (where the DirectShow SDK now lives) and study the features.
Make sure it's going to do what you need before you commit the time. The samples included in
the SDK work. Use them. It's sometimes nice to have working code you can study when the
documentation is vague.
Good luck!
Mark
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder
|
|
|
|
|
Nah - it really does suck as back I say it does. I remember talking to Microsoft about something and walking away from the conversation completely aghast at the response I got. I don't remember exactly what it was we were talking about (I think my subconscious is blocking it), but I think it involved identifying devices you were trying to build filters for.
It was such a big pain in the ass that I promised myself that I'd never again go through the anguish and pressure of having to deliver something written for the piece of shit that DirectShow really is.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
|
Thanks.All.
I have dealt with such problem by using hard cording.
It works well now.
|
|
|
|
|
hi all,
i need information about using c# dll in vc++ .net
regards
venu
|
|
|
|
|
Do you want to use on the C++ or C++.net?
|
|
|
|
|
hi,
i want to use in vc++
tanx
venu
|
|
|
|
|
You must use of LoadLibrary it returns a handle to file then call GetProcAddress function for gets address of function on the dll and in the end you must use of FreeLibrary function.
Does this informations helpful for you?
|
|
|
|
|
Hi all,
i am facing problem with AfxFormatString, as the the Parameters it will take from only "%1 to %9" as Arguments for subtitution from Resource String.
Please help me to Append beyond that, I Mean after 9 th Parameter.
code:
-----
Resource String :
String ID
---------
IDS_GTD_WIZ_SET_STANDARD_CONTROLLER
Caption
-------
"It is necessary to set one or more equipment other than %1, %2,\n%3, %4, %5, %6, %7, %8,\n%9 and %10 to Communication ettings."
Here i am trying to Subtitue this %1,%2,%3,%4,%5,%6,%7.... upto %9 but after subtituion of %10 i am not reflecting that.
CString lC_Str_DriverArray[10];
UINT lui_Index = 0;
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_BARCODE);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZARD_REFID);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_GATEWAY);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_ETHERNETDOWNLOAD);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_PRINTER);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_VIDEORGB);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_CONTROLLER_RGBOUTPUT);
//Extended Step Addition
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_EXTENDED_MEMORYCARD);
lC_Str_DriverArray[lui_Index++].LoadString(IDS_GTD_WIZ_SOUND_OP_UNIT);
lC_Str_DriverArray[lui_Index].LoadString(IDS_GTD_WIZ_EXTERNAL_IO_UNIT);
//Load error message
AfxFormatStrings(lC_Str_Msg,IDS_GTD_WIZ_SET_STANDARD_CONTROLLER,(LPCTSTR*)lC_Str_DriverArray,10);
Here after 9th String i am getting Problem. in %10 it is subtituting as %1 what to do.
please help me out.
Uday kiran
|
|
|
|
|
I would advise you to use boost::format[^]
Boost is a library of very high standards. So high, parts of it will find its way into the upcoming C++ standard. It is completely free.
Another possibility is building your message in a std::ostringstream, and get it from there.
std::ostringstream stream;
CString tmp;
stream << _T("It is necessary to set one or more equipment other than ");
stream << (LPCTSTR)tmp.LoadString(IDS_GTD_WIZ_CONTROLLER_BARCODE);
...
std::string s = stream.str();
CString s1 = s.c_str();
Failure is not an option - it's built right in.
|
|
|
|
|
hi jhwurmbach,
I Understand your answer. But the Code T("It is necessary to set one or more equipment other than "); must not be hard coded and this is the String Table of the Resource with %1 %2 %3 .....
and Dynamically it must subtitute accordingly.
please let me know any solution for this.
Uday kiran
|
|
|
|
|
OK. I see.
You got the text with the %1-replace markers inside and can not change it.
How stupid!
You could have a regex[^] exchanging all '%digit' by '%digit%' and use something like this
cout << boost::format("writing %1%, x=%2% : %3%-th try") % "toto" % 40.23 % 50;
(example from the boost-page)
Ok. This idea comes out of desperation.
Failure is not an option - it's built right in.
|
|
|
|
|
How can i get the sum for col2 ?
i have a CListCtrl m_list
--------------------------
|Col0 | Col1| Col2 |
--------------------------
| 10 | 2 | 1 |
--------------------------
| 10 | 2 | 1 |
--------------------------
all i want is to get the sum from col3 = 2
m_list.GetItem(...);
s1.Format(....);
AfxMessageBox(s1); // =2 from (Col3)
How Can i get the result?(from Col3); (sum)?
Bravoone
|
|
|
|
|
Wasn't one copy of your question enough?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
I work with it every day - I have for several years. Maybe I'm numb to it.