Site Root

Forum Post: Re: Read .docx page by page

jimfjerstad — Wed, 16 May 2012 19:52:00 GMT

Hi Nix,

Goodol is correct. The Open XML SDK does not provide rendering calculations such as page breaks. However if all you need is to put information at the top and bottom of each page, you can use headers and footers for that. Simply define the header and footer parts that you need, and make sure they are referenced in the section properties element using header/footer reference child elements.

Hope this helps.

Jim

Forum Post: Re: problem with boxlot pptx chart

yaccast — Wed, 16 May 2012 15:04:00 GMT

we didn't find the solution for this problem, but the customer wants to generate pdf instead of pptx.

How can I do that with openxml ?

Forum Post: How to update a chart.xml

Matt Balraj — Wed, 16 May 2012 12:08:00 GMT

I have created an excel sheet that contains a chart. I update the data in an the excel file with OpenXML. The data gets updated and I am able to view the chart. However when I export the chart to Powerpoint the chart is empty. If I open this file in excel and if I save it the chart is updated properly. Using the Productivity tool I tried to find out what is different between a excel file that is saved in excel and another file that is not saved. I notice that Chart.xml is not updated. Specifically there is some element called cacheddata that gets updated if the file is opened and saved in Excel.

Can anyone tell me what I am doing wrong Or what I need to do to ensure that Chart.xml is updated properly

Forum Post: dietary fiber

Isabella852 — Wed, 16 May 2012 10:38:00 GMT

dietary fiber is so important when dieting is that because it cannot be digested it grabs onto fats, cholesterol and sugars and binds to them. As the fiber travels through your digestive system it will not only help to extract bits of the cholesterol and fats before they can be absorbed, but will also control the sugars from being absorbed too quickly, helping to prevent insulin spikes.

Forum Post: Excel 2010 converts cell value into exponential notation.

ueckalex — Wed, 16 May 2012 09:52:00 GMT

Dear all,

maybe someone knows the reason.

Description:

- Excel cell contains formula

- Due to further process I copy the cell into cache.

- Insert into the same cell with option 'only value'

- Result was that the cell contains only the value, not the formula

- Looking in XML for this cell the tag shows for value "0,1":

For other cells it shows in the v-tag simply the value = 0,1.

Does anybody knows the reason?

Does anybody knows how to prevent that?

Br,

Alex

Forum Post: Re: Problem with reading a docx-File after saving it.

Thomas Lorenz — Wed, 16 May 2012 09:23:00 GMT

My problem is gone !

To read the XmlDocument i use this method :

private XmlDocument CustomXmlDateiLesen(string fileName, bool read, string schema)

