Microsoft.Office.Interop.Excel in Batch

(0) Share

Report

Posted on by kidder22

I have search this to death and cant find a solution. I need to create an excel file in batch and when I run the class that is running on server (and the method syntax is: server static) I get the error message that it could not load the file or assembly "Microsoft.Office.Interop.Excel". If I run it locally (client mode) on the AOS server it runs fine so I know the assembly is installed and working correctly - its just that when running in the batch it cant find it. If anybody has anything to offer on this it would be greatly appreciated.

Thanks,

Rick

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

Probably because the dll-file is 32 bit and the ax32serv.exe is 64 bit.

Regards,

Kjetil

Was this reply helpful? Yes No
kidder22 on at

Like (0)

Report

Thanks for the reply. So if I install the 64 bit version of office (excel) you are thinking that would fix this problem?

Was this reply helpful? Yes No
kidder22 on at

Like (0)

Report

I installed the 64 bit version of office and I'm still receiving the same error. If anybody else has any ideas it would be greatly appreciated.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Unfortunately you cannot achieve this, excel object cannot be initialized on server side hence you cannot import/export excel file in code which is running on server side.

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

Take a look to this post

You can create an Excel document from a batch job where Excel is not installed using Open XML.

Was this reply helpful? Yes No