How can get rows in excel sheet?

[C++ Programming]

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.