topic Is it still true that the AutoCAD NET API does not give access to embedded Excel in .NET Forum

Is it still true that the AutoCAD NET API does not give access to embedded Excel

oransen — Tue, 16 Jul 2019 09:09:27 GMT

Is it still true that the AutoCAD NET API does not give access to embedded Excel worksheets?

I've looked and looked and there is some complicated MFC stuff for a linked Excel file but I can find no real help for embedded Excel files.

In code I've got as far as this:

                            foreach (ObjectId id in btr)
                            {
                                if (id.ObjectClass.Name == "AcDbOle2Frame")
                                try
                                {
                                    Ole2Frame oleFrame = tr.GetObject(id, OpenMode.ForRead) as Ole2Frame;

                                    //object excel = oleFrame.OleObject;
                                    // Excel.Workbook EmbeddedExcel = (Excel.Workbook)oleFrame.OleObject.GetType();
                                    Type eType = oleFrame.OleObject.GetType();
                                    string sMsg = "found OLE object  = " + eType.ToString() ;
                                    LogWriter.LogWrite(sMsg);
                                }
                                catch (System.Exception e)
                                {
                                    string sMsg = string.Format("Exception ExcelChanger: {0}", e.Message);
                                    System.Windows.Forms.MessageBox.Show(sMsg);
                                    LogWriter.LogWrite(sMsg);
                                }
                            }

...but any attempt to do anything useful results in a COM HRESULT error.

Re: Is it still true that the AutoCAD NET API does not give access to embedded E

antonio.leonardo — Tue, 16 Jul 2019 20:39:53 GMT

Hi @oransen,

If you decide to throw consume Excel/Access files as OleDb, you need as a prerequisite to install the connector/driver, it's regardless of the AutoCAD .NET API.

Also, Adam Nagy explains about approch as similar as your shared code.

Att,

Antonio Leonardo

Re: Is it still true that the AutoCAD NET API does not give access to embedded E

oransen — Wed, 17 Jul 2019 07:00:04 GMT

@antonio.leonardo thanks for the pointers...

Re: Is it still true that the AutoCAD NET API does not give access to embedded E

antonio.leonardo — Wed, 17 Jul 2019 14:01:09 GMT

You're welcome!