Spreadsheet and data analysis software from Microsoft.

learn more… | top users | synonyms

-1
votes
0answers
20 views

How to add arrays for IList<IWebElement> to write excel

Iam using this code (someone suggested me to use this) for writing excel, but it is also slow, pls chk this and suggest me how to improve speed of writing, sumone told me to use 2D arrays, but m not ...
0
votes
2answers
134 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 ...
0
votes
1answer
24 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
170 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
38 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
109 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?
0
votes
2answers
207 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 ...
1
vote
3answers
199 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
1answer
476 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 ...
1
vote
1answer
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 ...
1
vote
1answer
3k 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 ...
3
votes
1answer
544 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 ...
4
votes
1answer
2k 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
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> ...
2
votes
1answer
131 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
496 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 ...