1.5w+
社区成员
- 主页
- VC综合技术
- 互联网技术
- MFC AppLauncher
- .NET 技术
- 界面
- 进程
- 算法
- 硬件/系统
- 数据库
- VC++技术资源
我想用VC开发Excel的程序，大家给点建议，好的建议都有分！！！
我有几个问题，用VC开发Excel是否一定要在用户机器上安装Excel.
有那些网站有好的VC++开发Eccel资料.
谁有例子程序，我想要几个，我的邮箱是 WJQ@obton.com 谢谢
有那些网站有好的VC++开发Eccel资料.
谁有例子程序，我想要几个，我的邮箱是 WJQ@obton.com 谢谢
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
1HelloWorld 2004-04-10
MSDN上就有详细的例子
masterz 2004-04-10
http://www.fruitfruit.com/vc/activex/excelauto.cpp
supercwj 2004-04-10
gz
zhangcrony 2004-04-09
.....................
http://www.codeproject.com/database/cspreadsheet.asp?target=excel
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.
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中有)
/////////////////////
re:那是肯定的。
有那些网站有好的VC++开发Eccel资料.
谁有例子程序，我想要几个，我的邮箱是 WJQ@obton.com 谢谢
/////////////////////////////////////////////////////////
re:
http://www.vckbase.com/document/listdoc.asp?mclsid=17&sclsid=1713
其实很简单的，知道了怎么调用后，剩下就是熟悉excel的对象模型参考了(msdn中有)
