From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
08-19-2014 12:51 PM
08-21-2014 06:17 AM
@Dennis_Knutson wrote:
It's a little unclear what you need. If you have two scalars, you can use the Build Array function to create a 1D array and with another Build Array, append to an existing 2D array using a shift register. If you just want to append new values to a file, the Write to Spreadsheet function does have a 1D input.
I have 2 Analog information(voltage and angle) from Analog system to my DAQ card. i want to save this informations in excel in 2 columns. column1: angle and column2: the voltage of that angle). thats all wich i want to do.
08-21-2014 06:49 AM
@Eram wrote:
@Dennis_Knutson wrote:
It's a little unclear what you need. If you have two scalars, you can use the Build Array function to create a 1D array and with another Build Array, append to an existing 2D array using a shift register. If you just want to append new values to a file, the Write to Spreadsheet function does have a 1D input.I have 2 Analog information(voltage and angle) from Analog system to my DAQ card. i want to save this informations in excel in 2 columns. column1: angle and column2: the voltage of that angle). thats all wich i want to do.
What is wrong with using the Write Spreadsheet file? Show us your code so we can see where you are stuck.
08-21-2014 07:15 AM - edited 08-21-2014 07:24 AM
I don't have access to DAQ card now,so for example i choose 2 parameter (x and x^2).i'm going to change x manually and save x and X^2 in a excel file.and draw the chart. but i can't do it as easy as it seems to be ! i don't know what's the problem? this vi is attached .
thanks a lot...
08-21-2014 08:03 AM
I have problem when i want to enter data save-path in file spreadsheet ! i don't now what is destination file format?
08-21-2014 08:05 AM
The Write To Spreadsheet File saves the data in a delimited text file. By default, the delimiter is a tab.
08-21-2014 12:07 PM
@crossrulz wrote:
The Write To Spreadsheet File saves the data in a delimited text file. By default, the delimiter is a tab.
thanx a lot . now i can see one result in txt format file.
but when i press Run button it wants a destination.i choose any destination even file.txt .but it wants another destination imediately and in every text file there is just 2 data (x and X^2). i mean i don't have series of data during changing the input number. the file is attached below...
thanks for your quick and useful responses...
08-21-2014 12:22 PM
08-24-2014 01:01 PM
@Dennis_Knutson wrote:
Please turn on Context Help and read about Write to Spreadsheet File.
To avoid the file path dialog, use a front panel control outside your main loop or a shift register to pass the path from the first iteration to successive ones.
You have to tell the function to append as noted in the help.
I read about spredsheet,but i don't understand it . there is something about active X and,... . .But i became a little confused!!
how can i use shift register? do shift register let me to have all data in a page?
thanks
08-24-2014 01:24 PM