C#-MSTest-Excel Data Driven of .xlsb and .xlsb files using the Data Source issues

Question

Hi,

When the '.xlsb' file is being data driven/read, an additional empty row is being executed or stored and the character "d" is randomly generated.

public class DataDriven
{

    private TestContext _testContext;  

    public TestContext TestContext  

    {  

        get { return _testContext; }  

        set { _testContext = value; }  

     }          

    [TestMethod]  

    [DataSource("System.Data.Odbc", @"Dsn=Excel Files;dbq=CreateBugXlxs.xlsx", "CreateBug$", DataAccessMethod.Sequential)]  

    public void TestDataDriven()  

    {  

        Console.WriteLine(TestContext.DataRow[0].ToString());  

        Console.WriteLine(TestContext.DataRow[1].ToString());  

        Console.WriteLine(TestContext.DataRow[2].ToString());  

        Console.WriteLine(TestContext.DataRow[3].ToString());  

        Console.WriteLine(TestContext.DataRow[4].ToString());  

}

Screenshots:
Issue Reference:

Working Reference:

Update to the issue:

Added a new sheet such as "Sheet1" and when the below code is executed the warning is displayed without any details and data reading is unsuccessful.

Please Note: The issue occurs in ".xlsx" and ".xlsb" files

Code:

[TestClass]
public class TestCreateBugXlxs
{
private TestContext _testContext;

    public TestContext TestContext  
    {  
        get { return _testContext; }  
        set { _testContext = value; }  
    }  

      
    [TestMethod]  
    [DataSource("System.Data.Odbc", @"Dsn=Excel Files;dbq=TestCreateBugXlsb.xlsb", "Sheet1$", DataAccessMethod.Sequential)]  
    public void TestBugXlxs()  
    {  
        Console.WriteLine(TestContext.DataRow[0].ToString());  
     }  

}

Answer 1

Hi @vadivel sekar ,

Welcome to Microsoft Q&A!

You can have a try with the following code and check if the same situation exists or not:

 Console.WriteLine(TestContext.DataRow[“Severity”].ToString());       
 Console.WriteLine(TestContext.DataRow[“Hardware”].ToString());  
 Console.WriteLine(TestContext.DataRow[“OS”].ToString());  
 Console.WriteLine(TestContext.DataRow[“Summary”].ToString());  
 Console.WriteLine(TestContext.DataRow[“Description”].ToString());  

Besides, about the character “d” is randomly generated, I suggest you report it in Developer Community.

Sincerely,
Anna

• If the answer is helpful, please click "Accept Answer" and upvote it.
  Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.