How do I delete a blank line from an excel spreadsheet

[gav21]

I am currently using the code below to output an array of strings to an excel template.  I am getting a blank row to appear in between all my data sets.  Any Ideas on how to get rid of it.  I am new to Labview and have had no formal training.  Sorry if the program is poorly written or something just doesn't make any sense. Thanks in advance.

Code:

http://www.imagebam.com/image/4fd4cc10167749

Output File:

http://www.imagebam.com/image/7e08f110167751

[MikeS81]

Hi gav21,

why do you write your data and read it directly after? Is the empty line already there? It would be better if you attach your images, because then it´s also possible to understand your thread in 5 years.

Mike

[gav21]

I did that so I can append my data to the output file.  And like I said I have had no training in Labview so im not exactly sure what im doing.  If you know of a better way of doing this i'm up for suggestions. Sorry copied the wrong URL here are the actual pics.

Code:

Output File:

[MikeS81]

Hi gav21,

thanks for the images. Can you upload your vi? Create a probe on your wire between the insert into array function and the write to spreadsheet file function. Maybe you can see the empty line (right click on the wire and select probe).

Mike

[gav21]

Mike,

I tried the probe and didnt see the blank space at the end. I have attached the vi.  I have a set of dynamic data coming in i believe its just 23 numbers and then I am adding a comment in front of that and then appending it to an excel template.  Thanks for the quick responses!

[MikeS81]

Hi gav21,

do you really need to save the file? If you call the vi more then ones, then you get the empty line with your array conversion. See the attached example, it shows another way to get the data two a 2D array.

Mike