- #Gembox workbook must contain at least one worksheet. driver#
- #Gembox workbook must contain at least one worksheet. code#
Returns a pointer to the worksheet if successful, 0 if otherwise.īasicExcelWorksheet* AddWorksheet(const wchar_t* name, int sheetIndex=-1)Īdd a new Excel worksheet with given Unicode name to the given index. Worksheet is added to the last position if sheetIndex = -1. Returns a pointer to the worksheet if successful, 0 if otherwise.īasicExcelWorksheet* AddWorksheet(const char* name, int sheetIndex=-1)Īdd a new Excel worksheet with given ANSI name to the given index. Name given to worksheet is SheetX, where X is a number which starts from 1. Returns 0 if there is no Excel worksheet with the given name.īasicExcelWorksheet* AddWorksheet(int sheetIndex=-1)Īdd a new Excel worksheet to the given index. Get a pointer to an Excel worksheet that has given Unicode name. Returns 0 if there is no Excel worksheet with the given name.īasicExcelWorksheet* GetWorksheet(const wchar_t* name) Get a pointer to an Excel worksheet that has given ANSI name. Returns 0 if index is invalid.īasicExcelWorksheet* GetWorksheet(const char* name)
Get a pointer to an Excel worksheet at the given index. Total number of Excel worksheets in current Excel workbook.īasicExcelWorksheet* GetWorksheet(size_t sheetIndex) Save current Excel workbook to opened file. class BasicExcelĬreate a new Excel workbook with a given number of spreadsheets (Minimum 1). I should give a list of the functions in the three classes which you should know to use BasicExcel. Thus the total number of lines in BasicExcel exceeds 6000.
#Gembox workbook must contain at least one worksheet. code#
A lot of code is needed to read and write to compound files, and to read and write in the native Excel format. However, although its features are basic, programming it isn't basic. As you can see, BasicExcel is really basic but even in its present form, it is far more capable than CSpreadSheet. Read and write number (integers, real numbers) and strings (ANSI, UTF16).
So maybe it is better to list the things that it does support. It is meant to be a basic class to read and write simple things like numbers and strings to a spreadsheet. It is called BasicExcel for a reason.Īctually it does not support a lot of fanciful features of Excel. Now it is finally completed and I present to you BasicExcel.īefore we look deeper into BasicExcel, let's look at its limitations. I quickly looked at my unfinished code to familiarize myself and I started writing. To my dismay, there are no such projects! So I resolved to continue the project. I wanted to complete the project but I thought after 3 years, surely someone has done a similar project already. Last week, my work commitments eased and I suddenly remembered about the Excel class that I was writing 3 years ago. Alas, work commitment prevented me from completing the project. In the meantime, the class is actually included in this package.) After I had written the class to read and write compound files, I started to write the class to read and write Excel files using information on Excel file format obtained from the OpenOffice project. (That will be published later when I have the time to properly document the class and write an article for it. Thus I had to write a class to read and write compound files first, which I have completed. However, this is not an easy task as an Excel file is saved as a compound file. It would also enable the user to read and write numbers and strings to the spreadsheet. This would allow the class to be used in environments other than Windows. Thus around 3 years ago, I wanted to replace CSpreadSheet with a class which could read and write in the native Excel format.
#Gembox workbook must contain at least one worksheet. driver#
The dependence on the ODBC driver also meant that the class is not usable in a Unix/Linux environment. All these are a result of the ODBC driver which it relies on. However it suffers from a few deficiencies like the necessity of a header row, inability to read cells as numbers, etc. More than 4 years ago, in December 2001, I posted CSpreadSheet, which is able to read and write to Microsoft Excel.
0 kommentar(er)
