Forum Discussion

v-ambank's avatar
v-ambank
Ideator I
6 years ago

Create Excel From ARAS C# Method

Hello, I have to create excel from ARAS 11 SP15 C# method, Is there any dll we used for 'Export to Excel' option in ARAS? Please suggest, Thanks in advance. Regards, Amruta  
Excel
v-ambank's avatar
v-ambank
Ideator I
6 years ago

Hi Chris,

Thanks for response, Please let me know 

How 'Export to Excel' is done in Aras, what is the library method? how to use that?
I want to use same way to create excel.

Thanks & Regards,

Amruta

christopher_gillis's avatar
christopher_gillis
New Member
6 years ago

Hello,

The standard export to Excel functionality is done through client-side code. It basically takes the XML of the items in a search grid and puts it through an XSLT transform to generate XML in a format that Excel will recognize. Client-side code like this is not possible to be run on the server.

Could you elaborate on your use case? If it's a hard requirement to have this Excel generation happen on the server in a C# method, you will need to investigate another approach like using a 3rd party library to build the Excel file yourself. However, if this is happening on some user-run action it may be possible to run JavaScript code instead so that you could use the standard Export to Excel functionality.

Chris