ASP.NET

Abhishek Sur wrote:

It cannot create excel files

string ConnectionStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=\"Excel 8.0;HDR=YES\"", Location); 
using (OleDb.OleDbConnection Connection = new OleDb.OleDbConnection(ConnectionStr)) { 
    Connection.Open(); 
    //Create your worksheet using normal SQL 
    string CreateString = "CREATE TABLE..."; 
    using (OleDb.OleDbCommand Command = new OleDb.OleDbCommand(CreateString.ToString, Connection)) { 
        Command.ExecuteNonQuery(); 
    } 
    //More code here 
    Connection.Close(); 
}

Dim ConnectionStr As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=""Excel 8.0;HDR=YES""", Location) 
Using Connection As New OleDb.OleDbConnection(ConnectionStr) 
    Connection.Open() 
    Dim CreateString as String= "CREATE TABLE..." 'Create your worksheet using normal SQL
    Using Command As New OleDb.OleDbCommand(CreateString.ToString, Connection)
        Command.ExecuteNonQuery()
    End Using
    'More code here
    Connection.Close() 
End Using

Greg Chelstowski wrote:

You're a star

Christian Graus wrote:

It's hard when your question displays multiple levels of ignorance.

Robymon wrote:

while resizing it should not go the clarity, it should get good clarity.