ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   question about Excel file writing and reading (https://www.excelbanter.com/excel-programming/328101-question-about-excel-file-writing-reading.html)

Albert Ge

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,



AA2e72E

question about Excel file writing and reading
 
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,




Albert Ge

question about Excel file writing and reading
 
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" wrote in message
...
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,







All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com