Excel Buffer table - AddInfoColumn vs AddColumn?

Mike_HWG

(NAV 5.0 SP1)

I've been learning how to output to Excel from a report by using report 10145 Item Sales by Customer as an example.

I noticed that they make use of AddInfoColumn() and AddColumn().

Can you tell me when I would want to use one of the functions over the other?

SPost29

Mike,
If you export report 10145 to excel,
you will see an information sheet and a data sheet.
Info you want on the information sheet uses AddInfoColumn

Data you want on the data sheet use AddColumn
notice the type of information on either sheet

Steve

PS I use AddColumn 95% of the time

Mike_HWG

That makes sense, especially since I don't see a way to create more than the two sheets without adding modification to the Excel Buffer table.

Thanks, sir. :thumbsup: