Create Excel sheet and write data in different sheet at same excel file

[SAED123]

Hello,

I made Program that take Temperature from Excel file and every Temperature we need to measure the impedance of DUT, the Program work very well ,but program write all data i need in same sheet i need the program wirte every Temp with measurement in different sheet. 

regards

[Artem.SPb]

http://zone.ni.com/reference/en-XX/help/370274J-01/lvoffice/excel_add_worksheet/

[SAED123]

Thank you I try it but it still the same 

[Artem.SPb]

How did you try?

[aputman]

Adding the worksheet is not enough.  You also need to make the new worksheet the current one by using Excel_Get_Worksheet. 

[Bob_Schor]

---

@aputman wrote:

Adding the worksheet is not enough.  You also need to make the new worksheet the current one by using Excel_Get_Worksheet. 

---

According to the Help for Excel Add Worksheet VI, "The new worksheet becomes the current worksheet".  If you are using the Report Generation Toolkit (from which these VIs come), it is always useful to "look around" for other useful functions, such as Excel Rename Worksheet.  To learn how they work, drop them on a Block Diagram, right-click, and choose Help.

Saed -- you say you tried to do this, and it didn't work.  Please attach your code "that didn't work", and we can probably show you how to fix it.

Bob Schor

[Michael_Munroe]

Your statements don't match your code.  Your temperatures are generated by a loop and your Excel file is created as a new report.  I'm going to guess that you meant to use the word COLUMN and not SHEET.  Your report is an array of 3 results from your instrument but you failed to insert the Temperature string into the output.

Issues with your code:

• The column header is written using Easy Table.vi to 0,0 but then included in the array of results
• The results are written as DBL to 0,0 replacing your header with zeros
• The results are written using Easy Table.vi starting at cell 0,0 with every loop iteration

[SAED123]

Hallo

attached you can find the whole Project , i try to do it but it's not work 

[Michael_Munroe]

There are many issues/unknowns in your code, but there are 3 directly related to the Excel sheets.

1. The number sheets inserted is determined by a local variable with a race condition. Just connect the wire
2. Each sheet is over-written a fixed 7 times
3. The entire Results file is over-written with every loop iteration.  Your final file will have data in only one sheet.