我想用VC开发Excel的程序，大家给点建议，好的建议都有分！！！

2004-04-09 07:47:48 142 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

VC6.0读取Excel文件数据 VC6.0读取Excel文件数据文件存储在Excel文件中，因此第一步是能够在程序中方便地读取表格数据，这里用的是VC6.0 MFC。文章内容仅供参考，程序不完整。完整的VC6.0相关程序，需要的可以下载：https://download.csdn.net/download/qq_31569581/10714285 1、电脑上安装VC6.0，Excel2007，其他Office版本亦可... 阅读详情

我有几个问题，用VC开发Excel是否一定要在用户机器上安装Excel.
有那些网站有好的VC++开发Eccel资料.
谁有例子程序，我想要几个，我的邮箱是 WJQ@obton.com 谢谢

...全文

VC用OLE方式读写Excel 本文主要介绍VC环境中使用OLE技术对Excel读写的方法。阅读详情

sonyge

VC/MFC 16,550 成员 421,606 内容

+ 关注 + 加入社区

切换为时间正序

1HelloWorld 2004-04-10

打赏
举报

MSDN上就有详细的例子

masterz 2004-04-10

打赏
举报

http://www.fruitfruit.com/vc/activex/excelauto.cpp

supercwj 2004-04-10

打赏
举报

zhangcrony 2004-04-09

打赏
举报

.....................

http://www.codeproject.com/database/cspreadsheet.asp?target=excel

zhangcrony 2004-04-09

打赏
举报

There are times when we wish to send our output to an Excel file or some text delimited files like comma separated value file or tab delimited file. This class encapsulates the functions for reading and writing to these types of files. It was constructed with a goal of being simple to use. The main features of this class are:

Constructing a new Excel or text delimited file and writing rows or a single cell to it.
Reading rows, columns or a single cell from an Excel or text delimited file.
Replacing, inserting or appending rows to an Excel or text delimited file.
Convert an existing or newly created Excel to text delimited file and vice versa
Before I describe the various functions of the class, I will first state the limitations of this class. The limitations are:

Requires MFC.
May or may not support unicode. (didn't check it out)
Uses ODBC to read and write to Excel file, thus will have the limitations of ODBC driver. (I am not sure whatever limitation does the ODBC driver has)
Must have header row in Excel file and every column of the header row must be unique. (because class is treating Excel file as a database)
Cannot delete a sheet from Excel file. Can only delete contents of that sheet
Cell values are treated as a string, regardless of their format in Excel.
I have inserted error checking code whenever possible but I may have missed out some cases. Thus the user is required to keep the limitations in mind to prevent unexpected errors.

Below is a detailed description of the class. It is split into two parts. The first part is for those who just wish to know how to use the class. It contains a brief description of all the useful functions and how to use them. It is followed by an example that demonstrates most of the functions in the class.

The second part is for those who wish to know all the functions and variables of the class in detail. That section will describe how the function works, what are the limitations and possible errors, and how the functions, after many revisions, came to their final form. This will be useful to those who intends to change the class to suit their needs.

Now, prepare yourself for a long article ahead..

Part I. How to use the class
The following is an overview of the useful functions in the class, organised by whether they are common to both Excel and text delimited spreadsheet or only to one of them

Common Functions
CSpreadSheet(CString File, CString SheetOrSeparator, bool Backup = true)
bool AddHeaders(CStringArray &FieldNames, bool replace = false)
bool AddRow(CStringArray &RowValues, long row = 0, bool replace = false)
bool AddCell(CString CellValue, short column, long row = 0)
bool AddCell(CString CellValue, CString column, long row = 0, bool Auto = true)
bool ReadRow(CStringArray &RowValues, long row = 0)
bool ReadColumn(CStringArray &ColumnValues, short column)
bool ReadColumn(CStringArray &ColumnValues, CString column, bool Auto = true)
bool ReadCell (CString &CellValue, short column, long row = 0)
bool ReadCell (CString &CellValue, CString column, long row = 0, bool Auto = true)
bool DeleteSheet()
bool DeleteSheet(CString SheetName)
bool Convert(CString SheetOrSeparator)
void BeginTransaction()
bool Commit()
bool RollBack()
bool GetTransactionStatus()
void GetFieldNames (CStringArray &FieldNames)
long GetTotalRows()
short GetTotalColumns()
long GetCurrentRow()
bool GetBackupStatus()
CString GetLastError()
Excel Spreadsheet Specific Functions
bool ReplaceRows(CStringArray &NewRowValues, CStringArray &OldRowValues)
Text Delimited Spreadsheet Specific Functions
None

Common Functions
CSpreadSheet(CString File, CString SheetOrSeparator, bool Backup = true)

This constructor will open an Excel file (xls) or a text delimited file (any other file extensions e.g. csv, tab) for reading (for existing file) or writing (for new file or existing file). The variable SheetOrSeparator is the name of the sheet if the file is an Excel file or the type of separator if the file is a text delimited file. The default constructor will create a backup file (.bak for text delimited file) or a backup sheet (named CSpreadSheetBackup for Excel file) if opening an existing file.

_foo 2004-04-09

打赏
举报

我有几个问题，用VC开发Excel是否一定要在用户机器上安装Excel.
/////////////////////
re:那是肯定的。

有那些网站有好的VC++开发Eccel资料.
谁有例子程序，我想要几个，我的邮箱是 WJQ@obton.com 谢谢
/////////////////////////////////////////////////////////

re:

http://www.vckbase.com/document/listdoc.asp?mclsid=17&sclsid=1713

其实很简单的，知道了怎么调用后，剩下就是熟悉excel的对象模型参考了(msdn中有)

我想用VC开发Excel的程序，大家给点建议，好的建议都有分！！！

相关推荐