Click here to Skip to main content
13,252,537 members (50,861 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I am Performing Reading operation on Excel Workbook (Xlsx)
I do not have Msoffice installed on my Machine,
While Creating Object of ExcelWorkBook it throws error Like

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

So My Question is that to Perform Programming on Excel is there a need to install MsOffice excel first ?
Posted 15-Sep-10 22:16pm
Aarti2010 16-Sep-10 3:29am
yes first you have to install msOffice before that he will not understand what he have to do.
Rate this: bad
Please Sign up or sign in to vote.

Solution 4

Yes, you have to install MSOffice.
You can also use OLEDB Provider for this.

This is code for u -
string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1;""", fileName);
string query = String.Format("select * from [{0}$]", "Sheet1");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet ds = new DataSet();
return ds;
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

MS Office does not just give you Excel, Word etc, but also the framework that allows data manipulation, import export, VBA etc.

It is necessary for it to be installed in order to have the functionality available for iis etc.
Monjurul Habib 28-Apr-11 18:45pm
nice 5.
Rate this: bad
Please Sign up or sign in to vote.

Solution 5

Yes Microsoft Office needs to be installed in your machine. As for C# programming we needed to add a reference to excel and this visual studio can get only when components of Microsoft office is registered. While installing office all the components gets registered and we get reference of that registered component in our program.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.171114.1 | Last Updated 1 Mar 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100