Generating XLS file

[kujista]

Hello,

did some of generated XLS file for records using ninjascript? I am trying EPPLus but i get error messages.

Anyone with experience? Some tip i would appricate.

Thank you all

Paul

[kujista]

I add reference to the file but get error - which says - Cannot find file or build or one of it's dependency. system cannot find file - even when it is on drive

[NinjaTrader_ChelseaB]

Hello Paul,

There wouldn't be anything directly supported for this.

You could choose to use StreamWriter to write a text based .cvs file which can open in Excel.

https://ninjatrader.com/support/helpGuides/nt8/using_streamwriter_to_write_to.htm

This thread will remain open for any community members that would like to provide unsupported code or suggestions.

[kujista]

hi, generating csv is way i am doing now, but i need xls because of formating cells, sheet etc and using formulas...

[NinjaTrader_ChelseaB]

Hello Paul,

There would not be any supported methods for this.

However, there is an older User App Share script that uses unsupported code that may still work.

https://ninjatraderecosystem.com/user-app-share-download/excel8/

This thread will remain open for any community members that would like to provide unsupported c# code or advice.

You can also contact a professional NinjaScript Consultant who would be eager to create or modify this script at your request or assist you with your script. The NinjaTrader Ecosystem has affiliate contacts who provide educational as well as consulting services. Please let me know if you would like a list of affiliate consultants who would be happy to create this script or any others at your request or provide one on one educational services.