08-29-2018 05:11 AM
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
08-29-2018 06:24 AM
08-29-2018 07:16 AM
Thank you I try it but it still the same
08-29-2018 07:29 AM
How did you try?
08-29-2018 09:02 AM
Adding the worksheet is not enough. You also need to make the new worksheet the current one by using Excel_Get_Worksheet.
08-29-2018 10:08 AM - edited 08-29-2018 10:12 AM
@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
08-29-2018 11:57 AM
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:
08-31-2018 06:26 AM
Hallo
attached you can find the whole Project , i try to do it but it's not work
09-04-2018 12:17 PM
There are many issues/unknowns in your code, but there are 3 directly related to the Excel sheets.