The number of arguments provided is different from the number of arguments accepted by the method.

(0) Share

Report

Posted on by ALAhmed

916

Hi,

I'm trying to import data to ax using EXcel.i still getting the error message :

The number of arguments provided is different from the number of arguments accepted by the method.

Update post :

The solution is :

boolean importLines()
{
    SysExcelApplication         application = SysExcelApplication::construct();
    SysExcelWorkBooks           workBooks   = application.workbooks();
    SysExcelWorkSheets          workSheets;
    SysExcelWorkSheet           workSheet;
    SysExcelCells               cells;

// the solution is puting the bellow line code  after initializing SysExcelApplication

application.displayAlerts(false);

//.... code

//and In the end 
application.workbooks().close(); 
application.quit(); 
application.finalize(); 
application = null;
 }

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 299,030 Super User 2025 Season 2 on at

Like (0)

Report

RE: The number of arguments provided is different from the number of arguments accepted by the method.

Hi Alex,

Can you provide some more information? Did you customize some parts of the Excel interface classes?

Do you also get the error when you compile the related objects?

Was this reply helpful? Yes No
Martin Dráb 236,279 Most Valuable Professional on at

Like (0)

Report

RE: The number of arguments provided is different from the number of arguments accepted by the method.

And which of those four methods throws the error?

Was this reply helpful? Yes No
Verified answer

ALAhmed 916 on at

Like (0)

Report

RE: The number of arguments provided is different from the number of arguments accepted by the method.

Thank for the reply,i found the solution

Please see the update of the question.

Was this reply helpful? Yes No
Martin Dráb 236,279 Most Valuable Professional on at

Like (1)

Report

RE: The number of arguments provided is different from the number of arguments accepted by the method.

Please find which method is throwing the error. We can't debug your system and guessing isn't a very effective troubleshooting technique.

I would also get rid of the catch swallowing all exceptions; ignoring errors may put your system into an inconsistent state.

Was this reply helpful? Yes No
Fawad Ahmad 61 on at

Like (0)

Report

RE: The number of arguments provided is different from the number of arguments accepted by the method.

I also have same error.

I using do While loop for excel data when row++

this type of error generate.

Was this reply helpful? Yes No