Spreadsheet and data analysis software from Microsoft.

learn more… | top users | synonyms

0
votes
1answer
46 views

Cannot get a text value from a numeric cell

Cannot get a text value from a numeric cell while reading numeric data from an xlsx file in apache poi excel read, the following is the code snippet to read data from excel I've mix of columns ...
1
vote
2answers
35 views

exporting test cases from TFS MTM to excel

My company has recently migrated to TFS and I'm using Microsoft Test Professional 2015 (MTM) for my test cases. I have created my test plan with requirement based suites to log my test cases against, ...
0
votes
0answers
12 views

Selenium_Copying entire column from excel without using iterator

Am new to selenium and I have the following query. Query: Am working in a project where I need to copy 4000 values from an excel in a single go and I need to paste that in the list box of ...
4
votes
1answer
237 views

How to fetch data from Excel to Rational Function Tester (RFT) automation tool?

I'm new to automation testing and also to RFT tool. I tried record and playback by hard-coded values. Now I want to make my scripts dynamic. Hence I use Excel as an external file to fetch data. How ...
0
votes
1answer
11 views

Is there any default defect template available, so that we can fill the sheet and upload to QC directly with all defects by the End of the day

We are forced to use HL ALM QC to raise defects. Currently we were using Rally to raise defects for Agile projects. But now on, we need to use HP QC, to raise the defects. For rally, i have created my ...
1
vote
2answers
51 views

Element is currently not visible" random text fields

I am getting this error "Element is currently not visible" when I try to input into textbox which is visible I've created a script to signup and I am getting this error randomly sometimes on ...
2
votes
1answer
43 views

appending data after reading from excel file in selenium web driver

I have written a script which reads data from excel file and I use sendKeys method to input that data to textbox. Now I want to append/concatenate data after reading from excel and than resultant ...
0
votes
1answer
64 views

how to use excel data with selenium webdriver? [closed]

i am on Beginning stage in SELENIUM. Now, i am trying functional testing on selenium web-driver. As driving EXCEL data is very essential on functional testing, i am struggling a lot in this are. ...
0
votes
0answers
19 views

What happens to the excel output of a Quality Center Traceability Matrix with 20,000+ test cases?

The max number of columns that Excel 2010 can support is 16,384. In the traceability matrix that's generated by excel, each test case is placed in a column. We have over 20,000 test cases (all of ...
2
votes
1answer
4k views

Excel Add In for Quality Center won't run in 64 bit excel - is there a workaround?

Our company recently upgraded everyone to Office 2010, the 64 bit version. This broke the functionality of the HP Excel ADD IN for Quality Center that I had been using. I prefer to write my test cases ...
1
vote
1answer
43 views

Excel worksheets: summarize a bunch of sheets using indirect [closed]

Current scenario I'm a data tester, and I test insurance contracts, and each policy has many "roles", "features", "history items" etc. A standard SQL query with all data joined will return 20-30 ...
2
votes
2answers
918 views

Testing pdf/excel content with C#

Our site has a good number of reports that are using SSRS,Crystal and Excel. We are using C# with Selenium WebDriver. I have been searching for the best practices and best ways and tools to test the ...
1
vote
6answers
1k views

Test suite, Test plan, Test cases for Android application

I have been asked to learn about Test Plan, Test Suite, Black Box Testing, Test Cases. Can anyone guide me in which order should I start learning? And also what are the necessary test cases for ...
1
vote
1answer
103 views

Alternative to MTM and excel for tracking manual test plans

We use to execute tens of manual tests plans sessions for identifying the build to be marked as release candidate and we mainly use Microsoft Test Manager and Excel. Both of them are fine but have ...
2
votes
2answers
2k views

Importing Test cases from Excel to TFS

I need to import test cases from Excel to TFS 2013. For this I have already gone through the link SQA and VSTS, but my issue is not getting resolved from these links. I can't use 'Test Case Migrator ...
2
votes
2answers
1k views

JUnit Framework - Selenium Webdriver - Excel Input Output - Apache POI

I would like to know, do we use Apache POI when interacting with Excel Files for Selenium Webdriver (under JUnit framework) or is there any better approach? Let me know if further clarity is ...
0
votes
1answer
2k views

Selenium framework using C# and excel

I am new to automation (Selenium ). I am working as manual tester and recently got a task related to selenium automation. I have basic knowledge of selenium and very good knowledge of C#. I can ...
2
votes
1answer
635 views

Excel VBA: convert R1C1 notation to A1 notation

issue I'm a "data tester" and I test websites by writing SQL queries then using Excel to process the data and validate data during test execution Sometimes we want to use R1C1 nontation in our VBA ...
0
votes
1answer
168 views

Setting Date & Time in java

I am working on report generation, for generating i need date&time[time stamp] telling when the report is generated, for this purpose i have created a method which returns formatted date time ...
1
vote
0answers
799 views

Function to write 2 D Array from java into Excel [closed]

I am writing a function which accepts array data as input,and according to the size of array I am filling to excel sheet. Also let me know is there any method get column size of array as array.leght ...
0
votes
1answer
297 views

Adding a threshold amount to an Excel formula for validation

I'm using Excel to highlight differences in two outputs that should be the same. My problem is that even if they're different by a value of 0.001 (which is technically correct), I want to add a ...
0
votes
2answers
267 views

Verify value range of data in an Excel sheet

An excel sheet having rows and columns, each cell accept 1 to 6 numeric values. How to check 1000 columns? what are the technique following for this?
1
vote
3answers
283 views

Ideas to implement offline smoke test for downloaded excel files

I run automated smoke tests for my web application, but until now, these tests are not covering offline excel spreadsheets that are downloaded by the user. I'm starting a study to find possible ...
1
vote
2answers
388 views

Auto Increment Test Case Number in Excel when New Test Case is Added

I am stuck with one issue which needs your help. Because of some bad requirement i am supposed to write my test cases in excel. Now Each Test case has a Serial Number. Because the test cases are more ...
3
votes
1answer
721 views

How to test an Excel macro that selects, groups, and counts data using SQL query?

This is the first time I encountered such a problem. There is an Excel table with a macro that selects data from the database using SQL query according to specific criteria. Data is grouped in ...
1
vote
1answer
628 views

Adding VBA Reference in QC Post Processing Script

I have a VBA script which i want to run in the post processing section of the QC 11 Excel Reports generator (using the UI, not the API). This script uses the Dictionary object in the ...
3
votes
2answers
2k views

How can I export test step description as plain text?

I'm using an Excel report from Analysis view to export the design steps to Excel: SELECT DESSTEPS.DS_DESCRIPTION FROM DESSTEPS However, DESSTEPS.DS_DESCRIPTION field looks like this: <html> ...
5
votes
1answer
3k views

Excel template for creating/retrieving/updating defects in quality center

Has anyone tried using an Excel template/macro for updating defects in Quality Center? Currently, I can use the Excel add-in to create new bug reports and then upload it to QC. But afterwards, I'd ...
2
votes
1answer
155 views

Can people recomend ways to test Excel Spreadsheets?

I'm not talking about the simple ones here, but the Spreadsheets which sprout arms and legs and start walking about and having a life of their own. They will always exist. Can people suggest ...
1
vote
1answer
525 views

How can I change the dates used in TFS 2010 SharePoint portal's burndown excel chart?

We have a TFS 2010 project (MSF Agile v5.0 template) project, the SSRS reports for burndown allow us to specify start and end dates for the current iteration, but the project portals excel charts ...