Yes but that is the sad reality of programming forums. I have accepted the situation and stop fighting it. This way it is so much more easier. -Saurabh

Use VariantChangeType[^] to convert the VARIANT to one holding a BSTR representation of the data before trying to use the BSTR. Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Are you referring to the range's GetName() method? "Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown "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

thanks for reply .I know that change the extension by using as Save As option.But how it is possible through code.

Why don't you use str.Format("%f", d) then? :) 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]

i try it but i have got error. error LNK2001: unresolved external symbol "private: static class xlw::XlfOperImpl * xlw::XlfOperImpl::instance_" (?instance_@XlfOperImpl@xlw@@0PAV12@A) error LNK2001: unresolved external symbol "public: double __thiscall xlw::XlfOper::AsDouble(int *)const " (?AsDouble@XlfOper@xlw@@QBENPAH@Z) error LNK2001: unresolved external symbol "private: int __thiscall xlw::XlfOper4::Allocate(void)" (?Allocate@XlfOper4@xlw@@AAEHXZ) error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::Set(char const *)" (?Set@XlfOper4@xlw@@QAEAAV12@PBD@Z) error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::Set(class xlw::CellMatrix const &)" (?Set@XlfOper4@xlw@@QAEAAV12@ABVCellMatrix@2@@Z) error LNK2001: unresolved external symbol "public: __thiscall xlw::XlfOper4::~XlfOper4(void)" (??1XlfOper4@xlw@@QAE@XZ) error LNK2001: unresolved external symbol "public: class xlw::XlfOper4 & __thiscall xlw::XlfOper4::SetError(unsigned short)" (?SetError@XlfOper4@xlw@@QAEAAV12@G@Z) error LNK2001: unresolved external symbol "private: int __thiscall xlw::XlfOper12::Allocate(void)" (?Allocate@XlfOper12@xlw@@AAEHXZ) error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(char const *)" (?Set@XlfOper12@xlw@@QAEAAV12@PBD@Z) error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<wchar_t> > const &)" (?Set@XlfOper12@xlw@@QAEAAV12@ABV?$basic_string@_WU?$char_traits@_W@std@@V?$allocator@_W@2@@std@@@Z) error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::Set(class xlw::CellMatrix const &)" (?Set@XlfOper12@xlw@@QAEAAV12@ABVCellMatrix@2@@Z) error LNK2001: unresolved external symbol "public: __thiscall xlw::XlfOper12::~XlfOper12(void)" (??1XlfOper12@xlw@@QAE@XZ) error LNK2001: unresolved external symbol "public: class xlw::XlfOper12 & __thiscall xlw::XlfOper12::SetError(unsigned short)" (?SetError@XlfOper12@xlw@@QAEAAV12@G@Z) error LNK2001: unresolved external symbol "public: static class xlw::XlfExcel & __cdecl xlw::XlfExcel::Instance(void)" (?Instance@XlfExcel@xlw@@SAAAV12@XZ) error LNK2001: unresolved external symbol "public: class std::basic_string<wchar_t,struct std::char_traits<wchar_t>,class std::allocator<

You must have used atol (or rather _ttol) instead of atoi. See CString::Format() member if you're already using CString. It is a crappy thing, but it's life -^ Carlo Pallini

Here's[^] the list of connectors that are provided with MySQL - there's a C++ one... Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Davitor wrote: i have a problem to get values when i am useing "Select * from table". Are we supposed to guess at this problem? Davitor wrote: ::_RecordsetPtr rs; Do you need to call CreateInstance() on the rs object before using it? "Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown "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

can somebody help me?

Pick a book on C++ and start reading. It is a crappy thing, but it's life -^ Carlo Pallini

Davitor wrote: See i am getting problem to write data in excel...I am searching here and there but i havn't found any good example or tips.If any one have example then plz givem.Plz help me Does this help? "Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown "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

Thanks Rajesh R Subramanian Class is given by you it's working for me.

Those links are actually helpful, because they give you C++ wrappers for SAFEARRAYs that will simplify the job of converting the SAFEARRAY to some other array of strings. CComSafeArray<BSTR> safearrayOfBstr(((VARIANT)data).parray); will wrap the SAFEARRAY contained in the VARIANT. You can then use the CComSafeArray methods to access the SAFEARRAY data. This article[^] is very useful, because it gives easier access to 2D SAFEARRAYs, which is what you've got here. Thing is, it's up to you to do that final step of converting to your CStringArray - but all you need to do is iterate through the relevant elements of the SAFEARRAY, extract the BSTR, convert it to a CString and store that in your CStringArray - not tricky, really! Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

It's not too difficult to find[^] appropriate examples[^] on t'Internet. Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

plz help me

problen is .xlsx file formate not work.

Ah, thanks. :-O It is a crappy thing, but it's life -^ Carlo Pallini

Thanks for reply. Now my problem is solved