Hi,
I have this code
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string path1 = @"path";
FileStream stream = File.Open(path1, FileMode.Open, FileAccess.Read);
var excelReader = Excel.ExcelReaderFactory.CreateBinaryReader(stream);
DataSet result = excelReader.AsDataSet();
excelReader.IsFirstRowAsColumnNames = true;
DataSet resultColName = excelReader.AsDataSet();
while (excelReader.Read())
{
TextBox3.Text =excelReader[0].ToString();
Response.Write(TextBox3.Text);
}
excelReader.Close();
}
}
But the excelReader doesn't read anything, i.e. the textbox remains empty a ...
Go to the complete details ...