none
How does o:OLEObject ProgID= work?

    Pergunta

  • Hi all;

    In a DOCX file I have an embedded spreadsheet. The link for it is:

    <o:OLEObject Type="Embed" ProgID="Excel.Sheet.12" ShapeID="_x0000_i1025" DrawAspect="Content" ObjectID="_1386657673"/>
    

    How do I know what spreadsheet to get for that object? Note that there is no r:id=.

    thanks - dave


    The Programming Olympics - Code Wars
    • Editado DavidThi808 quinta-feira, 29 de dezembro de 2011 18:03
    quinta-feira, 29 de dezembro de 2011 17:44

Respostas

  • Sorry this took so long to get back to Dave.  I've discovered that if you have more than one embedding, Word will use the relid mechanism like:

           <o:OLEObject Type="Embed" ProgID="Excel.SheetBinaryMacroEnabled.12" ShapeID="_x0000_i1026" DrawAspect="Content" ObjectID="_1388223847" r:id="rId6"/>
    


    But if you have only one embedding, it assumes that it's the only embedding part in the package, i.e. ...\word\embeddings\Microsoft_Excel_97-2003_Worksheet1.xls

    Make sense?

    Tom 

    • Marcado como Resposta DavidThi808 segunda-feira, 16 de janeiro de 2012 23:31
    segunda-feira, 16 de janeiro de 2012 18:06
    Moderador

Todas as Respostas

  • Hi Dave,

    Thanks for the question, I'll get back to you shortly.  What application/version created this spreadsheet?  

    Best regards,
    Tom Jebo
    Escalation Engineer
    Microsoft Open Specifications

    quinta-feira, 29 de dezembro de 2011 20:42
    Moderador
  • Hi Tom;

    Office 2010 and all Office (our program was not involved). It appears to happen if I do the insert object when Excel is running even if Excel has no workbooks open in it.

    thanks - dave


    The Programming Olympics - Code Wars
    quinta-feira, 29 de dezembro de 2011 21:05
  • Thanks Dave, I'm just getting back into this.  I'll let you know as soon as I have something.  Happy New Year!

    Tom

    segunda-feira, 2 de janeiro de 2012 18:36
    Moderador
  • Sorry this took so long to get back to Dave.  I've discovered that if you have more than one embedding, Word will use the relid mechanism like:

           <o:OLEObject Type="Embed" ProgID="Excel.SheetBinaryMacroEnabled.12" ShapeID="_x0000_i1026" DrawAspect="Content" ObjectID="_1388223847" r:id="rId6"/>
    


    But if you have only one embedding, it assumes that it's the only embedding part in the package, i.e. ...\word\embeddings\Microsoft_Excel_97-2003_Worksheet1.xls

    Make sense?

    Tom 

    • Marcado como Resposta DavidThi808 segunda-feira, 16 de janeiro de 2012 23:31
    segunda-feira, 16 de janeiro de 2012 18:06
    Moderador
  • Hi Tom;

    Thank you - dave

    ps - Can you ask them to update the documentation for this?


    Who will win The International Collegiate Programming Championships?
    segunda-feira, 16 de janeiro de 2012 23:34
  • Will do.

    Tom

    segunda-feira, 16 de janeiro de 2012 23:57
    Moderador