Read XLS data

[Cory_K]

I don't want to be one of those guys that ask questions that have been answered dozens of times (especially about excel) but I have a quick question.

The end goal is open an xls file, do some stuff, then save as csv. Pretty simple, and most of the code is done.

I found some code (Smercurio_fc, 2010) that does nearly exactly what I am looking for.

The one thing I would like to modify is the fact that it makes you select a range.

I would like to load all of the data in, rather than a subset of the data.

How could I modify the code such that I can remove the range function without breaking the rest of the code?

Thanks in advance!

[Wayne.C · Accepted solution]

Try this.

Be aware that I saved this with the Index on the Array indicator set for some far out values.  Might look like it didn't do anything at first glance.

[Cory_K]

Thanks a lot Wayne, I will try the VI this afternoon, I appreciate the help.