|
I want to read from Excel file. Pls provide me with any class or sample project that i can use with my application.
|
|
|
|
|
|
you can find the CRecordset in the web...
it can open the excel as database
void CExDlg::OnRead()
{
// TODO: Add your control notification handler code here
CDatabase database;
CString sDriver;
CString sDsn;
CString sFile,sPath;
//find the excel in main exe folder
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
sPath.ReleaseBuffer ();
int nPos;
nPos=sPath.ReverseFind ('\\');
sPath=sPath.Left (nPos);
sFile = sPath + "\\Demo.xls"; //name of excel
sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s", sDriver, sFile);
TRY
{
database.Open(NULL, false, false, sDsn);
CRecordset recset(&database);
CString sSql;
sSql = "SELECT item FROM Regt WHERE item = 'iwant' "; //
// exe SQL
recset.Open(CRecordset::forwardOnly, sSql, CRecordset::readOnly);
BYTE line = 1;
// »ñÈ¡²éѯ½á¹û
while (!recset.IsEOF())
{
//¶ÁÈ¡ExcelÄÚ²¿ÊýÖµ
recset.GetFieldValue("item", sitem); // read out the item
line++;
//ÏÔʾ¼ÇÈ¡µÄÄÚÈÝ
m_listbox.AddString( sitem);
// ÒƵ½ÏÂÒ»ÐÐ
recset.MoveNext();
}
// close
database.Close();
}
CATCH(CDBException, e)
{
// Êý¾Ý¿â²Ù×÷²úÉúÒ쳣ʱ...
AfxMessageBox("error: " + e->m_strError);
}
END_CATCH;
}
|
|
|
|
|
Hi All,
I am unable to find which library file(.lib) need to use for this program.
Here i am including my code.
#include <stdio.h>
#include <fileref.h>
#include "tag.h"
using namespace std;
using namespace TagLib;
int main(int argc, char *argv[])
{
TagLib::FileRef f("DEV.mp3");
if(!f.isNull() && f.tag()) {
TagLib::Tag *tag = f.tag();
cout << "-- TAG --" << endl;
cout << "title - \"" << tag->title() << "\"" << endl;
cout << "artist - \"" << tag->artist() << "\"" << endl;
cout << "album - \"" << tag->album() << "\"" << endl;
cout << "year - \"" << tag->year() << "\"" << endl;
cout << "comment - \"" << tag->comment() << "\"" << endl;
cout << "track - \"" << tag->track() << "\"" << endl;
cout << "genre - \"" << tag->genre() << "\"" << endl;
}
return 0;
}
can anyone please help me for this problem.
waiting 4 ur earlier reply
bye
Trinadh
|
|
|
|
|
tag.lib? 
Maybe check the documentation associated with that library and see what you're supposed to use. Is it an sdk that you need to install?
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
Thanx for your response.
I have downloaded TagLib 1.4, but i couldn't found any .lib file in that. I think that i have to use tag.lib or taglib.lib file.
If u know the path where it exists can u please give me the path where it exists. I haven't used any SDK, i just used TagLib namespace.
http://developer.kde.org/~wheeler/taglib.html. I found whole documentation about TagLib in this link but It doesn't mention which .lib file i need to include.
waiting 4 ur reply.
regards
Trinadh.
|
|
|
|
|
Maybe TagLib is supplied in source files ? So, you just need to add the source files to your project and that will work (not sure if this is the case thought)
Cédric Moonen
Software developer
Charting control
|
|
|
|
|
I have supplied source files taglib.h and tag.h, i am getting linker error like this.I need to include .lib file in link part of project->settings along with including .h file.
errors:
tagreader.obj : error LNK2001: unresolved external symbol "public: virtual __thiscall TagLib::FileRef::~FileRef(void)" (??1FileRef@TagLib@@UAE@XZ)
tagreader.obj : error LNK2001: unresolved external symbol "public: virtual __thiscall TagLib::String::~String(void)" (??1String@TagLib@@UAE@XZ)
tagreader.obj : error LNK2001: unresolved external symbol "class std::basic_ostream<char,struct std::char_traits<char=""> > & __cdecl operator<<(class std::basic_ostream<char,struct std::char_traits<char=""> > &,class TagLib::String const &)" (??6@YAAAV?$
basic_ostream@DU?$char_traits@D@std@@@std@@AAV01@ABVString@TagLib@@@Z)
tagreader.obj : error LNK2001: unresolved external symbol "public: class TagLib::Tag * __thiscall TagLib::FileRef::tag(void)const " (?tag@FileRef@TagLib@@QBEPAVTag@2@XZ)
Regards
Trinadh
|
|
|
|
|
Do you have any .c or .cpp (or even .cxx) files supplied with ? If yes, you need to add these too to your project.
Cédric Moonen
Software developer
Charting control
|
|
|
|
|
yes i have tag.cpp file. I have added that file to my project. Again i am getting linker errors as previous.
like
tagreader.obj : error LNK2001: unresolved external symbol "public: virtual __thiscall TagLib::FileRef::~FileRef(void)" (??1FileRef@TagLib@@UAE@XZ)
tagreader.obj : error LNK2001: unresolved external symbol "public: virtual __thiscall TagLib::String::~String(void)" (??1String@TagLib@@UAE@XZ)
|
|
|
|
|
You need to unzip the source files in taglib-1.4.tar.gz and build the "lib" file, which looks to be targeted for *nix.
If you're targeting Windows, you might need to do some more research http://developer.kde.org/~wheeler/taglib.html#windows[^] or find another library.
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
Thanx again.
I have unzipped taglib-1.4 file. As i am new to vc++ and c++, could u please tell me how to build "lib" file. I came to know that it works fine wiht Unix and Linux.
If u know any procedure to retrieve details of mp3 file in windows, please let me know.
waiting 4 ur reply
Regards
Trinadh
|
|
|
|
|
Like this http://developer.kde.org/~wheeler/taglib.html#windows[^] says, this library needs to be ported to Windows. Google didn't reveal much, except some message posts about porting, so you might be out of luck (I don't have the time to port it and I don't know of any other libraries - try google)
|
|
|
|
|
thanks for spending valuable time with me Mr.Steve.
I got so much of information from u. If u find any information regarding this please let me know.
bye
Trinadh
|
|
|
|
|
On a side note, there appear to be several articles on MP3 info reading on CP (search for MP3 at the top). Not sure if there are any C++ articles, but you might find some useful information or links in them.
|
|
|
|
|
if you have a zip file (tag) i think in this zip you can find lib file if it doesnt has lib file (i think) you can find lib file in place that you download this file
whitesky
|
|
|
|
|
Thanks whitesky,
I couldn't find any lib file (tag.lib or taglib.lib) in my system. I think i need to build "lib" file with existing files. They said to use
TagLib provides a script called taglib-config that returns the necessary compiler and linker flags, as well as the version number. To build a small sample program one would use:
g++ taglib-test.cpp `taglib-config --cflags --libs` -o taglib-test
in Unix and Linux.But i am unable to find how to build "lib" file in windows. Could u please suggest me how to build lib file.
waiting 4 ur reply
Regards
Trinadh
|
|
|
|
|
|
how do i change the font size of the editbox?
Regards,
Ram
|
|
|
|
|
CFont *font=new CFont ();
font->CreateFont (30,20,0,0,0,0,1,0,0,0,0,0,0,"Verdana");
m_editbox.SetFont (font);
// m_edit box is the control variable for the edit box
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|
|
you can use like this
<br />
m_Edit.Create(WS_VISIBLE|WS_CHILD,CRect(0,0,100,100),this,1);<br />
<br />
<pre>m_Edit.SetFont(GetFont());</pre> <br />
<br />
<font size="2" color="#99ff66"><hr></font><div style="padding: 2px; text-align: left; color: rgba(255, 255, 255, 1); width: 80px"><font size="2" color="#99ff66">whitesky<br />
</font></div><hr>
|
|
|
|
|
#define MCIWndSeek(hwnd, lPos) (LONG)MCIWndSM(hwnd, MCI_SEEK, 0, (LPARAM)(LONG)(lPos))
thats the def of mciwndseek from vfw.h
MCIWndSeek(m_Video, m_songplace.GetPos());
m_songplace is my sliderctrl but all that does is pause it and using mciwndpause(FALSE); wont unpause it
m_songplace.SetRange(0, MCIWndGetLength(m_Video));
i have that set so i dont know why it dont work.
|
|
|
|
|
Dear all friends
actually i read several times about "call-by-reference" and " this" concepts.but still feel unclear, could you explain to me in detail. thank you.
Li Zhiyuan
21/06/2006
|
|
|
|
|
Hi,
I'm using property sheet in ActiveX control to have different pages(tabs). Since i need to have many number of page i would like to increase the width of the property sheet. How to do it? I'm using following code to add property sheet and multiple pages...
CPropertySheet* m_pSheet;
m_pSheet=new CPropertySheet ("Sample");
m_pSheet->AddPage(&Sample1);
m_pSheet->AddPage(&Sample2);
m_pSheet->AddPage(&Sample3);
m_pSheet->AddPage(&Sample4);
m_pSheet->AddPage(&Sample5);
m_pSheet->Create (this,WS_CHILD,NULL);
m_pSheet->SetWindowPos (NULL,0,0,500,500,NULL);
m_pSheet->ShowWindow(TRUE);
|
|
|
|
|
IMHO,
You need to go to the resource editor and increase the size of the dialogs in the resource view. That's all.
Somethings seem HARD to do, until we know how to do them.
_AnShUmAn_
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
