Dionysus New Year Present – Ninja & Excel

[forrestang]

If someone has the .dll files needed to use in conjunction with office 2010, can you let me know if you were able to find them for download some place?

[NinjaTrader_Bertrand]

If someone has the .dll files needed to use in conjunction with office 2010, can you let me know if you were able to find them for download some place?

Believe this would be the dll content needed - http://www.microsoft.com/download/en...s.aspx?id=3508

[forrestang]

So the readme in that file does say that the two files are in there. Also, looking in the location shown in the attached pic does show those two file names. But I do not think they are dlls, and they cannot simply be copied and pasted into the NT7 folder.

Where might the files be located after install?

[NinjaTrader_Bertrand]

Can you check into the C:\Program Files (x86)\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\Office12 folder?

[forrestang]

Can you check into the C:\Program Files (x86)\Microsoft Visual Studio 10.0\Visual Studio Tools for Office\PIA\Office12 folder?

Actually, I don't have Visual Studio 10 on my PC. In that location, I only have MS Visual Studio 8. I looked through this folder, and there aren't any interop files in there.

The install of that PIARedist went ok and seems to have installed fine, but I have been unable to find the files listed in the readme for that installer.

[NinjaTrader_Bertrand]

Have you tried a Windows search for the DLL needed? It might install in a different folder if you're not running VS.

[forrestang]

Have you tried a Windows search for the DLL needed? It might install in a different folder if you're not running VS.

Yes, I have tried quite a few. Either I am searching wrong, it's not there, or it's hidden?

[forrestang]

Yes, I have tried quite a few. Either I am searching wrong, it's not there, or it's hidden?

Haha! I guess that was it, unhiding all things in folder options showed the two files. Attached are the two locations of the two files needed.

I will see if I can get everything to work now.

Woot!!

[forrestang]

Got it!

I got everything to work, with the sample file, so I should easily be able to accomplish what I want now.

Thanks for the help.

[NinjaTrader_Bertrand]

I got everything to work, with the sample file, so I should easily be able to accomplish what I want now.

Thanks for the help.

Glad to hear that forrestang.

[forrestang]

Question if anyone can figure it out.

In the example:

                excelRange = excelSheet.get_Range([COLOR="Red"]"B1","B201"[/COLOR]);
                excelRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.DarkBlue);
                excelRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Cornsilk);
                excelRange.Font.Bold = true;
                excelRange.ClearContents();

This is how you change the properties of a range of values, in this case the cells from B1 to B201.

I am wanting to color some cells based on certain conditions, so for that I will want to individually color cells.

The problem with the above reference is that it sets up the initialization using "B1," using letters, where I have my cells picked out by row/column number. So this is a problem, as it

Does anyone know how to be able to change specific cells color by referencing with Row/Column numbers instead of the actual Letters(B1,B200)?

References:

http://msdn.microsoft.com/en-US/library/kw8z8fzk(v=vs.80).aspx

http://msdn.microsoft.com/en-US/library/4zs9xy29(v=vs.80).aspx

[sdruley]

Thank you so much

Your work to connect Ninja Trader to Excel is extremely well done.

One would expect that a good portion of the technical effort of Ninja Trader would fall into the white spaces, ie. the interfaces between data providers and Ninja and the interfaces between Ninja and Excel users (customers).

I find it odd that it took the expertise of a customer to develop the solution to this challenge.

Your solution adds tremendous value to the Ninja product.

Stephen Druley

[bondcrash]

Hi there,

does anyone know if the method suggested in this tread works for PULLING LIVE FEEDS IN EXCEL from Ninja? I need some FX live feeds and I am thinking to get them from Kinetick but I just want to be sure that I am not wasting time and money... Does anyone know if the resulting connection is stable (no stale feed etc)?

Many thanks
BC

[DionysusToast]

Haha! I guess that was it, unhiding all things in folder options showed the two files. Attached are the two locations of the two files needed.

I will see if I can get everything to work now.

Woot!!

lol! So it was there all the time....

Jeez..

Good stuff!

[DionysusToast]

Question if anyone can figure it out.

In the example:

                excelRange = excelSheet.get_Range([COLOR="Red"]"B1","B201"[/COLOR]);
                excelRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.DarkBlue);
                excelRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Cornsilk);
                excelRange.Font.Bold = true;
                excelRange.ClearContents();

This is how you change the properties of a range of values, in this case the cells from B1 to B201.

I am wanting to color some cells based on certain conditions, so for that I will want to individually color cells.

The problem with the above reference is that it sets up the initialization using "B1," using letters, where I have my cells picked out by row/column number. So this is a problem, as it

Does anyone know how to be able to change specific cells color by referencing with Row/Column numbers instead of the actual Letters(B1,B200)?

References:

http://msdn.microsoft.com/en-US/library/kw8z8fzk(v=vs.80).aspx

http://msdn.microsoft.com/en-US/libr...(v=vs.80).aspx

Can't you just have a method that converts your row numbers to letters?