open( $file ); } /* * @Params : $file : file name of excel file to be created. * if you are using file name with directory i.e. test/myFile.xls * then the directory must be existed on the system and have permissioned properly * to write the file. * @Return : On Success Valid File Pointer to file * On Failure return false */ function open( $file ) { if ( $this->state != "CLOSED" ) { $this->error = "Error : Another file is opend .Close it to save the file"; return false; } if ( ! empty( $file ) ) { $this->fp = @fopen( $file, "w+" ); } else { $this->error = "Usage : New ExcelWriter('fileName')"; return false; } if ( $this->fp == false ) { $this->error = "Error: Unable to open/create File.You may not have permmsion to write the file."; return false; } $this->state = "OPENED"; fwrite( $this->fp, $this->GetHeader() ); return $this->fp; } function close() { if ( $this->state != "OPENED" ) { $this->error = "Error : Please open the file."; return false; } if ( $this->newRow ) { fwrite( $this->fp, "" ); $this->newRow = false; } fwrite( $this->fp, $this->GetFooter() ); fclose( $this->fp ); $this->state = "CLOSED"; return; } /* @Params : Void * @return : Void * This function write the header of Excel file. */ function GetHeader() { $header = << EOH; return $header; } function GetFooter() { return ""; } /* * @Params : $line_arr: An valid array * @Return : Void */ function writeLine( $line_arr ) { if ( $this->state != "OPENED" ) { $this->error = "Error : Please open the file."; return false; } if ( ! is_array( $line_arr ) ) { $this->error = "Error : Argument is not valid. Supply an valid Array."; return false; } fwrite( $this->fp, "" ); foreach ( $line_arr as $col ) { fwrite( $this->fp, "$col" ); } fwrite( $this->fp, "" ); } /* * @Params : Void * @Return : Void */ function writeRow() { if ( $this->state != "OPENED" ) { $this->error = "Error : Please open the file."; return false; } if ( $this->newRow == false ) { fwrite( $this->fp, "" ); } else { fwrite( $this->fp, "" ); } $this->newRow = true; } /* * @Params : $value : Coloumn Value * @Return : Void */ function writeCol( $value ) { if ( $this->state != "OPENED" ) { $this->error = "Error : Please open the file."; return false; } fwrite( $this->fp, "$value" ); } }