COMUNICATION BY RS232! - COM Discussion Boards

How to read Excel file & save data in array...........

student49118-Jan-08 11:19

18-Jan-08 11:19

hello,

I opened the excel file by using workbook.open() method...
Now i want to read the data from the excel file.. & save it into
array.

help out .. how to do this.
Then i want to pass that array through SetSourceData() method & want to draw cunztomized chart...

(I am using Excel 2007, C# 2005, COM)

Thx... Smile | :)

Class Not Registered

ritz123416-Jan-08 19:04

ritz1234

16-Jan-08 19:04

Hello Masters!

I am using VC.NET 2003.
In my project i want to use a xyz.dll which was written in VB 6.0.

In my VC.NET Project i use the code as shown below.

<br />
<br />
#import "MyTapi.dll"<br />
<br />
HRESULT hr;<br />
MyTapi::_Class1Ptr IPtr;<br />
hr=IPtr.CreateInstance(__uuidof(MyTapi::_Class1));<br />
<br />

The dll MyTapi.dll i've copied it in the current working folder as well in system32 and i've registered MyTapi.dll using regsvr32 on command prompt it registeres successfully.

But in the code above hr=Class Not Registered when I wan't to create intereface pointer of _Class1 Cry | :((

Thanks in Advance.

ritz123

how to open Existing Excel file ....

student49116-Jan-08 7:37

student491

16-Jan-08 7:37

Hello,

