Last post Feb 01, 2011 04:50 AM by jackbaker
Nov 13, 2008 05:29 AM|basakeylul|LINK
hi , i am reading data from excel ,but i have problems...my excel file ha HTML caracters...
i can't read ...
how can i set this problem ?thx..
adapter.SelectCommand.CommandText = sql;
my EXCEL file sample:
Nov 13, 2008 07:54 AM|muhammedsalimp|LINK
what is the error that you are getting ?
Nov 13, 2008 08:20 AM|basakeylul|LINK
i am reading ilgilidaire,esasno,kararno,karartarihi,konusu,ozeti columns but i cant read icerik column..(icerik column have HTML tags( like <P> ...))
u can look my sample data is down...
Nov 17, 2008 08:51 AM|basakeylul|LINK
have any idea ?
Nov 19, 2008 08:32 AM|muhammedsalimp|LINK
There is no problem with the sample excel file data that you have posted.
I tried creating a sample excel file with the data you provided and tried to display that data in the page and i was successful in that.
I'll give the sample code and output below
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" + path + ";Extended Properties=Excel 5.0";
ExcelQuery = "SELECT * FROM [Sheet1$] ";
System.Data.OleDb.OleDbDataAdapter ExcelAdapter =
new System.Data.OleDb.OleDbDataAdapter(ExcelQuery, ConnectionString);
GridView1.DataSource = Ds;
Nov 24, 2008 05:35 AM|basakeylul|LINK
hi, thx for your help..
i try again ..
Feb 01, 2011 04:50 AM|jackbaker|LINK
Here's another very easy way how to read data from excel:
http://www.devtriogroup.com/ExcelJetcell/ I've used this Excel .NET component for a while an it's really great component.