This is a migrated thread and some comments may be shown as answers.

writing data to excel sheet

26 Answers 395 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

26 Answers, 1 is accepted

answered on 31 Dec 2010, 04:58 AM

Hi Madhu,
WebUI Test Studio includes the Element Extraction feature which you'll probably want to use.

Check out this video:
http://tv.telerik.com/watch/automated-testing-tools/using-element-extraction-variables-webui-test-studio

Once you've extracted a value you can access it from a Coded Step with the following code:
String extractedValue = this.GetExtractedValue("MyExtractedVariableName");

To add a Coded Step on ScriptStep in the Record View (see screenshot 1). This will create a new (C# or Visual Basic) method where you can write your own logic.

You'll have to write your own logic to store data into an Excel file. It's not very complex and you'll find plenty of tutorials on the Internet.
Keep in mind that it will probably require that additional Assembly references to your project. Here's an article that describes how this is done in case you need to do it.

Let me know if you need more assistance with this!

All the best,

Stoich

the Telerik team

Interested in Agile Testing? Check out Telerik TV for a recording of Automated Testing in the Agile Environment

answered on 31 Dec 2010, 08:05 PM

Assembly_Reference_is_not_adding.zip

Hi Stoich,

Thanks for detailed solution.

I'm able to extract value into a variable [$(Result)], now trying to add Assembly Reference (Microsoft.Office.Interop.Excel.dll) from C:\WINDOWS\assembly to my project, but it doesn't work (see enclosed video capture). The same DLL trying to drag to other location also not working? If DLLs are in other location say C:\Program Files\Telerik\WebUI Test Studio 2010.3\Bin those are adding without any issue. Bottom line: C:\WINDOWS\assembly DLLs are unable to add to Project References under User Settings.

Suggestion/Request: Storing extracted values into Excel sheet is common in as part of test automation; adding DLLs and writing a code to store data back to excel is challenging to testers more over time consuming. Anyway, we are binding a data source in the form of excel/csv taking the reference of the column name in excel and store extracted value into the same column?

Accepted

answered on 04 Jan 2011, 05:10 PM

Hi Madhu,
don't add them from the Global Assembly Cache (C:\Windows\assembly). That's not really a folder in the normal sense of the word.

Instead add them from their "real" location on the file system. (like I'm doing in this video). After you add an Assembly take a look at the name under which the assembly was added to the list. If the name consists of the path to the location of the DLL file then you'll need to add it to the Global Assembly Cache as described in this article this article.

I've created feature request:
103917:FR> Writing data to excel sheet (instead of reading as in Data Binding)
to address your request. We'll discuss it soon.

I hope this helps!

Let me know if you have any more questions.

Best wishes,

Stoich

the Telerik team

Interested in Agile Testing? Check out Telerik TV for a recording of Automated Testing in the Agile Environment

Accepted

answered on 30 Jan 2014, 03:48 PM

try{
System.Data.OleDb.OleDbConnection MyConnection ;
System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
string connectionpath =" "; //Include Directory path and filename here
MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ connectionpath +";Extended Properties=\"Excel 8.0;HDR=No;\"");
MyConnection.Open();
myCommand.Connection = MyConnection;
string Variable = "foo"
myCommand.CommandText = ("UPDATE [Sheetname$A2:A2] SET F1='" + Variable + "'"); //Set cell A2 in the sheet "Sheetname" F1 (is the field) to the Variable string
myCommand.ExecuteNonQuery();
MyConnection.Close();
}
catch (Exception ex)
{
Log.WriteLine(ex.ToString());
}

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

writing data to excel sheet

26 Answers, 1 is accepted