Inputs are concatenated in same column in excel file

[mpeamg90]

Hi, I really need help in this urgently. The problem is when i open the spreadsheet file after running the program below, all the values i believe are concatenated in the same column. However, there are 2 different analog inputs which I want in 2 different columns. I am obtaining the 2 waveforms in the same chart but when i open the excel file, it seems that the inputs are concatenated in the same column. Anybody knows how to rectify this? Thank you very much.

[sabri.jatlaoui]

Hi mpeamg90,

you can use Export Waveforms to Spreadsheet File VI.

Regards

[ben64]

---

@mpeamg90 wrote:

Hi, I really need help in this urgently. The problem is when i open the spreadsheet file after running the program below, all the values i believe are concatenated in the same column. However, there are 2 different analog inputs which I want in 2 different columns. I am obtaining the 2 waveforms in the same chart but when i open the excel file, it seems that the inputs are concatenated in the same column. Anybody knows how to rectify this? Thank you very much.

---

To add to Sabri comment, you are using append waveform, so the second one is added at the end of the first one resulting in a single waveform (thus a single column).

Before the loop initialize the shift register with an array of waveform and in the loop add the loop iteration results to the corresponding array index waveform. After the loop use Export Waveforms to Spreadsheet Files.

Ben64

[mpeamg90]

Hi Sabri Jatlaoui,

I have aready connected the while loop to the export waveforms to spreadsheet file as shown in the 1st diagram at the right side of the while loop. Should I connect the build path and the app default data directory? I am not sure whether it will help to show the 2 waveforms in different columns in the spreadsheet file. I am attaching the original VI file, the VI file after I made the changes that you mentioned and the CSV spreadsheet file. Thank you very much. 🙂

[mpeamg90]

Hi Ben 64,

Thank you for your reply. I tried what you mentioned just now  by indexing the lop iteration to the waveform and exporting waveform to spreadsheet file.  I am not sure how to initiate with a waveform array. IIs there a possible mistake in my program? I have attached the file VI as well as the pic below. Help is much much appreciated. Thanks a lot!

[ben64]

Something like that. I'm not familiar with Dynamic Data type (and try to avoid it) so I'm not sure about the result of the append operation in this case.

[mpeamg90 · Accepted solution]

Hi Ben 64,

Thanks a lot again. I did as you said and I removed the Dynamic Data and connected the appended files directly to the results. I am yet to check whether the program works as I can only plug in when I go back to work tomorrow. Please tell me whether you think it might be able to work this time. Thanks a lot once again!