How do i copy sheet in excel with X++?

Finance and Operations/AX Developer Forum
1

How do i copy sheet in excel with Ax 2009 X++?

2

you can use read and write of excel. direct copy is not possible according to me.

3

Unfortunately SysExcelWorksheet class doesn’t expose Worksheet.copy() method, therefore you would have to implement it by yourself.

It can be as simple as this:

public SysExcelWorksheet copy()
{
    COM newSheet = worksheet.copy(COMArgument::NoValue, this.comObject());

    return SysExcelWorksheet::construct(version, newSheet);
}
4

Hi Martin, Thanks for help… but That i could not . Can you please explain more ?

5

What’s the problem?

6

Hi Martin.
my fault . I solved the problem. Thank you for your help…