| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need sample for reading value from and writing value to cell E53 from outside Excel | Excel Discussion (Misc queries) | |||
| reading from text file to excel file | Excel Programming | |||
| Reading data from an excel sheet and writing to another | Excel Programming | |||
| Fast reading/writing of CSV files | Excel Programming | |||
| Reading and writing from/into several worksheets | Excel Programming | |||
Linear Mode
