Export two different records to Excell

Business Central/NAV Developers Forum
1

Hi all,

Is there any method that Export two different records to a Excell in different sheet?

2

Yes you can do it by using Addsheet() Function of Excel Buffer but I think u can’t Export records in different sheets at the same time.

You have to export first record then create first sheet after call Addsheet() func. then Export the second record in the second Sheet.

3

Addsheet() Function? But I can not find the function in Excel Buffer.

5

Try CreateSheet() instead of Addseet().

Vishal
skype : vishalrajput
msn : vshal