When create Excel file using c# cannot open it

Posted by Ahmedsa under C# on 1/21/2017 | Points: 10 | Views : 345 | Status : [Member] | Replies : 1
I try to create excel file using c# windows form visual studio 2015
i need to create excel file with excel 2007 with extension xlsx
after i click the button and got to path i need to create i found file in path
But cannot open it

my code as bellow:
public void CreateSheetIfNotExists()  
{
using (System.Data.OleDb.OleDbConnection databaseConnection = new System.Data.OleDb.OleDbConnection())
{

DataTable schemaTable = default(DataTable);

databaseConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=D:\\Book310.xlsx;Extended Properties=Excel 12.0;";

databaseConnection.Open();

schemaTable = databaseConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] {
null,
null,
"Sheet1$"
});

if (schemaTable.Rows.Count == 0)
{
string SQLDDLCommand = "CREATE TABLE [Sheet1] (UserID INTEGER, UserName CHAR(255))";
System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand(SQLDDLCommand, databaseConnection);
excelCommand.ExecuteNonQuery();

}

databaseConnection.Close();
}
}

after that file 310 created but not open
when open file i get this error
excel cannot open the file because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extention matches the format of the file."
How to solve this problem if possible




Responses

Posted by: Lisaw on: 1/22/2017 [Member] Starter | Points: 25

Up
0
Down
Hope below link would help you:
http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response