string's color setting in teststand

[cat099]

Hello ALL,

       i have been written a sequence in teststand,The purpose is write the test result to EXCEL,So pass the status' string of the step to EXCEL,i want set the color for the string of status.in order to can display in EXCEL file.

      And i creat a conditon for the operation.

      expression is

      RunState.Sequence.Main["8960_GPRS_Attached&transferring"].Result.PassFail ? tsGreen( RunState.Sequence.Main["8960_GPRS_Attached&transferring"].Result.Status):tsRed( RunState.Sequence.Main["8960_GPRS_Attached&transferring"].Result.Status)

     when check error,it does not work.

     I want to know how do to that.

     Thanks a lot

BR

Johnny

[Teds]

Let me get this right, you are setting the color of the string in TestStand based on the status.  Then you want to send the string to Excel, and have it colored in Excel?

Green = Pass, Red = Fail etc....

Are you then automatically writing Excel using LabVIEW or something from TestStand?

What exactly is not working?

Thanks

PH

[cat099]

Hi,Teds,

     Thanks for you reply.

     Yes,i want to write the status string to excel and can display the different color on the different status.

     Now i can write the test data to excel with using labview.and using the toolkit(report generator toolkit 1.1.0 for labview8.5).and it works well in

my teststand4.2-sequence.My meaning is want to pass the special string(colored) to EXCEL with using teststand expression.

     My expression is wrong.Beacause when i checked the expression.

     erorr message is "error in call to teststand API member 'sequencecontext.tsgreen'.Method 'tsgreen' does not exist in interface 'sequencecontext'"

     i want to know how to do that.And or if the teststand does not support this function?

     Thanks.

BR

Johnny

[Ashwin_S]

Hi,

If you have to include the color in the Excel (text or Background), Excel COM can be used. You can control each cell in the Excel sheet using that. You can write the code in LabVIEW or Teststand itself.

AshwiN,

[cat099]

Hi AshwiN,

     Thanks.

      It seems that only configurate the setting in EXCEL.

BR

Johnny