excel buff, clear pervious sheet

OnewayOneway Member Posts: 53
I try to export data to excel with excel buffer table in v5.

Yes. no problem to create multi-sheets in one workbook. However, the problem is the third sheet contain the content of second sheet. and the fourth contain the third's. As I use ExcelBuf.ClearNewRow; the second sheet is no problem.

Here is my code: (For making testing easy, all dataitem just run once)

***First DataItem***
OnAfterGetRecord=BEGIN
ExcelBuf.NewRow;
ExcelBuf.AddInfoColumn('T1A',FALSE,'',FALSE,FALSE,TRUE,'');
ExcelBuf.AddInfoColumn('T1B',FALSE,'',FALSE,FALSE,TRUE,'');
ExcelBuf.ClearNewRow;
END;

***Second DataItem***
OnAfterGetRecord=BEGIN
ExcelBuf.NewRow;
ExcelBuf.AddColumn('T2A',FALSE,'',FALSE,FALSE,TRUE,'');
ExcelBuf.AddColumn('T2B',FALSE,'',FALSE,FALSE,TRUE,'');
END;

OnPostDataItem=BEGIN
ExcelBuf..CreateBook;
ExcelBuf.CreateSheet('T2','test excel',COMPANYNAME,USERID);
ExcelBuf.DELETEALL(FALSE);
END;

***Third DataItem***
OnAfterGetRecord=BEGIN
ExcelBuf.AddColumn('T3A',FALSE,'',FALSE,FALSE,TRUE,'');
ExcelBuf.AddColumn('T3B',FALSE,'',FALSE,FALSE,TRUE,'');
END;

OnPostDataItem=BEGIN
ExcelBuf.CreateSheet('T3','test excel',COMPANYNAME,USERID);
END;


Here is the result of the wook sheet:

Information sheet: T1A T1B
T2 Sheet: T2A T2B
T3 Sheet: T1A T1B T3A T3B

T3 Sheet with problem. I'd like ONLY T3A T3B IN THIS SHEET.

Could you gus tell me where I am going wrong?
Sign In or Register to comment.