(for all of the followNg i m usNg C#2005, Excel 2007 & have to through COM)

i tried to open existNg Excel file by using follow method bt it gives error ... that this file doesnt exist or path is incorrect........

wb = ThisApplication.Workbooks.Open(paramWorkbookPath,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);

& i also used this method tooo..
it also doesnt work .. Frown | :(

wb= ThisApplication.Workbooks.Open(paramWorkbookPath, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true,Type.Missing, Type.Missing);

//////////
second thing how to read data from excel file & use it for charts...
can any give example

i am using Excel 2007 , C# 2005 ... all z doing using COM...

waiting for reply..
thanks...........

What is the WebBrowser control?

keniagm16-Jan-08 5:59

keniagm

16-Jan-08 5:59

Hi everybody!!

I've done some research on the msdn about the WebBrowser control, but yet I can't find what it is. I can see the properties, events and so on, and by the way it's used i think it might be an ActiveX, but I'm not sure.
So can anybody tell me if it's actually an ActiveX, and if gets registered when Windows is installed? Also, is it used by IntenetExplorer in any of its features?
Please, if someone can help me out by explaining this to me or giving me a link to a page where all of these is explained, I will really appreciate it.

Thanks

Kenia

Re: What is the WebBrowser control?

gottimukkala31-Jan-08 0:03

gottimukkala

31-Jan-08 0:03

Hi
WebBrowser Control is not exactly ActiveX but you can develope ActiveX with WebBrowser Control.Here are some links for Web Browser control and there is an article which explains how to create an ActiveX with WebBrowser control.

http://www.c-sharpcorner.com/UploadFile/mgold/HyperlinkExec03012007191054PM/HyperlinkExec.aspx[^]
http://msdn2.microsoft.com/en-us/library/ms229657.aspx

Hope that helps!!!

Re: What is the WebBrowser control?

Catherine Sea15-Feb-08 15:28

Catherine Sea

15-Feb-08 15:28

Hi Kenia,

The WebBrowser control provides a managed wrapper for the WebBrowser ActiveX control.

This page may help you.
http://msdn2.microsoft.com/en-us/library/w290k23d.aspx

--
Catherine Sea
Dynamsoft Corporation

www.dynamsoft.com
the leading developer of version control and issue tracking software

Re: What is the WebBrowser control?

keniagm18-Feb-08 2:19

keniagm

18-Feb-08 2:19

Hi Catherine,

Thank you so much for your reply. I think the page will help me.
Thanks again,

Cheers,

Kenia

COMUNICATION BY RS232!

cute_noel14-Jan-08 0:31

cute_noel

14-Jan-08 0:31

Hello everybody!
I'm having a project:"Comunication between 2 PC by RS232(COM)".

I have not yet source code about this project!

I've just need a program in which I can comunicate between 2 PC by RS232 (send file or chat).So if everybody here have source code or a program about my project,please share it to me! Thanks very much!

Thanks for reading my message!

Regards,

Wrong forum

CPallini14-Jan-08 3:20

CPallini

14-Jan-08 3:20

COM stands for Component Object Model here.
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

[my articles]

ApplyTemplateType()...

student49112-Jan-08 9:12

student491

12-Jan-08 9:12

Hello,

Can anyoNe give the example by using ApplyTemplateType()... method.
(means to draw a chart by chart template method)
(this shd b in C# n using COM)

thanks..............

How to call Dot net Web-Services in php/Java ?

alisolution11-Jan-08 21:13

alisolution

11-Jan-08 21:13

Hi everybody, recently i have problem of software development
my Question is that.

- How to call Dot net Web-Services in php/Java ?

Advance Thank

Re: How to call Dot net Web-Services in php/Java ?

Catherine Sea15-Feb-08 15:25

Catherine Sea

15-Feb-08 15:25

Hi,

There is an article about Accessing a .NET Web Service using Apache/SOAP and Java.
http://my.execpc.com/~gopalan/dotnet/webservices/webservice_java_client.html

Hope it helps.

----
Catherine Sea
Dynamsoft Corporation

www.dynamsoft.com
the leading developer of version control and issue tracking software

Convert CString to BSTR

mandanani10-Jan-08 20:05

mandanani

10-Jan-08 20:05

Dear All,

Unable to convert CString to BSTR! Am I a stupid?! Mad | :mad:

I have an interface method which needs to convert CString to BSTR and return BSTR to caller.
AllocSysString of CString is not copying the data to BSTR.

STDMETHODIMP CTP_Interface_ErrorCode_Wrp::GetAdditionalDataFlag(BSTR *AddDataFlag)<br />
{<br />
	AFX_MANAGE_STATE(AfxGetStaticModuleState())<br />
<br />
	// TODO: Add your implementation code here<br />
<br />
	CString temp = pTP_Interface_ErrorCode->GetAdditionalDataFlag();<br />
	*AddDataFlag = 	temp.AllocSysString();<br />
<br />
	return S_OK;<br />
}

Any one please help me.

Thanks very much, Nani

Cross Post?

CPallini10-Jan-08 22:10

CPallini

10-Jan-08 22:10

Cross Post => Cross Answer http://www.codeproject.com/script/Forums/View.aspx?fid=4486&msg=2386375[^]
Big Grin | :-D

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

[my articles]

How to draw Cutomized charts in Excel 2007.......

student4919-Jan-08 4:12

student491

9-Jan-08 4:12

Hello,

I want to know about charts....

How to draw Cutomized charts in Excel 2007.......(Using C# 2005 using COM)....

By using ApplycustomType() but how to use it in for Excel 2007...

Thanks..
Waiting for reply

error C2259

Krishnatv8-Jan-08 18:35

Krishnatv

8-Jan-08 18:35

while compiling My ComClient Iam getting this error .

error C2259: 'CComObject<class CComClient>' : cannot instantiate abstract class due to following members:

warning C4259: 'long __stdcall IDSNInfo::SetEngineInfo3(unsigned short *)' : pure virtual function was not defined.

what might be the error. Iam compiling in Unicode Relese Minsize.

Re: error C2259

Lim Bio Liong9-Jan-08 0:20

Lim Bio Liong

9-Jan-08 0:20

Hello Krishnatv,

Check out the parameter to SetEngineInfo3(), i.e. type unsigned short*.

See whether this parameter corresponds with the parameter type declared in the IDL file.

- Bio.

Re: error C2259

Krishnatv9-Jan-08 17:53

Krishnatv

9-Jan-08 17:53

HI Lim Bio Liong

Thanks for your great suggestion.you are right my SetEngineInfo3() parameters are different in .h file and IDL file.

Now I solved, Thanks once again.

Bye,
Krishna.

Re: error C2259

Lim Bio Liong9-Jan-08 19:35

Lim Bio Liong

9-Jan-08 19:35

Hello Krishnatv,

Congratulations and best wishes to your project.

- Bio.

How to access member functions of coclass from its Interface

mandanani8-Jan-08 16:32

mandanani

8-Jan-08 16:32

I need to pass user defined COM class through COM interface. I passed its interface as I can not pass its coclass. Please correct me if I am wrong.

The code was compiling. Now the problem is I have some data types in the coclass and can not use them from interface.
Could you please let me know how to solve this.

Here below is the code:

//////////////////////////////////////////////////////////////////////<br />
STDMETHODIMP CTP_Interface_Wrp::GetObligorInputData(ITP_CompInputData_Wrp *pVal)<br />
{<br />
	AFX_MANAGE_STATE(AfxGetStaticModuleState())<br />
<br />
	// TODO: Add your implementation code here<br />
	<br />
	pTP_DLL_Interface->GetObligorInputData(pVal->pTP_CompanyInputData);   // Error here<br />
	return S_OK;<br />
}<br />
//////////////////////////////////////////////////////////////////////

Actually pTP_CompanyInputData is member vairable of TP_CompInputData coclass. This can not be accessed from its interface class ITP_CompInputData.

modified on Tuesday, January 08, 2008 10:43:01 PM

Re: How to access member functions of coclass from its Interface

mandanani8-Jan-08 20:42

mandanani

8-Jan-08 20:42

I fixed the problem by type casting interface with its coclass.

((CTP_CompInputData_Wrp*)pVal)->pTP_CompanyInputData
Please let me know if this is the right approach.

Re: How to access member functions of coclass from its Interface

prasad_som9-Jan-08 1:29

prasad_som

9-Jan-08 1:29

Interfaces will understand the data types, those are standard, or defined in .idl.
Search for UDT in COM, you will get lot of articles, telling how to achieve it.

How to using C# Class Library in VC++/COM

Member 42194196-Jan-08 23:45

Member 4219419

6-Jan-08 23:45

I have created a class library in C# .Net 2005. I'm not able to create an instance of C# interface class in VC++/or COM dll. It gives an error
0x80040154 "Class not registered"
I also tried registering using regasm. It gives the message Types registered success
I'm not sure if i'm doing it right. Your help will be appreciated. I have attached the code snippet
C#
AssemplyInfo.cs
[assembly: ComVisible(true)]
[assembly: Guid("A4B0A925-5F27-42f3-B8D0-028248A7C210")]
ProcessClass.cs
amespace analyst1
[Guid(ProcName.InterfaceId)]
[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface INewInFace
{
[DispId(1)] void BatchStart();
}

[Guid(ProcName.ClassId)]
[ClassInterface(ClassInterfaceType.None)]
public class ProcName : INewInFace
{
internal const string ClassId = "0129FAAF-456E-4e4b-9A72-9685841EAB66";
internal const string InterfaceId = "A2F72F34-0340-49f5-8FDF-7A23A74CC370";
internal const string EventsId = "46C617A1-C148-4c9a-B064-285892110FC4";

public void BatchStart() { }
}

VC++ code
#import "..\\analyst1.tlb" no_namespace named_guids
the follwoing line gives error message "Class Not registered"
INewInFacePtr cp (__uuidof(INewInFace));

Re: How to using C# Class Library in VC++/COM

Mike Dimmick7-Jan-08 11:00

Mike Dimmick

7-Jan-08 11:00

Member 4219419 wrote:
INewInFacePtr cp (__uuidof(ProcName));

The interface INewInFace is not a class therefore it's not surprising that you get Class Not Registered.

DoEvents: Generating unexpected recursion since 1991

COM on MAC Operating System

Gupta Suraj6-Jan-08 22:08

Gupta Suraj

6-Jan-08 22:08

Hi All,

Anyone having idea about alternate technology for COM or how COM can be used on MAC OS?

Thanks

Suraj Gupta

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.