C / C++ / MFC

How can get rows in excel sheet?

1-Apr-09 3:34

tony_udz wrote:
I want to use a function from .lib file(which is built on VC 8.0 and VC 7.0) and my application is built in VC 6.0.

You can't use static libraries built with VC 7.0/8.0 with VC 6.0. Full stop. There are no workarounds, it just doesn't work - they're incompatible.

Of course, if you could make DLLs out of your static library code, you might get a bit further - but there's lots of different issues there as well.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Le@rner31-Mar-09 23:17

Le@rner

31-Mar-09 23:17

Hi all,

i m using excel like this its works fine.

For example:

Start Excel

	Excel::_ApplicationPtr pApplication;	

if ( FAILED( pApplication.CreateInstance( _T("Excel.Application") ) ) )	
{
		Errorf( _T("Failed to initialize Excel::_Application!") );
		return;	
}


Load an Excel workbook

	_variant_t	varOption( (long) DISP_E_PARAMNOTFOUND, VT_ERROR );	
Excel::_WorkbookPtr pBook = pApplication->Workbooks->Open( dlgFile.m_szFileName, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption, varOption );


Get the first worksheet

Excel::_WorksheetPtr pSheet = pBook->Sheets->Item[ 1 ];

i want to know how many rows have data in sheet.

please tell me how can i get rows count.

thanks in advance

To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.

Re: How can get rows in excel sheet?

Stuart Dootson1-Apr-09 3:52

Re: How can get rows in excel sheet?

1-Apr-09 3:52

pSheet->UsedRange->Rows->Count

You know - it would really be a good idea for you to learn about Excel and its object model if you're trying to program against it.

The easiest way to see what Excel has to offer is to open Excel, press ALT+F11 and play with VBA, especially the Object Browser (press F2 in the VBA IDE to access that).

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Le@rner1-Apr-09 19:14

Le@rner

1-Apr-09 19:14

thanks

To accomplish great things, we must not only act, but also dream;
not only plan, but also believe.

[Message Deleted]

Purish Dwivedi31-Mar-09 23:14

Purish Dwivedi

31-Mar-09 23:14

[Message Deleted]

Re: Not detecting the language of Resource DLL

CPallini1-Apr-09 0:49

Re: Not detecting the language of Resource DLL

1-Apr-09 0:49

Purish Dwivedi wrote:
So how can I support languages without installing language pack either through WIN XP CD or through microsoft site.

What's wrong about WIN XP CD or MS site?
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.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

[Message Deleted]

Purish Dwivedi1-Apr-09 19:07

Purish Dwivedi

1-Apr-09 19:07

[Message Deleted]

CPallini2-Apr-09 1:40

freeing up of resources after closing the window

2-Apr-09 1:40

Purish Dwivedi wrote:
Suppose the client doesn't have WIN XP CD or registration at microsoft, then in this situation what will be the solution?

Microsoft should sue your customer, I suppose... Roll eyes | :rolleyes:

Deepu Antony31-Mar-09 23:12

Deepu Antony

31-Mar-09 23:12

Hi all

I am using a multidoc multiview application.In that one view(CGraphView) i am opening and depending upon certain condition(when the user change the time period) i have to close it and open it with respect to the new time selected.

After or before closing this view i need to free up the resources because when the view is again opened exception is generated as there is limited area in the heap.

I am closing the Graph as follows.

CMDIChildWnd* wnd1 = MDIGetActive();
wnd1->MDIDestroy();

Is there is any function to free up all the resources allocated for this view like when a window is closed it automatically frees the memory allocated for it.

Re: freeing up of resources after closing the window

ThatsAlok1-Apr-09 19:16

ThatsAlok

1-Apr-09 19:16

if Class destucter is of any help?

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Question about classes in C++

akirilov31-Mar-09 22:49

akirilov

31-Mar-09 22:49

Hi guys,

I have 2 classes:

 class A{
  virtual void Paint() {...}
}

class B: public A{
  virtual void Paint() {...}
}

Is it possible and what I have to do, so in B.Paint to invoke A.Paint and then some other code

Cedric Moonen31-Mar-09 22:52

Cedric Moonen

31-Mar-09 22:52

akirilov wrote:
so in B.Paint to invoke A.Paint and then some other code

Yes:

void B::Paint() 
{
   A::Paint();
   // Other stuff here...
}

Cédric Moonen
Software developer

Charting control [v1.5]
OpenGL game tutorial in C++

Stuart Dootson31-Mar-09 22:53

31-Mar-09 22:53

akirilov wrote:
in B.Paint to invoke A.Paint and then some other code

Implement B::Paint like this:

void B::Paint()
{
   A::Paint();
   // Do some B specific stuff.
}

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Code-o-mat31-Mar-09 22:55

Code-o-mat

31-Mar-09 22:55

class A{
  virtual void Paint() {...}
}

class B: public A{
  virtual void Paint() 
  {
    A::Paint();
    ...
  }
}

You can also use __super (if available) like:

class B: public A{
  virtual void Paint() 
  {
    __super::Paint();
    ...
  }
}

> The problem with computers is that they do what you tell them to do and not what you want them to do. <
> Life: great graphics, but the gameplay sux. <

akirilov31-Mar-09 23:10

akirilov

31-Mar-09 23:10

Thank you guys, the answer of all of you was very helpful.

I tried with A.Paint(), but it didn't work.
I'm going to use __super, thus It will not depend of the base class name.

THANK YOU, again!!!

CPallini31-Mar-09 23:25

31-Mar-09 23:25

akirilov wrote:
I tried with A.Paint(), but it didn't work.

Possibly because they suggested A<big>::</big>Paint() instead. Roll eyes | :rolleyes:

akirilov1-Apr-09 0:22

akirilov

1-Apr-09 0:22

Well I tried A.Paint() before I posted here Wink | ;)

so, A::Paint() is working fine.

Stuart Dootson1-Apr-09 3:31

1-Apr-09 3:31

akirilov wrote:
I'm going to use __super, thus It will not depend of the base class name.

But it does tie you to Microsoft's compiler...

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

visual C++ to 8051F000 micro controller

Rajesh R Subramanian1-Apr-09 1:38

Rajesh R Subramanian

1-Apr-09 1:38

Along with other answers, see the __super[^] keyword. You could call a parent class function by __super::FuncName()

[EDIT] OK, I just read you already are going to settle on this keyword. [/EDIT]

It is a crappy thing, but it's life -^ Carlo Pallini

ruthlesspker31-Mar-09 22:37

ruthlesspker

31-Mar-09 22:37

hi guys..i have a program that require me to input user input by textbox and output it to a label...but my superviosr wants me to do it on silabs...this means i have to use serial comm to link it...i know the serial comm coding..now i need to know how to output the user input to the label..i try printf(""); and "label1->text= " but it doesnt work..any helps? Dead | X|

Re: visual C++ to 8051F000 micro controller

Cedric Moonen31-Mar-09 23:00

Cedric Moonen

31-Mar-09 23:00

Are you using MFC ? If yes you have to provide a specific Id to your static control in the resource editor. Then you can do something like this (in your dialog class):
GetDlgItem(ID_YOURID)->SetWindowText(_T("Your text here"));

Cédric Moonen
Software developer

Charting control [v1.5]
OpenGL game tutorial in C++

Re: visual C++ to 8051F000 micro controller

CPallini31-Mar-09 23:29