NI Home > Community > NI Discussion Forums

LabVIEW

Showing results for 
Search instead for 
Do you mean 
Reply
Member
Shweta_Sridhar
Posts: 23
0 Kudos
Accepted Solution

2D data to Excel

I have a 2D array of numerical data that I need to save as an Excel file... How to do ?

Active Participant
NitzZ
Posts: 558

Re: 2D data to Excel

Hi,

 

If you have report generation tool kit you can use it for reading and writing into Excel. If you don't have it, then you can use Activex methods to do it. Check the attached VI. You will get a good understanding of doing it.

Regards,
Nitz

(Give Kudos to Good Answers, Mark it as a Solution if your problem is Solved:smileywink:)   

Member
Shweta_Sridhar
Posts: 23
0 Kudos

Re: 2D data to Excel

[ Edited ]

I do have report generation toolkit ... I don't know how to use it because I've never used it... :smileysad: 

 

How should I give the path where I want to save the excel file?

Trusted Enthusiast
P@Anand
Posts: 2,414
0 Kudos

Re: 2D data to Excel

Do you really want the Excel file or you can have a .xls file that you can view using MS Excel?. If you just need a file you have to view using excel then its very simple.

-----

The best solution is the one you find it by yourself
Member
Shweta_Sridhar
Posts: 23
0 Kudos

Re: 2D data to Excel

I really don't need an excel file :smileyhappy: ... viewing through Excel is enough :smileyhappy: 

Trusted Enthusiast
P@Anand
Posts: 2,414

Re: 2D data to Excel

Then you can do like this. I guess this should be sufficient

 

2D Data.png

 

Good luck.

-----

The best solution is the one you find it by yourself
Member
Shweta_Sridhar
Posts: 23
0 Kudos

Re: 2D data to Excel

[ Edited ]

Ya thanks... I found that the mistake which had been causing me a problem :smileyhappy: :smileyhappy: ... Thanks a ton :smileyhappy: