Copy Excel Sheet

[Davitor]

Hi All How can i copy excel sheet?I have a two excel file(ExcelSource.xls and ExcelDes.xls).ExcelDes.xls have allready two sheet(Sheet1 and Sheet2).Now i try to copy sheet1 from ExcelSource.xls to ExcelDes.xls in sheet3. Plz give me tips. Thanks in Advance.

[Rajesh R Subramanian]

You said it worked[^], right? :~

It is a crappy thing, but it's life -^ Carlo Pallini

[Davitor]

yes it's working but when i write more than 50thousend rows in sheets(more than one sheet) then it's showing error.

Unhandled exception at 0x7c812a6b in Excel.exe: Microsoft C++ exception: CMemoryException at memory location 0x0237e2b4..
In dbgheap.c line pvBlk = _heap_alloc_dbg_impl(nSize, nBlockUse, szFileName, nLine, errno_tmp);

Can you give me tips for that?

[Rajesh R Subramanian]

I'm not sure how is it implemented (I think that it does not free the heap memory until the last bit is read into its buffer). You might want to take a look at the code and modify it to add some sort of paging mechanism. Have you tried XLW? Is that not working as well?

It is a crappy thing, but it's life -^ Carlo Pallini

[Davitor]

Thanks for responce. Have you tried XLW? Is that not working as well? No i havn't tried.Can you tell me how can i use XLW.

[Davitor]

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<