Log test data into single file

[shaik89]

Hello, 

Am using report generation tool kit to log my data after the completion of test, for every time after the completion of test new excel sheet is getting created but i want all the tests data of whole month to be in single file.

Please help me

Best regards,

Ali

[shaik89]

I am using same Vi

please find the attached snapshot.

I dont want this excel to be created for every time , i would like to have a single excel sheet and all the test data should be there , i.e it should not overwrite the data ,it should append the data.

please please help me

[Bob_Schor]

Please, please, attach your actual VI rather than a picture of your VI.  We can't "edit" the VI, we can't click-and-^H for Help on a function we don't recognize, etc.

When you open a New Report for Excel, you can specify an existing Excel file for the Report Generation Toolkit to use.  It will replace cells that are in the file, so you can simply position your new entries after all of the existing rows.  Fortunately, there's a function on the Excel-Specific, Excel-General Palette called Excel Get Last Row that can help you.

However, you also have to save the file, which you do just before you Dispose the Report.  That seems to be missing from your code.  You'll want, of course, to wire the same Path you used for the "Template" to the Report File Path input.

Bob Schor

[shaik89]

Hello Bob,

Please find the attached Vi as well as sample template.

Regards,

Ali

[cbutcher]

I attach a slightly modified VI using your community.vi. Hopefully you'll agree it's a little easier to read.

It uses the VI that Bob mentioned to get the last row. Your sample seems to calculate the last row as 63, I'm not sure why. After the first call, this VI works fine (wire the sample the first time, I guess the first time each month for you. You could check if the file exists, and if so, wire the file, otherwise wire the sample, for example)

Data is appended to the end of the file. I'm not quite sure what you want in the header section so I left it as it was. Default values are provided.

[cbutcher · Accepted solution]

Backsaved as requested in PM to 2015.

[shaik89]

Thank you Cbutcher and Bob

I have made some changes in my code.

Thanks for all your responses.