|
thanx all and nuri ismail i mistakenly posted in c# forum i m doing it in vc++
|
|
|
|
|
|
The given link works fine for me.
Maybe you should try again and if you have no success I'll send you the downloaded code.
Regards
|
|
|
|
|
Nope, still not working
I can download C# and Java examples, but C++ lib that I need is "silent"
Must be than some odd firewall rule, or something by my side. I though that maybe link was wrong...
If it's not too much bother, please send me the lib!
|
|
|
|
|
I've just sent the lib to your mail.
|
|
|
|
|
Thank you very much, you are the man!!!
Best regards,
Kresimir.
|
|
|
|
|
You're welcome!
|
|
|
|
|
is there any microsoft provided mfc class to fetch data from xls file Trioum
|
|
|
|
|
nope
But this link will help you achieve your task [^]Величие не Бога может быть недооценена.
|
|
|
|
|
try . odbc Failure is Success If we learn from it!!
|
|
|
|
|
Genarate wrapper classes for Excel type library. Select 'MFC class from TypeLib' option while adding a class. Select 'From file' radio btn and browse for excel type library. For MsOffice 2003 & 2007 type library is in Excel.Exe itself, for older versions it may vary. see how to use the generated classes http://support.microsoft.com/kb/186122[^]
|
|
|
|
|
but problem is that it always open new file I want to read data from a excel which is already open Trioum
|
|
|
|
|
don't worry as long as there is GetActiveObject() API, u can get the running instance of excel and handle the sheets already opened in it . Have a look at http://support.microsoft.com/kb/238975 and
http://support.microsoft.com/kb/196776modified on Wednesday, March 17, 2010 10:54 AM
|
|
|
|
|
Still doing lot of r&d I am not able to get that excel object to read values of cells Trioum
|
|
|
|
|
|
I could not get the alrady worksheet object using IDispatch Trioum
|
|
|
|
|
Try this one , is very good class ( created with MFC )
|
|
|
|
|
CoInitialize(NULL);
HRESULT hr;
CLSID clsidExcelApp;
// get CLSID of Excel Application
hr = CLSIDFromProgID(L"Excel.Application", &clsidExcelApp);
IUnknown *pUnk = 0;
// get running object that has been registered with OLE.
hr = GetActiveObject(clsidExcelApp, NULL, &pUnk);
if(SUCCEEDED(hr))
{
IDispatch *pDisp = 0;
hr = pUnk->QueryInterface(IID_IDispatch, (void**)&pDisp);
//use class wizard generated excel type lib classes..
CApplication oApp(pDisp);
CWorkbooks oBooks = oApp.get_Workbooks();
CWorkbook oBook = oBooks.get_Item(COleVariant((short)1)); //First workbook
CWorksheets oSheets = oBook.get_Worksheets();
CWorksheet oSheet = oSheets.get_Item(COleVariant((short)1)); //First work sheet
oSheet.Activate();
CRange oRange = oSheet.get_Range(COleVariant(CString(L"A1")), COleVariant(CString(L"A1"))); //cell A1
COleVariant var = oRange.get_Text();
MessageBox(var.bstrVal, L"Text in cell A1");
}
doesn't work?
|
|
|
|
|
Hi,
I want to convert CString array to managed code ot send it to C#.
For normal CString i did like this,
CString menu = "MENU";
String ^ msg = gcnew String(menu);
Globals1::gwtoolbar->Add(msg);
But now i want to send array of string.i dont know how to do for CString array.
When i gave like this it shows error
CString menu[10];
String[] ^ msg = gcnew String(menu);
How can i convert it?Anu
|
|
|
|
|
|
i want to create a mfc application which will display a html page in the dialog,
and it contains a button in the html page,when i click it, it will show a messagebox with the massage "hello world!".
how to implement it?
who knows? please help me, thank you very much!
|
|
|
|
|
Off the top of my head, I'd look at CDHtmlDialog ."One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Man who follows car will be exhausted." - Confucius
|
|
|
|
|
|
i am new in programming and i'm facing this problem.
i have a main frame. and i have a ToolStripMenuItem in my Main Frame. For this menu item, i put a code as below: (1example)
// loadToolStripMenuItem
//
this->loadToolStripMenuItem->DropDownItems->AddRange(gcnew cli::array< System::Windows::Forms::ToolStripItem^ >(2) {this->fromLibraryToolStripMenuItem,
this->newToolStripMenuItem});
this->loadToolStripMenuItem->Name = L"loadToolStripMenuItem";
this->loadToolStripMenuItem->Size = System::Drawing::Size(137, 22);
this->loadToolStripMenuItem->Text = L"Load..";
// ((this is a declaration))
......
((and i put the coding somewhat like below**because i couldnt find the right code))
private: System::Void fromLibraryToolStripMenuItem_Click(System::Object^ sender, System::EventArgs^ e) {
loadfromlib.h ^ openfiledialog = gcnew loadfromlib();
openfiledialog->ShowDialog();
}
when i tried to run the system; in main frame, when i click the ToolStripMenuItem, it does oppened the child frame, but it didnt work well. when the child frame is still opened, i can also click another ToolStripMenuItem as well.
i hope somebody can understand my problem and can help me solving this problem.. please, and thanks in advance...
|
|
|
|
|