Error Export EXCEL

Hanney

Hi there,
I got problem when export record into excel file

I use this function:

EnterCell(RowNo:Integer;ColumnNo:Integer;CellValue:Text[250];Bold:Boolean; Italic:Boolean;UnderLine:Boolean)
TempExcelBuffer.INIT;
TempExcelBuffer.VALIDATE("Row No.", RowNo);
TempExcelBuffer.VALIDATE("Column No.",ColumnNo);
TempExcelBuffer."Cell Value as Text" := CellValue;
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := Bold;
TempExcelBuffer.Italic := Italic;
TempExcelBuffer.Underline := UnderLine;
TempExcelBuffer.INSERT;

After that I try
EnterCell(RowNo, 1,'Date:'.TRUE, FALSE, FALSE);

and I got error like this:
The Excel Buffer already exists.
Identification fields and value:
Row No.='1',Column No. ='1'

did i missing anything?
Thank you..

idiot

Did you increment your RowNo or ColumnNo?

Hanney

Thanks for quick reply..
Yes.. I wrote RowNo := RowNo +1;

i dont get this error if i want to see all record but when I select filter No at item list, this error came out..

kapamarou

The PK is made up of Both RowNo and ColumnNo...

EnterCell(RowNo, 1,'Date:'.TRUE, FALSE, FALSE) uses 1 as a column no... Is this the problem?

alex-m5

U have to set a property TEMPORARY of the variable TempExcelBuffer in TRUE.

mootsoo

hello
can anyone tell me what is the meaning of increment?

Hanney

Hello..

I solve this error already.This is because I repeat this code twice like this:

EnterCell(RowNo, 1,'Date:',TRUE, FALSE, FALSE);

EnterCell(RowNo, 1,"Date",TRUE, FALSE, FALSE);

:oops: ..silly mistake
Thanks everyone..