question about Excel file writing and reading

Could someone tell me how to write and read excel file efficiently in c++
wn32 sdk program? I using win2000 + VC++ 6.0, open and operate then close
excel file frequently

An example will be highly appreciated.

Thanks,

Your request is too general.

If you want to create and write to an Excel file on a cell/range by
cell/range basis with formatting and want to do so without EXCEL, have a look
at ExcelWriter.

If you want to create an Excel file and dump into it data from an SQL query,
you can do so using the JET provider and do not need EXCEL.

If you have Excel and want to be able to create workbooks/files and populate
them on a cell/range by cell/range basic, you need to look as Excel
automation: there are plenty of examples on the internet but they illustrate
the principles using VB mostly rather than C++.

"Albert Ge" wrote:

> Could someone tell me how to write and read excel file efficiently in c++
> wn32 sdk program? I using win2000 + VC++ 6.0, open and operate then close
> excel file frequently
>
> An example will be highly appreciated.
>
> Thanks,
>
>
>

Yes, maybe my request before is very general.
I try to write/read file by excel automation, but the operation will be very
frequent.
I only find examples on how to do in MFC program, no case for Win32 SDK.

Could someone give me the SDK example?
I use win2000 + VC++ 6.0 + Excel 2000

Thanks,
Albert
"AA2e72E" <AA2e72E@discussions.microsoft.com> wrote in message
news:5899B826-F5D0-4020-BDD2-20A03AF7B97C@microsoft.com...
> Your request is too general.
>
> If you want to create and write to an Excel file on a cell/range by
> cell/range basis with formatting and want to do so without EXCEL, have a
look
> at ExcelWriter.
>
> If you want to create an Excel file and dump into it data from an SQL
query,
> you can do so using the JET provider and do not need EXCEL.
>
> If you have Excel and want to be able to create workbooks/files and
populate
> them on a cell/range by cell/range basic, you need to look as Excel
> automation: there are plenty of examples on the internet but they
illustrate
> the principles using VB mostly rather than C++.
>
> "Albert Ge" wrote:
>
> > Could someone tell me how to write and read excel file efficiently in
c++
> > wn32 sdk program? I using win2000 + VC++ 6.0, open and operate then
close
> > excel file frequently
> >
> > An example will be highly appreciated.
> >
> > Thanks,
> >
> >
> >