OLE image

Mathias Mamsch - Mon Nov 22 16:28:26 EST 2010
1. Yes it is, but not using the raw richtext (See a couple of posts in the past). You can extract the picture data using a regular expression and compare the picture data and additionally check for modifications of the data part by checking the length of the data part. This way I was able to find all modifications to OLE objects.

2. In Excel you can copy/paste pictures using the shapes/inlineshapes collection. You can line them up with a cell, but you will always have the problem of filtering, resizing the rows and overlapping pictures. The freely available "Advanced Excel Export" will export pictures in your Excel sheet.

Regards, Mathias

izzo - Tue Nov 23 04:18:53 EST 2010
if (oleIsObject (obj_v2)){

exigencetextA=richTextWithOle obj_v1."Object Text"
exigencetextB=richTextWithOle obj_v2."Object Text"

if (exigencetexA!=exigencetextB){

if (exigencetextA == richTextWithOle obj_v1."Object Text"){
RichText rtf
for rtf in exigencetextA {
if (rtf.isOle){
EmbeddedOleObject ole = rtf.getEmbeddedOle
oleCopy (ole)
row++
setCell(row, 7,"Paste") // I tried Paste and olePaste it does not work. setCell(row, 8,exigencetextB)

Mathias Mamsch - Tue Nov 23 06:15:38 EST 2010
See: this post. This has been discussed before. Regards, Mathias

izzo - Thu Dec 02 03:59:21 EST 2010
Hello Mat

I have some difficulties writing my regular expressions:

{\rtf1\ansi\ansicpg1252\deff0\deflang1036{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}
\viewkind4\uc1\pard\f0\fs20 MYTEXT \par {\object\objemb{\*\objclass Word.Document.8}\objw13004\objh8850{\*\objdata MYOLEOBJECT }}}\par
}

I need to get only MYTEXT
I need to get only MYOLEOBJECT

I tried this but it does not work at all :
string reHeader="^objdata.*([])}\\.$" , the purpose was to get all the data btw objdata and }

Thanks