LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

create excel file from 2D array

Solved!
Go to solution

@GerdW wrote:

Hi Saed,

 

did you do any of the suggestions on your own?

 

Try this:

check.png

I don't claim to create "efficient" code, but that should work!

Note that subtle change of the filepath constant…


Thank you again I do something but also the same problem occurs do you have idea why every iteration the program ask me to choose the excel.

 

regards

0 Kudos
Message 11 of 16
(1,105 Views)

Hi Saed,

 

WTF are you trying to do there?

Why create/write a CSV file, just to read its content and to stuff it into a (real) Excel file???

 

do you have idea why every iteration the program ask me to choose the excel.

Yes, I have an idea.

Spoiler
You forgot to wire a filepath to WriteDelimitedSpreadsheet!

Why don't you follow the suggestions you get here?

Why complain about problems, rising just from that stupid cunfusing behaviour?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 12 of 16
(1,101 Views)

@GerdW wrote:

Hi Saed,

 

WTF are you trying to do there?

Why create/write a CSV file, just to read its content and to stuff it into a (real) Excel file???

 

do you have idea why every iteration the program ask me to choose the excel.

Yes, I have an idea.

Spoiler
You forgot to wire a filepath to WriteDelimitedSpreadsheet!

Why don't you follow the suggestions you get here?

Why complain about problems, rising just from that stupid cunfusing behaviour?



@GerdW wrote:

Hi Saed,

 

WTF are you trying to do there?

Why create/write a CSV file, just to read its content and to stuff it into a (real) Excel file???

 

do you have idea why every iteration the program ask me to choose the excel.

Yes, I have an idea.

Spoiler
You forgot to wire a filepath to WriteDelimitedSpreadsheet!

Why don't you follow the suggestions you get here?

Why complain about problems, rising just from that stupid cunfusing behaviour?


again thank you, I'm trying all suggestions and members  take time to answer me ,so i'm just looking for a new idea to solve the problem, i don't need to create .CSV i need to create real Excel file 🙂 

 

regards

0 Kudos
Message 13 of 16
(1,097 Views)

Hi Saed,

 

i don't need to create .CSV i need to create real Excel file 

Then why do you create a CSV first, just to immediatly read its content and write it to Excel?

Why not write the content directly to Excel?

I really wonder how you are developing software…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 14 of 16
(1,095 Views)

I'm beginner with labview.


@GerdW
0 Kudos
Message 15 of 16
(1,092 Views)
Solution
Accepted by SAED123

I checked the program I sent you and the writing to the excel file works fine.

I recognize the program is not the most efficience  but it should work.

 

Here some advices for you :

 

- Try to fit your program in one screen so you don't have to travel in your diagram

- Put a wait function in your while loop to free your processor

- Create your file before your while loop and append the measurements in your while loop

 

I hope it helps you.

 

Regards,

 

 

Download All
0 Kudos
Message 16 of 16
(1,087 Views)