NI Home > Community > NI Discussion Forums

LabVIEW

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: 555

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?

Active Participant
P@Anand
Posts: 1,690
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.

-----

I don't believe in Hard work. I love my work :smileyhappy:
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: 

Active Participant
P@Anand
Posts: 1,690

Re: 2D data to Excel

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

 

2D Data.png

 

Good luck.

-----

I don't believe in Hard work. I love my work :smileyhappy:
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: