how can i use excell management fill cell method in report?

monir_asian

i use excel buffer table to export excell.

but i want to write some value in fixed cell

how can i use this following method and integrate with excell buffer.




ExcelBuf.NewRow;
ExcelBuf.AddColumn(FORMAT( Text001),FALSE,'',TRUE,FALSE,TRUE,'@');
//ExcelBuf.AddColumn(Item."No.",FALSE,'',FALSE,FALSE,FALSE,'');
ExcelManagement.FillCell(FORMAT( 'B1'),Item."No.") ;

Luc_VanDyck

I don't quite understand what you are looking for. If you need an example how to use the Excel buffer table through a report, have a look at this download Demo of Excel buffer usage.

monir_asian

i have done a report using excel buffer.


now i want to use excel management codeunit here to print barcode in the B cell .

how can i do this?

mohana_cse06

What is the ID of Excel Management Codeunit?

monir_asian

Codeunit : 12416 Excel Management

Savatage

I don't have that codeunit either.

Did you check out the Link to the buffer demo?
Are you trying to create headers or something?

monir_asian

yes, i read this . i am trying to make excel header.

not successful yet.

monir_asian

my wrong was that i print excel data header on preinitreport method.
so, it could not find the item no value.




i just print item no onafter agetrecord method and it is working fine.

now it is working fine.

thanks for support.

Savatage

I put my code for headers on the OnPreReport() Trigger
sample:
http://savatage99.googlepages.com/Excel ... ummies.doc