multiple Sheets in a single excel work book

Dynamics 365 Business Central/NAV Developers Forum
1

Hi everyone ,

i want to know which function in excel buffer table is needed to create multple sheets in single work book in excel.please tell me with best solution please.

Regards,

J.srinivas Bunny.

2

Please search before posting

http://www.mibuso.com/forum/viewtopic.php?f=23&t=24087

http://www.mibuso.com/forum/viewtopic.php?f=32&t=45632

3

Look at this post

http://www.mibuso.com/forum/viewtopic.php?f=23&t=24087

4

amol i am not getting solution can u send me the fob format object please

5

What solution are you not getting?

can you show us the code what you tried?

6

ExcelBuf.Setrange(Worksheet,‘Sheet1’);
ExcelBuf.CreateSheet(‘Sheet1’,…);
ExcelBuf.Setrange(Worksheet,‘Sheet2’);
ExcelBuf.CreateSheet(‘Sheet2’,…);