We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Is there any possibility to read data using Reader rather than DataTable?

Platform: ASP.NET Web Forms (Classic) |
Control: XlsIO

It is not possible to read data using Reader. Instead, you can loop through the worksheet data and access each cell value. Here is the sample code to loop through the worksheet data and access the cell value using DisplayText property.


int columnCount = 10;
int rowCount = 90;
for (int i = 0; i < columnCount; i++)
   for (int j = 0; j < rowCount; j++)
      var str_value=worksheet.Range[i, j].DisplayText;



You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile