capacitor tester

[altenbach]

---

Mark1357 wrote:

I'm nearly done now, I just have one more quick question, I need to save data from an array to an excel document, it doesn't work with the "writespreadsheetfile"

---

I what way doesn't it work? Show us the code!

"Write to spreadsheet file" does not generate excel files. Same if you format the array into a string and write it to a file. However, writing to a tab delimited text file, will generate a file that can be read by excel.

If you want to write to a plan text file as you apparently are attempting, convert the array to a string using "array to spreadsheet string". Also note that all you need is "write to text file", opening and closing are automatic. Simplify! 

[Mark1357]

Hi Altenbach

it's just a for loop with build array, array size, shift registers, and I'm tapping of the data there so I can send it to a text file or excel file or whatever, as long as the data from 10 measurents in the loop get saved.

[altenbach]

---

Mark1357 wrote:

it's just a for loop with build array, array size, shift registers, and I'm tapping of the data there so I can send it to a text file or excel file or whatever, as long as the data from 10 measurents in the loop get saved.

---

I'd rather see a code picture than trying to interpret and translate text descriptions. 😄

[Mark1357]

Sorry I came back so late to mark this thread, I marked your post as the solution, I didn't use it though, I ended up adjusting my own a bit, but I can see how yours would be a better solution if completed.

just out of curiosity, how do you add frames? when I tried to add frames they all go pink and you'll get an error in the vi, it doesn't accept the extra frames.

[johnsold]

When you say "frames" I presume you mean cases of the case structure?

The selector terminal is wired to an enum (stands for enumerated data type). Notice that the Selector Label values match the enum string values. To add cases you should first add items to the enum. However, the only copy of the enum in the VI is a constant. If you pop-up on the constant you have options to Add Item Before, Add Item After, Edit Items.., and others. Selectin Edit Items brings up a dialog box which allows you to make multiple changes at one time.  If you will be using the enum in more than one place or will be making copies of the constant, it is a good idea to make it a typedef so that any changes will automaically propagate through your VIs. After you have added items, popping up on the case selector label will have a new option: "Add case for every value." You can also use Duplicate Case which will create a new case identical to the one showing but with the first unused enum string as the case selector label.

Lynn