Showing results for 
Search instead for 
Did you mean: 
Reply

2D data to Excel

Solved!
Go to Solution
Highlighted

2D data to Excel

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

0 Kudos
Message 1 of 7 (270 Views)
Reply
0 Kudos

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

Message 2 of 7 (266 Views)

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... Smiley Sad 

 

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

0 Kudos
Message 3 of 7 (259 Views)
Reply
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
0 Kudos
Message 4 of 7 (249 Views)
Reply
0 Kudos

Re: 2D data to Excel

I really don't need an excel file Smiley Happy ... viewing through Excel is enough Smiley Happy 

0 Kudos
Message 5 of 7 (242 Views)
Reply
0 Kudos
Solution
Accepted by topic author Shweta_Sridhar
‎08-27-2015 06:09 PM

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
Message 6 of 7 (236 Views)

Re: 2D data to Excel

[ Edited ]

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

0 Kudos
Message 7 of 7 (233 Views)
Reply
0 Kudos