How can get rows in excel sheet? - C / C++ / MFC Discussion Boards

Re: CListCtrl problem

bhanu_85091-Apr-09 0:39

bhanu_8509

1-Apr-09 0:39

When I use Report Style, even I cannot add the items in the list.

//List Control parameters 
//CONTROL "",IDC_LIST1,"SysListView32",LVS_LIST | LVS_ALIGNLEFT | LVS_NOCOLUMNHEADER | WS_BORDER | WS_TABSTOP,112,23,84,114 (even I tried LVS_REPORT)
m_List.EnableScrollBar(SB_VERT, true);
m_List.EnableScrollBar(SB_HORZ,false);
CString strText;
int nColumnCount = 0;
for (int i=0;i &lt; 20;i++)
{
   strText.Format(TEXT("item %d"), i);
   // Insert the item
   m_List.InsertItem(i, strText);
}

Re: CListCtrl problem

CPallini1-Apr-09 0:45

CPallini

1-Apr-09 0:45

bhanu_8509 wrote:
m_List.EnableScrollBar(SB_VERT, true);
m_List.EnableScrollBar(SB_HORZ,false);

You don't need the above lines.

bhanu_8509 wrote:
When I use Report Style, even I cannot add the items in the list

What does it mean?
Confused | :confused:

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]

Re: CListCtrl problem

bhanu_85091-Apr-09 0:55

bhanu_8509

1-Apr-09 0:55

When I use the CListCtrl using LVS_REPORT, I cannot populate the list with the items.

CString strText;
int nColumnCount = 0;
for (int i=0;i < 20;i++)
{
   strText.Format(TEXT("item %d"), i);
   // Insert the item, select every other item.
   m_List.InsertItem(i, strText);
}

Re: CListCtrl problem

bhanu_85091-Apr-09 1:46

bhanu_8509

1-Apr-09 1:46

I am sorry, I forget to Insert the column. Now I changed it and it is working fine. Thanks for your help.

Re: CListCtrl problem

bhanu_85091-Apr-09 1:46

bhanu_8509

1-Apr-09 1:46

I am sorry, I forget to Insert the column. Now I changed it and it is working fine. Thanks for your help.

Topic closed...

Using library built in VC 8.0 or VC 7.0 in Application built in VC6.0

tony_Udz31-Mar-09 23:40

tony_Udz

31-Mar-09 23:40

Hello,

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.

On calling function (from .lib) i get large number of linker errors.
I beleive this is because one of the one of the linker warning
"warning LNK4078: multiple ".CRT" sections found with different attributes (40300040)"

Please advice.
Thanks in Advance!

Re: Using library built in VC 8.0 or VC 7.0 in Application built in VC6.0

Stuart Dootson1-Apr-09 3:34

Stuart Dootson

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

How can get rows in excel sheet?

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

Stuart Dootson

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

Re: How can get rows in excel sheet?

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

CPallini

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 | :)

[Message Deleted]

Purish Dwivedi1-Apr-09 19:07

Purish Dwivedi

1-Apr-09 19:07

[Message Deleted]

Re: Not detecting the language of Resource DLL

CPallini2-Apr-09 1:40

CPallini

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:

freeing up of resources after closing the window

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

Re: Question about classes in C++

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++

Re: Question about classes in C++

Stuart Dootson31-Mar-09 22:53

Stuart Dootson

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

Re: Question about classes in C++

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. <

Re: Question about classes in C++

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!!!

Re: Question about classes in C++

CPallini31-Mar-09 23:25

CPallini

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:

Re: Question about classes in C++

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.

Re: Question about classes in C++

Stuart Dootson1-Apr-09 3:31

Stuart Dootson

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

Re: Question about classes in C++

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

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