I tried to run your project using xlslib-testCPP, in vs2008, it is showing error at check_file("./testCPP.xls", md5_checksum), Single sheet is successfully created.
outmessage is "StandardTest failed: MD5 of generated XLS mismatch or I/O failure."
I am unable to get the problem .
the code is :
define PAGE_RECORD_MAX 50000
const char StandardTest(const char md5_checksum)
{
// Get the workbook handler
workbook wb;
char buf[128];
unsigned int totalRecords = 120000 ;
unsigned int sheet = 3 ;
//creat 3 sheets, 50000 row per sheet
unsigned int rec_idx = 0;
for(int i = 0 ; i < sheet; i++){
int records = (totalRecords - rec_idx)>PAGE_RECORD_MAX? PAGE_RECORD_MAX: (totalRecords - rec_idx);
sprintf(buf, "sheet%d", i+1);
worksheet* sh = wb.sheet( buf );
This error has been reported before and as far as we know there is not real issue with the code. You can create 1Million cells with 64000 per page and open the file in Excel itself without any reported errors. The error does not happen in most other compilers.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried to run your project using xlslib-testCPP, in vs2008, it is showing error at check_file("./testCPP.xls", md5_checksum), Single sheet is successfully created.
outmessage is "StandardTest failed: MD5 of generated XLS mismatch or I/O failure."
I am unable to get the problem .
the code is :
define PAGE_RECORD_MAX 50000
const char StandardTest(const char md5_checksum)
{
// Get the workbook handler
workbook wb;
char buf[128];
unsigned int totalRecords = 120000 ;
unsigned int sheet = 3 ;
//creat 3 sheets, 50000 row per sheet
unsigned int rec_idx = 0;
for(int i = 0 ; i < sheet; i++){
int records = (totalRecords - rec_idx)>PAGE_RECORD_MAX? PAGE_RECORD_MAX: (totalRecords - rec_idx);
sprintf(buf, "sheet%d", i+1);
worksheet* sh = wb.sheet( buf );
for(int j = 0 ; j <PAGE_RECORD_MAX ;="" j++="" ){="" sh-="">label(j,0, "max row test!" ); //creat 65535 row in col,0
}
rec_idx +=PAGE_RECORD_MAX;
}
int err = wb.Dump("testCPP.xls");
const char *checkP = file_err;
if (err != NO_ERRORS)
{
cerr << "StandardTest failed: I/O failure: " << err << std::endl;
return checkP;
}
if ((checkP = check_file("./testCPP.xls", md5_checksum)))
{
cerr << "StandardTest failed: MD5 of generated XLS mismatch or I/O failure." << std::endl;
}
return checkP;
}
Regards,
kdshl
This error has been reported before and as far as we know there is not real issue with the code. You can create 1Million cells with 64000 per page and open the file in Excel itself without any reported errors. The error does not happen in most other compilers.