Do we need to install Microsoft office in server for Excel import in Asp.net?

.net, c#, import

Solution

If you are reading only xls files then use `Microsoft.Jet.OLEDB.4.0` that is inbuilt with your .net framework.

If you are reading xlsx files then use `Microsoft.ACE.OLEDB.12.0`. The drivers for this can be download freely from Microsoft site. You don't need to install Microsoft officer for interoping.

Use following connection string

    string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;  
Data Source=" + path + ";Extended Properties=Excel 12.0;HDR=YES";

Download drivers from here

Refer this for running example

Problem

do we need to install Microsoft office in server to run a application to import data from excel file to mssql database ? any suggestions or ideas ? the code i used ``` public partial class _Default : System.Web.UI.Page { private String strConnection = "Data Source=MYCBJ017550027;Initial Catalog=MySamplesDB;Integrated Security=True"; protected void Page_Load(object sender, EventArgs e) { } protected void btnSend_Click(object sender, EventArgs e) { string path = fileuploadExcel.PostedFile.FileName; string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=Excel 12.0;Persist Security Info=False"; OleDbConnection excelConnection =new OleDbConnection(excelConnectionString); OleDbCommand cmd = new OleDbCommand("Select [ID],[Name],[Designation] from [Sheet1$]",excelConnection); excelConnection.Open(); OleDbDataReader dReader; dReader = cmd.ExecuteReader(); SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection); sqlBulk.DestinationTableName = "Excel_table"; sqlBulk.WriteToServer(dReader); excelConnection.Close(); } } ```

Original source