Excel Get last Column

[shawn1]

Hello,i can find the Function"Excel Get last Row" which can be used to get the Rows of a 2D Array. My question is how should i get the columns of a 2D Array, Because I can't find Function"Excel Get last Column". Please help me,Thank you very much.

[Rizwan00]

get the entire 2d array seperate that into two 1d array and rotate that two 1d arrays and get the first element so that u can get the last element of original 2d array...

[PalanivelThiruvenkadam]

Use Array Functions.Use SIZE of 2D Array and it will give you the Last Column Index

[Rizwan00]

try this

[P@Anand]

I don't see there is a VI available for getting the last column but certainly you can read the 2d data and index the last column.

[ben64 · Accepted solution]

You can easily create your own Excel Get Last Column.vi by modifying the Excel Get Last Row.vi code.

Ben64

[Bob_Schor]

Kudos to Ben and to NI, who provided Excel Get Last Row in an "unlocked" form to allow Ben (and anyone else sufficiently adventurous) to create the "missing" Excel Get Last Column.  Maybe NI will include this little gem in a future release of the Report Generation Toolkit.

Bob Schor

[shawn1]

Thank you ,but my input parameters is "EXCEL INSTANCE",So your way may not works. but Anyway,Thanks

[shawn1]

Hi Ben, Can you give me Excel Get Last Column.vi (Labview2013)?? I can't open this vi(Labview2015). Thank you

[Rizwan00]

get last column vi in labview 13 version...

There are  two ways to tell somebody thanks: Kudos and Marked Solutions