Hi everyone,
I have RFA API which i am using for live data.
is it possible to Export this real data to real time excel sheet.
Please help
Thank You
Hi @jcleetus,
Is it possible to write the result into a plain CSV format because Excel is able to open this file format (by default) as well?
Is this workaround acceptable?
Hello @jcleetus,
I think you are looking at OMM Viewer example that came with RFA Java SDK?
This is an RFA Java example that totally separate from Excel.
However, RFA.Net SDK
includes an example ConsumerExcel, showing how to integrate from RFA to Excel in c#, as suggested by Warat B.
Alternatively, you may modify a plain Consumer example found in RFA Java =>examples=>OMM=>cons to output the received realtime data into a flat file, in CSV format. Then you will be able to open the resulting file from Excel, as suggested by Nipat.
Hope this helps
You can actually implement an Excel Workbook to consume real-time data using the RFA .NET API
There is a "ConsumerExcel" example in RFA .NET API package. The example should show you how to implement an Excel consumer.
Hi Warat,
Thank You for your reply.
When i saw a video they mentioned it is opened in visual studio!
So will it be possible to open the OMM viewer live data in Excel format?
Regards