Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005

Hi,

Always using the COM will be an issue (The accessing of the COM will vary from one machine to another). I also faced the same issue. So I have used OLEDB to create the excel.

I have created a template file (which format you want to download)

string strChgFileName = "OUT" + System.DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xls";
string strWebServerSavePath = GetRefCodeValue(FileUpDownPath, "1") + "\\";
string strTemplatePath = GetRefCodeValue(FileTemplatePath, "1") + "\\";
File.Copy(strTemplatePath + "Template.xls", strWebServerSavePath + strChgFileName);
strWebServerSavePath += strChgFileName;

string strConString = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=" + strWebServerSavePath + ";" +

"Extended Properties=\"Excel 8.0;HDR=YES\"";

OleDbConnection con = new OleDbConnection(strConString);
con.Open();
try
{
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
int rowCount = 1;

StringBuilder sbInserts;
StringBuilder sbColValues;

//CRAETE TABLE
sbInserts = new StringBuilder();
for (int i = 1; i <= dtVIN.Columns.Count; i++)
{
if (sbInserts.Length == 0)
{
sbInserts.Append("[" + dtVIN.Columns[i - 1].ColumnName + "]");
}
else
{
sbInserts.Append(", [" + dtVIN.Columns[i - 1].ColumnName + "]");
}
}

foreach (DataRow dr in dtVIN.Rows)
{
sbColValues = new StringBuilder();
rowCount += 1;
for (int i = 1; i < dtVIN.Columns.Count + 1; i++)
{
if (sbColValues.Length == 0)
sbColValues.Append("'" + dr[i - 1].ToString() + "'");
else
sbColValues.Append(", '" + dr[i - 1].ToString() + "'");
}

cmd.CommandText = String.Format("INSERT INTO [kn01u0$]({0}) VALUES({1})", sbInserts.ToString(), sbColValues.ToString());
cmd.ExecuteNonQuery();

}
con.Close();