'.NET Object to Variant.vi' Cannot Handle 2D Arrays

[Flutee]

I am trying to read a range of cells from Excel and convert it to a LabVIEW array of Strings.

Unfortuantely, '.NET Object to Variant.vi' cannot handle 2D Arrays, even though you can convert 2D Arrays with 'To .NET Object.vi'. My workaround for this at the moment is to reference each cell in my range and use nested For Loops to recreate the array as a LabVIEW data type.

Has anybody found a solution better than this? 

Ps. Using LabVIEW 2014

[wiebe@CARYA]

>Unfortuantely, '.NET Object to Variant.vi' cannot handle 2D Arrays

Seems to work just fine to me. Do you get an error? Broken wire? Something you don't expect?

The result is a variant, you might expect a 2D array. The variant is a 2D array, but you need to use "Variant To Data" to convert it to a 2D array.

[aeastet]

I am having an issue here with 2D arrays as well. Here is what I am doing. 

This method used to work for active X:

What am I messing up here?

I do not get anything out of the Value2. I am getting an error 1172 which seems to be the go to for anything you are having issues with in .net. I'm not getting an error out of the Value2 property. I am getting the 1172 out of the .net to variant. Here is the error I am getting:

Error 1172:

Invoke Node in .NET Object to Variant.vi->Open Excel Workbook using .net.vi
<APPEND>
Method Name: <b>.NET:Convert Object To LabVIEW Variant</b>

[rolfk]

First step would be to wire that Variant to an indicator on the front panel. And then enable "Show Type" in the popup-menu. This will show you what the Variant knows about the internal data type it contains. From there you might have to do a specific conversion to make it work.

[aeastet]

It shows up as void. So I have to be doing something wrong before this. I am calculating a range (A1:AO414) and that seems to be working correctly. Can you give me another clue? I don't seem to be getting anything from the get range function. Is there a different or better way to get the worksheet ref? I am guessing that is where my problem lies.

[jcarmody]

Do you need to use .NET?  Here's a good tool - GitHub - dnattinger/read-xlsx-file: A VI that will read the contents of an .xlsx file into LabVIEW w...

[aeastet]

Yes I would like to do this in .net. I do not want alternates. I have a whole module that I wrote 15-20 years ago to use with Excel. It is more capable and easier to use than the report generation toollkit. I want to port it to something that is going to be supported moving forward. I keep hearing that Active X is going away. I am just trying to get ahead of the game. Plus it is a fun project to work on. If I can figure out how to get the data out I should be most of the way there. It just isn't working they way I expect and there is nothing anywhere that tells you why. It sound like a few people on here have figured it out. I am just hoping someone will point me in the right direction.

[aeastet]

I can ask for a single cell and I get the correct response. When I ask for a range I get nothing.

[jcarmody]

---

@aeastet wrote:

[...] easier to use than the report generation toollkit. [...] I keep hearing that Active X is going away. 

---

The one I linked doesn't use the RGT or ActiveX.  If that changes anything.

[Andrey_Dmitriev]

---

@aeastet wrote:

I can ask for a single cell and I get the correct response. When I ask for a range I get nothing.

---

Not sure if this helps or not, but maybe you're using an invalid range. AI tells me that Excel Interop uses 1-based indexing, so you should start the range from Cells[1, 1] instead of Cells[0, 0]. Just an idea...