Hot answers tagged

7

I do not have any examples but I can describe an experience, albeit more about written test cases than about using Excel. When I started my previous job, test cases were not written down. Moreover, the IT department was openly hostile to the QA team; asking for a server as a test case repository was a non-starter. As an intermediate step, I picked an ...


7

I made this sample spreadsheet for a project named Gmail (download it here). Some comments: Test Case ID: use this value to link each bug with one or more Test Case IDs. Test Case Description: they may be independent from each other or something like Run Test Case ID 4 Click on "submit" The Status columns (the ones with the colours) are pretty self-...


6

I had the same issue when migrating tests from a legacy tool to TFS. It was simply not possible, independent of any choices offered by Excel and TFS (really, I tried them all and wrote a 43 page document about my test conversion efforts). Finally I was able to workaround the issue like this: In TFS, switch to the grid view In Excel select all steps and ...


3

I think I can point you in the right direction for MS Word, at least. You can use the Office Interop Assemblies in C#. Here is an example from .Net Pearls: using System; using Microsoft.Office.Interop.Word; class Program { static void Main() { // Open a doc file. Application application = new Application(); Document document = ...


3

Your filename is illegal, colon : is not allowed in files names. 2015.02.10_12:18:41_report.xlsx Also see: https://stackoverflow.com/questions/1976007/what-characters-are-forbidden-in-windows-and-linux-directory-names I would replace getCurrentTime() with a timestamp or a GUID if the name needs to be unique. If you need the date remove the illegal ...


3

To check that cells in excel sheet contain values between 1 and 6 do the following, Select all the cells that you want to check. the header of excel click in Conditional Formatting. In the drop down menu that appears click on new rule. A New Formatting Rule window will appear. Select rule type - Format only cells that contain. Now look at the edit rule ...


2

As a consultant, I am often sent to a client who does not have a test case management tool. It can be a short contract which would not last as long as the time it would take to introduce a test case management tool and teach the users how to use the software. With Excel, I can format a basic test case template for use by myself or the client within minutes. ...


2

I guess this link should answer all your questions.


2

Our shop uses ALM 11.00 (new version of QC) but on the add-in page it specifically says the following Excel versions are supported: Versions supported: Microsoft Excel 2007 and 2010 (32 bit) with HP ALM 11.00. I would uninstall office 2010 and restall it as a 32 bit version. THe 32 bit version works on a 64 bit machine and I'm able to use the excel plugin ...


2

These numbers are just temporary numbers rather than serial numbers. It doesn't seem like a good idea to rename (renumber) a test case once it's been defined. When there's a future failure, it's harder to find results for that test case from a previous run if the test case name/serial number has changed. Is it necessary to have the test cases numbered in ...


2

You can read/write Excel files with Apache POI or JExcelApi Java libraries. Below are few examples. Apache POI writing spreadsheet example: import java.io.*; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFCell; ...


2

solution use the Excel Address function


2

Webdriver is a browser manipulation API only and as such the ability to read office or PDF files is out of scope of its capabilities, but the office interop libraries will allow you to read data from office files in C#, and there will be similar libraries for reading PDF documents.


2

Just use an Excel library to load data from Excel files and use that data in your Asserts? C# and Excel: https://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c C# and Asserts: https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.unittesting.assert.aspx


2

The above worked well, but it only works for brand new test cases. If you have test cases that already have a test ID, you have to copy and paste individual steps and results to each test case. I learned that the hard way!!


2

Test Plan Test Suite Black-box Testing Test Cases Test Plan: In Test plan you can understand whole application, Flow on your android application and after create test plan & test cases. Black-box testing: Testing without having any knowledge of the interior workings of the application is called black-box testing.Black box testing includes only input ...


2

I would suggest not to use Thread.sleep() method, instead you can use the implicit wait, add following line of code after driver is declared. driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS); and remove all Thread.sleep() methods from the code. Difference between implicit wait and Thread.sleep() is Thread.sleep() method will wait until ...


2

The Team section on excel will allow you to connect to and export any TFS query you have access to. Queries will work against any TFS object that has a base type of Work Item. Since a requirements-based test suite uses (in the Scrum template) Product Backlog Items and Defects to define requirements, you need to build a query in TFS that includes linked work ...


2

Yes, that is possible for an example see this question: https://stackoverflow.com/questions/7157994/do-not-want-images-to-load-and-css-to-render-on-firefox-in-selenium-webdriver-te I am wondering if Selenium is the right crawler to get text from a website. If you need to crawl dynamic sites than a headless browser like PhantomJS will be much faster: https://...


2

Having done some further investigation myself, it appears there are multiple ways to extract parts of the tests from Zephyr. If you use the 'Search' function to locate a test and then choose to Export via the Export button in the test case frame itself then you get a summary of the test information but WITHOUT the test steps. If you use the 'Search' ...


2

Here is the Attributes: Data Source Types and Attributes Excel, ".xlsx" format [DataSource("System.Data.Odbc", "Dsn=Excel Files;Driver={Microsoft Excel Driver (*.xls)};dbq=|DataDirectory|\\data.xlsx;defaultdir=.;driverid=790;maxbuffersize=2048;pagetimeout=5;readonly=true", "Sheet1$", DataAccessMethod.Sequential), TestMethod] where "data.xlsx" is the ...


2

This may be helpful to you.. Open the Excel sheet and select all (Ctrl+a) then right click and click Format cells then in number tab change the category to Text and click Ok...


1

sendKeys(objExcel.getCellData("Fname",i) + "@example.com"); Hope I understood your question correctly (just wondering).


1

There is several issues here. An implicit wait would do far better than the Thread.sleep() Using Xpath to search by id. Just use by.id() it will be far faster The ids, to me, appear to be dynamically created which will cause them to break. If the rest of the script works I would presume this is not the issue though. Use new WebDriverWait(driver,10).until(...


1

My favorite test management tool is Test Rail. This is a web based test management solution. I've found it to be easy to create and modify multiple test plans and tests. It also integrates with TFS and Visual Studio ( I don't have first hand experience with that however. We are a Atlassian/GIT shop). It is easy to generate test reports and custom test runs ...


1

Honestly, today I believe that most businesses don't care for many papers, delivered value, go for it. Forget test cases, test plans. A mind map can help you much more. Today most environments are agile, no one has time to look at thousands of papers with a lot of text. Using a mindmap you can "draw" your ideas and be faster and intuitive.


1

I have been asked to learn about Test Plan, Test Suite, Black Box Testing, Test Cases I would like you to summon our search god, known to us as Google. One query and there is a bucket full of results returned, which have all the information that you need. I expect, most likely your prayer would be answered. Go by this order : Black Box Testing : A ...


1

Generally when it comes to implementation , correct order is : 1 - Create Test Plan 2 - Create Test Cases 3 - Execute Test Cases [It includes all testing. i.e Blackbox] what are the necessary test cases for application testing? Mostly it is depends on what flow and functionality application includes. You can check common mobile application check list :...


1

For this first you need to create an excel, in which yo have specified first row as the column/field names like FirstName, LastName, Address and DOB etc. in the first row and values in the subsequent rows of the same sheet. Save this file (better to save as CSV as they are more lighter than Excel and will not decrease performance when you have a number of ...


1

After waiting long for this question, I am answering it myself. I too searched a lot but didn't get any way for importing test cases from Excel to TFS in right format. One has to use Test Case Migrator Plus for importing test cases from Excel to TFS. Perhaps Microsoft has restricted import from Excel to TFS (using tags as described in question) for avoiding ...


Only top voted, non community-wiki answers of a minimum length are eligible