Hola
No se que será lo que estará pasando. Pero podes probar usando acceder al excel usando oleDb:
Código PHP:
string connectionString = @"Provider=Microsoft.Jet.
OLEDB.4.0;Data Source=Book1.xls;Extended
Properties=""Excel 8.0;HDR=YES;""";
DbProviderFactory factory =
DbProviderFactories.GetFactory("System.Data.OleDb");
DbDataAdapter adapter = factory.CreateDataAdapter();
DbCommand selectCommand = factory.CreateCommand();
selectCommand.CommandText = "SELECT ID,City,State
FROM [Cities$]";
DbConnection connection = factory.CreateConnection();
connection.ConnectionString = connectionString;
selectCommand.Connection = connection;
adapter.SelectCommand = selectCommand;
DataSet cities = new DataSet();
adapter.Fill(cities);
gridEX1.SetDataBinding(cities.Tables[0], "");
gridEX1.RetrieveStructure();
podes verlo completo aca:
http://davidhayden.com/blog/dave/arc...5/26/2973.aspx
Si de esa forma te da el mismo problema usa esta conexión
Código PHP:
conexion = "Provider=Microsoft.Jet.OleDB.4.0;Data
Source=ExcelFile; Extended Properties=""Excel
8.0;HDR=YES;IMEX=1;ImportMixedTypes=Text """
:
Fijate que se le agrega algunos parametros como IMEX y otros, seguro que ahí te va a funcionar