|
Hi,
plz tell me. how can i read excel sheet using visual c++ MFC.
i have write following code but it reads only three rows.
void CReadExcelDlg::OnButton1()
{
CDatabase database;
CString sSql;
CString sItem1, sItem2,sItem3;
CString sDriver;
CString sDsn;
CString sFile = "ReadExcel.xls"; // the file name. Could also be something like C:\\Sheets\\WhatDoIKnow.xls
// Clear the contents of the listbox
m_ctrlList.ResetContent();
sDriver = GetExcelDriver();
if( sDriver.IsEmpty() )
{
// Blast! We didn´t find that driver!
AfxMessageBox("No Excel ODBC driver found");
return;
}
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,sFile);
TRY
{
database.Open(NULL,false,false,sDsn);
CRecordset recset( &database );
sSql = "SELECT field_1, field_2 "
"FROM demo_table "
"ORDER BY field_1";
recset.Open(CRecordset::forwardOnly,sSql,CRecordset::readOnly);
while( !recset.IsEOF() )
{
// Read the result line
recset.GetFieldValue("field_1",sItem1);
recset.GetFieldValue("field_2",sItem2);
// recset.GetFieldValue("field_3",sItem3);
// Insert result into the list
m_ctrlList.AddString( sItem1 + " --> "+ sItem2 );
// Skip to the next resultline
recset.MoveNext();
}
// Close the database
database.Close();
}
CATCH(CDBException, e)
{
// A database exception occured. Pop out the details...
AfxMessageBox("Database error: "+e->m_strError);
}
END_CATCH;
}
////plz help me
|
|
|
|
|
kamlesh9873 wrote: how can i read excel sheet using visual c++ MFC
may be this[^] helps
Somethings seem HARD to do, until we know how to do them.
 _AnShUmAn_
|
|
|
|
|
kamlesh9873 wrote: ...but it reads only three rows.
Out of how many?
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
|
It doesn't matter to me one way or the other, but I'm just curious why you'd repeat what _AnShUmAn_ did but to another site? 
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
I wanted said to you ...and now I'm curious why you think its a repeat and i was wondered why you said it but when i see authors from these articles now I'm curious and wonder (one authors,one object) all things are same now i can say 
|
|
|
|
|
As it happens I have just created a set of classes which is able to read Excel files without MFC, COM or even having to have excel stored on the machine. I found it to be some 1000% faster than convensional means.
I will make it public just as soon as I find the time to write a CP article. In the meantime if anybody is interested drop me a message.
|
|
|
|
|
I have a view derived from CListView.
In a button handler i wrote
CListCtrl &listCtl=GetListCtrl();<br />
for(int j =0 ;j<4;j++)<br />
listCtl.SetItemText(i,j,arr->GetAt(j))
arr is a CStrinArray. GetAt is returning the string right. and value of i is 1. And i have set 4 coulumns for the ListView.
But the SetItemText is always returning 0.
Can you please show me the reason.
Thank you
KIRAN PINJARLA
|
|
|
|
|
What is arr ?
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
|
|
|
|
|
it's a CStringArray, it's written in the original post.
|
|
|
|
|
Maximilien wrote: it's written in the original post
 me tired. Thanks.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
|
|
|
|
|
of course CStringArray *arr; and it seems to it has two for i,j but he writes a for
|
|
|
|
|
kiran.pinjarla wrote: and value of i is 1.
So you are wanting to change the second row, correct?
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Just out of curiosity; Have you inserted any item in list control, before setting text? Or there are items present in control ?
kiran.pinjarla wrote: for(int j =0 ;j<4;j++)
initialize j with 1 and check.
|
|
|
|
|
Ok I got it. The Problem was i did not do InsertItem before going for InsertItemText. that was the problem.
Thank You.
KIRAN PINJARLA
|
|
|
|
|
Hi
I have two edit controls , 1 OK button and 1 Cancel Button.The code for the first editbox's EN_KILLFOCUS event is as follows:
void CTrial1Dlg::OnKillfocusEdit1()
{
// TODO: Add your control notification handler code here
CEdit *pEdit;
CString str;
double d1;
GetDlgItemText(IDC_EDIT1,str);
if(str.CompareNoCase(_T(""))!=0)
{
d1=_tcstod(str,NULL);
if(d1 > 3)
{
AfxMessageBox(_T("Greater than 3.Enter less than 3"));
pEdit = (CEdit *)GetDlgItem(IDC_EDIT1);
pEdit->SetFocus();
}
}
}
when I enter a number greater than 3 the message is displayed.As long as I press "OK" the message will be raised.The message will be raised even if I press "OnCancel".
My requirement is when the message is displayed and if I press the "Cancel" button the dialog should end.As I am using setfocus(), how can I do this?
Thanks in advance.
Sandhya
|
|
|
|
|
Wouldn't it be better to override OnOk() and OnCancel() ? So that in OnOk() you can check if the string is correct or not. If not, don't call CDialog::OnOk() so that the dialog won't be closed (and display a warning message).
I find this solution 'better' because the user won't have a message everytime he does something in the dialog, only when he wants to click on the ok button.
|
|
|
|
|
Thank you .
Actually I have many such edit controls where each one has a validation.So as per my requirement the data should be validated when the focus is lost from the edit box and the dialog should end when the cancel button is pressed instead of postponing the checking of validations until the ok button is pressed.
Sandhya
|
|
|
|
|
I don't know if that will work but in your KillFocus function, you can retrieve the current window that has the focus with CWnd::GetFocus. I don't know if that will be already the Cancel button, you have to try. Then, you can get the ID of the 'control' with GetDlgCtrlID. If that matches with the id of your cancel button, then leave the KillFocus function directly.
|
|
|
|
|
SandhyaSri wrote: The message will be raised even if I press "OnCancel".
Of course it will. That's because the edit control has lost focus. The code is doing exactly what it is suppose to.
A better solution is to handle the EN_CHANGE notification, and if the value in the edit control is ever greater than 3, disable the OK button. Doing validation is response to EN_KILLFOCUS is just the wrong approach.
"Money talks. When my money starts to talk, I get a bill to shut it up." - Frank
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Hello, i have some errors in my programm
Can you help me?
the error is:
ETHER_TYPE_NULL' : undeclared identifier
in this line:
eh->h_proto = ETHER_TYPE_NULL;
thanks
|
|
|
|
|
afpr wrote: ETHER_TYPE_NULL
You need to find the header in which this is defined, and then include it in your c file.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
|
|
|
|
|
I know, but the header file must be if_ether.h or ether.h or if.h and the ETHER_TYPE_NULL don't existe in all of this files. What is the value for this constant??
thanks
|
|
|
|
|
I've spent a few minutes looking for it, and did not find. What kind of file uses this ?
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
|
|
|
|
|
Hi Everybody.
Please, I want to know I can draw a line on my dialog.
I really want to draw a chart on my dialog. The chart will have 2 axes (x, y).
Thanks.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
