Why is the Office Import Tool unable to import requirements from multiple worksheets in an Excel file?

0 Likes

Problem:

Why is the Office Import Tool unable to import requirements from multiple worksheets in an Excel file?

Resolution:

When an Excel document is imported into SilkCentral Test Manager, it is assigned a project ID. This ID refers to the SilkCentral Test Manager project that the requirements were imported into. Each .xls file is assigned an individual ID (NOT each worksheet). Therefore when attempting to upload a second, third or fourth worksheet etc from the same Excel file, SilkCentral Test Manager believes it’s an updated version of the first worksheet and not an additional worksheet. Hence, it deletes the old requirements from the first worksheet and adds the new ones.

Multiple worksheets are not supported by the Office Import Tool. Users will need to use individual xls files and not multiple worksheets.

Old KB# 24981
Comment List
Anonymous
Related Discussions
Recommended