{

try

{

XmlDocument xDocCustomXML = new XmlDocument();

using (WordprocessingDocument wDoc = WordprocessingDocument.Open(fileName, false))

{

MainDocumentPart mainPart = wDoc.MainDocumentPart;

foreach (CustomXmlPart custXML in mainPart.CustomXmlParts)

{

xDocCustomXML.Load(custXML.GetStream(FileMode.Open));

XmlNode xn = xDocCustomXML.FirstChild;

if (!xn.HasChildNodes)

xn = xn.NextSibling; // <?xml version="1.0" ...> ignorieren

if (xn.NamespaceURI == schema) // entspricht gefundener Part dem gesuchten Schema?

{

return xDocCustomXML;

}

catch (Exception)

{

// Fehlerbehandlung

}

return null;

}

That's all ;)

Forum Post: Re: Convert wordprocessingml (2010) to HTML with styles/css

Mahyar — Wed, 16 May 2012 08:56:00 GMT

Hi Eric,

I saw your video and also try to play around HTMLConverter, it is very nice piece of code, but the problem is how to get that CSS without using Word Application, to have a dynamic HTML converter, which generates the CSS styles base on document itself. try to find something on web, but couldn't find anything. so is there any way to generate that CSS dynamically?

Thanks
Mahyar

Forum Post: Re: Add a footer to an existing OpenXML spreadsheet

pranay — Wed, 16 May 2012 04:40:00 GMT

[quote user="ewomack"]

Thanks again for your help, I really appreciate it!

But something else must be going on. First off, I didn't tell you that I do have 2 sheets, not 1. The code as I entered it compiles fine and the spreadsheet generates, but when I open the Excel doc it displays "Excel found unreadable content in [file name]. Do you want to recover the contents?" When I recover the formatting of the 1st spreadsheet is off, though I do see data, and the 2nd sheet has disappeared entirely apart from its bottom tab. I don't see any sign of a header or footer anywhere. When I enable editing I see a notice that Excel has repaired or removed content. The screen doesn't contain any really useful content apart from that.

Does the 2 sheet issue change things?

[/quote]Hi,

If you have more then one sheet. and want to add header and footer on both of the sheet.

I think you can loop through the WorksheetParts and add header and footer with same function.

And as far as ""Excel found unreadable content in [file name]" error is concern.

you can use Open XML productivity tool for checking which part of the spreadshet package causing this issue.

I have come across this issue many time and Productivity tool helps me in finding the cause of this problem.

Forum Post: Re: Copying Slide layouts from one presentation to another

pranay — Wed, 16 May 2012 04:31:00 GMT

Hi,

You can use below function for your purpose.

here:

presentationPart: is your pptx file presentation part

layoutName: Its the layout name which you want ot insert. Please take a note that this a layout with "layoutName" should exist in your Slide Master layout list.

public static Slide InsertSlide(PresentationPart presentationPart, string layoutName)
        {
            SlideLayout sldlayout = new SlideLayout { layOutName = layoutName };
            if (presentationPart.Presentation.SlideIdList == null)
            {
                presentationPart.Presentation.SlideIdList = new SlideIdList();
            }
            uint num = 0x100;
            num += Convert.ToUInt32(presentationPart.Presentation.SlideIdList.Count<OpenXmlElement>());
            Slide slide = new Slide(new OpenXmlElement[] { new CommonSlideData(new OpenXmlElement[] { new ShapeTree() }) });
            SlidePart openXmlPart = presentationPart.AddNewPart<SlidePart>();
            slide.Save(openXmlPart);
            SlideMasterPart part2 = presentationPart.SlideMasterParts.First<SlideMasterPart>();
            SlideLayoutPart part = part2.SlideLayoutParts.SingleOrDefault<SlideLayoutPart>(new Func<SlideLayoutPart, bool>(sldlayout.IslayoutExist));
            openXmlPart.AddPart<SlideLayoutPart>(part);
            openXmlPart.Slide.CommonSlideData = (CommonSlideData)part2.SlideLayoutParts.SingleOrDefault<SlideLayoutPart>(new Func<SlideLayoutPart, bool>(sldlayout.IslayoutExist)).SlideLayout.CommonSlideData.Clone();
            SlideId id = presentationPart.Presentation.SlideIdList.AppendChild<SlideId>(new SlideId());
            id.Id = num;
            id.RelationshipId = presentationPart.GetIdOfPart(openXmlPart);
            return GetSlide(presentationPart, id.RelationshipId);
        }
private class SlideLayout
        {
            public string layOutName;
            public bool IslayoutExist(SlideLayoutPart layout)
            {
                return layout.SlideLayout.CommonSlideData.Name.Value.Equals(this.layOutName);
            }
        }

Blog Post: Screen-cast: Overview of the Open Packaging Conventions - Part 2

Eric White — Tue, 15 May 2012 16:13:00 GMT

This video continues where the previous video (Overview of the Open Packaging Conventions - Part 1) leaves off. In this screen-cast, I cover relationship types, relationship ids, internal/external relationships, explicit/implicit relationships, and more. If you watch the previous video and this video, you will know what you need to know about Open Packaging Conventions to implement most varieties of Open XML applications.

This screen-cast is one in a series on getting started with Open XML development. You can find the complete list of videos at the bottom of this blog post.

(Please visit the site to view this video)

Here is the complete list of screen-casts in this series:

Getting Started with Open XML Development	The first in a series of screen-casts for developers getting started in development with Open XML for the first time. In this video, I look at the Open XML standard from a high level. I discuss the resources that helped me get started, and point you to places to find additional resources.
Getting Started with Open XML Development - Part II Tools	In this screen-cast, I introduce the three most important tools that you will want to be familiar with: Open XML Package Editor Power Tool for Visual Studio Open XML SDK 2.0 Productivity Tool PowerTools for Open XML
Getting Started with Open XML Development - Part III WordprocessingML Scenarios	In this screen-cast I discuss the three most common scenarios around WordprocessingML: Document generation Data and content extraction Document transformation
Getting Started with Open XML Development - Part IV SpreadsheetML and PresentationML Scenarios	In this screen-cast I discuss the two most common scenarios around SpreadsheetML, which are a) Spreadsheet generation, and b) data extraction. In addition, I discuss the most common scenario for PresentationML, which is presentation generation.
Getting Started with Open XML Development - Part V Developer Techniques	In this screen-cast I discuss some of the most powerful techniques and approaches for implementing Open XML applications.
Getting Started with Open XML Development - Part VI Developer Techniques (continued)	In this screen-cast I continue discussing some of the most powerful techniques and approaches for implementing Open XML applications.
Overview of the Open Packaging Conventions - (1 of 2)	In this screen-cast, I introduce Open Packaging Conventions (OPC) and cover some of the basic information that you need to know.
Overview of the Open Packaging Conventions - (2 of 2)	This screen-cast builds on the previous screen-cast, covering relationship types, relationship ids, internal/external relationships, explicit/implicit relationships, and more. These two videos on the Open Packaging Conventions cover what you need to know to do Open XML development.

Forum Post: Re: Problem after adding customXML to fill Content Controls

nelson_carvalho — Tue, 15 May 2012 11:19:00 GMT

Just to add extra info... i've just changed the template to set the author to same identity of the process who does the replacement of content controls and saves the document the first time...

After that if i try to edit the document through internet, change the file and save it the problems does not persist.

Still the problem is odd and i really need to solve this...

Note: Track changes is not turned on.

Forum Post: Re: Strategy for CustomXMLPart - delete - add- feedDATA

eliselavy — Tue, 15 May 2012 06:33:00 GMT

thank you so much eric, now it works perfectly , my main problem was with the namespace because I would like to replace some XMLNode from another XmlDocument. I had a lot of problem with:

xmlns="" added in all attributes.

Forum Post: Re: Problem to update CustomXMLPart with feedData

eliselavy — Tue, 15 May 2012 06:30:00 GMT

thank you so much Jim, it works by calling the flush method:

result.FeedData(xmlStream);

wordDocSource.Package.Flush();

wordDocSource.Close();

Forum Post: Re: How to manipulate this word document?

aroshlakshan — Tue, 15 May 2012 04:46:00 GMT

Thanks! i'll try that and let you know

Forum Post: Re: Where to find documentation on namespaces?

pramodhegde — Tue, 15 May 2012 04:04:00 GMT

Hi,

I am not sure there is any document which describes at this level. But you can do it yourself. Create the office document manually and see the generated xml. That will help you to get the right syntax.

Forum Post: Convert OpenXml to RTF in RichTextBox

bahamutzero — Mon, 14 May 2012 12:22:00 GMT

Hi,

I need to know if a converter OpenXml to Rtf exist already or if i must build an engine for preview the OpenXml Document in a RichTextBox with the Style,Font,... when i search a ContentControl by Tag or others.

Forum Post: add image to word document header

ghostme — Sun, 13 May 2012 14:52:00 GMT

Hello guys,

I can manipulate an existing word document header in a SharePoint library and insert a text header to it.

However, I am having some chanllenges adding an image to a header into a word document here is my code. When I run this code I don't get to see the image in the header, all I see is x image which says image cannot be displayed.

Please assist

static void Main(string[] args)     {             string siteUrl = "http://moss";     using (SPSite spSite = new SPSite(siteUrl))   {     Console.WriteLine("Querying for doc.docx");   SPList list = spSite.RootWeb.Lists["Test"];   SPQuery query = new SPQuery();   query.ViewFields = @"<FieldRef Name='FileLeafRef' />";   query.Query =   @"<Where>   <Eq>   <FieldRef Name='FileLeafRef' />   <Value Type='Text'>doc.docx</Value>   </Eq>   </Where>";   SPListItemCollection collection = list.GetItems(query);   if (collection.Count != 1)   {   Console.WriteLine("doc.docx not found");   Environment.Exit(0);   }   Console.WriteLine("Opening");   SPFile file = collection[0].File;   byte[] byteArray = file.OpenBinary();   const string wordmlNamespace = "http://schemas.openxmlformats.org/wordprocessingml/2006/main";   const string relationshipNamespace = "http://schemas.openxmlformats.org/officeDocument/2006/relationships";   string reference = "w:headerReference";   using (MemoryStream memStr = new MemoryStream())   {   memStr.Write(byteArray, 0, byteArray.Length);   using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(memStr, true))   {   Document document = wordDoc.MainDocumentPart.Document;  document.MainDocumentPart.DeleteParts(document.MainDocumentPart.FooterParts);   document.MainDocumentPart.DeleteParts(document.MainDocumentPart.HeaderParts);    AddPicHeader(wordDoc);     }     Console.WriteLine("Saving");   string linkFileName = file.Item["LinkFilename"] as string;   file.ParentFolder.Files.Add(linkFileName, memStr, true);   }     }   }       public static Header Mkpicheader(WordprocessingDocument doc, string relationshipId)          {               //Define the reference of the image.                                           var element =                          new Drawing(                              new DW.Inline(                                  new DW.Extent() { Cx = 990000L, Cy = 792000L },                                  new DW.EffectExtent()                                  {                                      LeftEdge = 0L,                                      TopEdge = 0L,                                      RightEdge = 0L,                                      BottomEdge = 0L                                  },                                  new DW.DocProperties()                                  {                                      Id = (UInt32Value)1U,                                      Name = "Picture 1"                                  },                                  new DW.NonVisualGraphicFrameDrawingProperties(                                      new A.GraphicFrameLocks() { NoChangeAspect = true }),                                  new A.Graphic(                                      new A.GraphicData(                                          new PIC.Picture(                                              new PIC.NonVisualPictureProperties(                                                  new PIC.NonVisualDrawingProperties()                                                  {                                                      Id = (UInt32Value)0U,                                                      Name = "oando-logo.png"                                                  },                                                  new PIC.NonVisualPictureDrawingProperties()),                                              new PIC.BlipFill(                                                  new A.Blip(                                                      new A.BlipExtensionList(                                                          new A.BlipExtension()                                                          {                                                              Uri =                                                                "{28A0092B-C50C-407E-A947-70E740481C1C}"                                                          })                                                  )                                                  {                                                      Embed = relationshipId,                                                      CompressionState =                                                      A.BlipCompressionValues.Print                                                  },                                                  new A.Stretch(                                                      new A.FillRectangle())),                                              new PIC.ShapeProperties(                                                  new A.Transform2D(                                                      new A.Offset() { X = 0L, Y = 0L },                                                      new A.Extents() { Cx = 990000L, Cy = 792000L }),                                                  new A.PresetGeometry(                                                      new A.AdjustValueList()                                                  ) { Preset = A.ShapeTypeValues.Rectangle }))                                      ) { Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture" })                              )                              {                                  DistanceFromTop = (UInt32Value)0U,                                  DistanceFromBottom = (UInt32Value)0U,                                  DistanceFromLeft = (UInt32Value)0U,                                  DistanceFromRight = (UInt32Value)0U,                                  EditId = "50D07946"                              });                       var header = new Header();                     var paragraph = new Paragraph();                     var run = new Run();                                          run.Append(element);                     paragraph.Append(run);                     header.Append(paragraph);                     return header;                                          //newHeaderPart.Header = header;                    // wordDoc.MainDocumentPart.Document.Body.AppendChild(new Paragraph(new Run(element)));                 }          public static void AddPicHeader(WordprocessingDocument doc)          {              ImagePart imgPart=doc.MainDocumentPart.AddImagePart(ImagePartType.Png);              var imagePartID = doc.MainDocumentPart.GetIdOfPart(imgPart);              using (Stream targetStream = imgPart.GetStream())              {                  using (FileStream sourceStream = new FileStream("../../officelogo.gif", FileMode.Open, FileAccess.Read))                  {                      byte[] buffer = new byte[1024];                      int nrBytesWritten = sourceStream.Read(buffer, 0, 1024);                      while (nrBytesWritten > 0)                      {                          targetStream.Write(buffer, 0, nrBytesWritten);                          nrBytesWritten = sourceStream.Read(buffer, 0, 1024);                      }                  }              }              if (doc.MainDocumentPart.HeaderParts.Count() == 0)              {                  doc.MainDocumentPart.DeleteParts(doc.MainDocumentPart.HeaderParts);                  var newHeaderPart = doc.MainDocumentPart.AddNewPart<HeaderPart>();                  var rId = doc.MainDocumentPart.GetIdOfPart(newHeaderPart);                  var headerRef = new HeaderReference();                  headerRef.Id = rId;                  var sectionProps = doc.MainDocumentPart.Document.Body.Elements<SectionProperties>().LastOrDefault();                  if (sectionProps == null)                  {                      sectionProps = new SectionProperties();                      doc.MainDocumentPart.Document.Body.Append(sectionProps);                  }                  sectionProps.RemoveAllChildren<HeaderReference>();                  sectionProps.Append(headerRef);                newHeaderPart.Header=Mkpicheader(doc,imagePartID);                  newHeaderPart.Header.Save();              }          }

Forum Post: Document merge

hcoco — Sun, 13 May 2012 09:34:00 GMT

I m using document builder to merge document sources but im facing a problem with numbering part.

All Heading styles are shown in bullet style.

Here is the code:

var sources = new List<Source>();
foreach (var s in files) { sources.Add(new Source(new WmlDocument(s), true)); }

string outputFile = "Output.docx";

DocumentBuilder.BuildDocument(sources, outputFile );

Any Help would be appriciated.

Forum Post: Mail merge with word template using complex field type

michaelxu — Sun, 13 May 2012 06:55:00 GMT

I'm using XML SDK 2.0 to mail merge a template document that uses complex field type. A sample is included below, it is a FORMTEXT field. The data from database will replace whole section starting from <w:fldChar w:fldCharType="begin"> to <w.fldChar w:fldCharType="end" />. Any recommandation/suggestion how to do it using SDK?

<w:r>

<w:fldChar w:fldCharType="begin">
<w:ffData>
<w:name w:val="Date_LongDate01" />
<w:enabled />
<w:calcOnExit w:val="0" />
<w:textInput>
<w:default w:val="{Date.Long Date}" />
</w:textInput>
</w:ffData>
</w:fldChar>
<w:instrText xml:space="preserve"> FORMTEXT </w:instrText>
<w:fldChar w:fldCharType="separate" />
<w:t>{Date.Long Date}</w:t>
<w:fldChar w:fldCharType="end" />

</w:r>

thanks

Michael

Forum Post: Re: stylesWithEffects

jimfjerstad — Fri, 11 May 2012 14:11:00 GMT

I answered the "how that preservation was manifest in Word 2010" question by clicking on the Convert button in the Info section of the File tab. That button converts the file back to Word 2010. When Word converts the file to 2010 format, it applies the styling information in stylesWithEffects part.