Save 2 separate data imports in separate worksheets on the same ex
I am using the 'TD Generic SQL Report' utility to extract data by querying
the project tables in Mercury Quality Center and dump the results into an
excel file. Each time I run a query in the utility program and specify a file
location, it dumps the data into a new worksheet (named Sheet4)in the file.
I want to take 2 separate extracts and dump the results in two separate
worksheets in the same excel file. For example, I run a query on test results
and one on defects. I want to dump the test results in Sheet1 of a.xls file
and
the defects data dump into Sheet2 of the same file i.e., a.xls. Is there a
way I can do this ?
How can I save 2 separate data imports into 2 separate worksheets on the
same excel file?
|