04-13-2012 12:25 PM
I am aquiring 4 different types of data continuously and I need to put each in a seperate column in excel. What should I do?
(Building these data in 2D array is not an efficient way, is there any other way)
04-13-2012 01:04 PM - edited 04-13-2012 01:04 PM
Writing to a real Excel file using ActiveX is a resource hog.
04-13-2012 01:10 PM
I am not experienced with ActiveX.
Could I have more detailed explanation.
04-13-2012 01:25 PM
ActiveX is technology from Microsoft and it provides a means for LabVIEW (or any other program) to access a program that has implemented it. If you truly need to update an actual Excel file, then ActiveX is what you need to use. The easiest way is to purchase the Report Generation Toolkit.
Your question is very ambiguous and needs more details. If you have rows and columns to insert, by definition, that is a 2D array. What do you find so inefficient?
04-13-2012 01:32 PM
I had the same question before and I was directed to this webpage
http://zone.ni.com/devzone/cda/epd/p/id/1803
I think it's very useful
04-13-2012 01:46 PM
I am telling you the data are continuously aquired
whihc means the 2D array that will be created will be very huge since my data are aquired in milliseconds
04-13-2012 01:46 PM
I am telling you the data are continuously aquired
whihc means the 2D array that will be created will be very huge since my data are aquired in milliseconds
04-13-2012 02:29 PM
@ahmadainnn wrote:
I am telling you the data are continuously aquired
whihc means the 2D array that will be created will be very huge since my data are aquired in milliseconds
You tell us that you want to write to Excel and we tell you how to do it.
So what is the problem?
04-13-2012 04:30 PM - edited 04-13-2012 04:32 PM
why are you talking to me with this tune?
the comment I had was an answer to Dennis_Knutson's question
04-13-2012 04:47 PM
You are not making any sense. I don't understand what you are asking. If you have a large amount of data, then decimate it or don't save it to Excel.