.Net - Recent Threads

Open a docx file that is located in a folder on the server

ilario.maiolo — Wed, 08 May 2013 17:28:10 GMT

Hi,

I want to open an existing file that is located in a folder on the server.

I want to edit a bookmarks, and then open it.

But the word document does not appear.

At the beginning i used Interop.Word dll and the file is opened correctly

This is my code:

using (WordprocessingDocument myDoc =
                   WordprocessingDocument.Open(fileName,true))
            {

//at this point i want to edit my bookmarks

Can't print excel file with "logo" shape

rvgraham — Fri, 03 May 2013 22:00:55 GMT

No problem printing if you save to local drive, close and re-open it. But if my users open the file spit out by the web page, and directly try to print, it crashes every time. If I don't put the graphic in, it works fine without having to save or close.

I'm a newbie here (but not to C# or web), and I see from a search that it's been discussed at least once before, but I don't see any definite resolution.

The graphic is inserted using the generated code using the Open Office SDK tool on a file that had nothing at all except the graphic.

I'm inclined to think I need more code generated from the SDK tool, but I can't tell what.

Thanks, Bob Graham

The specified package is invalid. The main part is missing

moni — Fri, 03 May 2013 14:29:04 GMT

Hi to all.I am facing one problem thats why i came here as i expect the answer here

i have an .xlsx file which i am trying to open in openXML means .ODS but its giving error that

The specified package is invalid. The main part is missing.

I don't know what is the mistake.

Actually i got a file which was created in Excel 2007 i.e .XLSX

but now i am opening in my system as i don't have office installed so that file is not opening.

First time when i am opening it opens but when i change something it asks me for save as i don't have office

Pls tell what is the cause of error

Importing RTF content into a document

abel.e.pereira — Mon, 22 Apr 2013 19:14:41 GMT

Hello,

I'm trying to add rich text format (.rtf) text into a document using Open XML SDK but I think I follow the wrong approach:

Basically what I am trying to do ins to insert a rtf document into a bookmark position. Which I did:

string chunkId = string.Format("AltChunkId{0}", index);
var mainPart = document.MainDocumentPart;
var chunk = mainPart.AddAlternativeFormatImportPart(AlternativeFormatImportPartType.Rtf, chunkId);
using (var stream = new MemoryStream(Encoding.ASCII.GetBytes(richText.Trim())))
{
	chunk.FeedData(stream);
}
AltChunk altChunk = new AltChunk
	                    {
		                    Id = chunkId
	                    };
var run = new Run();
run.Append(altChunk);
bookmark.InsertAfterSelf(run);

The problem is this approach relies on MS Word to process/resolve the AltChunk.

This code actually produces something like this:

OpenXmlUnknownElement openXmlUnknownElement1 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<w:altChunk r:id=\"AltChunkId0\" xmlns(...)

Which is a problem in my scenario because the file I am generating is not intended to be used by Word (neither a different text processor).

So my question is: Is there a way to import rtf content to a document using Open XML SDK that actually produces corresponded paragraphs, runs and so on..?

Thanks in advance,

Abel

read a word file with OPENXML

ronaldolleba — Wed, 17 Apr 2013 09:02:30 GMT

hi i'm frank i've an question
according with this post http://blogs.msdn.com/b/brian_jones/archive/2010/01/04/document-assembly-merging-excel-powerpoint-and-word-content-together.aspx

i want to know if its possible to Loop through a specific content controls within the document instead of loop through all content control.

Because i've to made an application who assembl document but select some specific content control in the source file and fill the destination file

for exple if checkbox1(belonging a form) is checked i hav to select content control CT1...
Cordialy

XML parsing for Docx file

Aamir — Tue, 16 Apr 2013 08:34:30 GMT

hi everyone,

i`m trying to parse a docx file in C# in order to get the specific text from it and want to save it my own customized XML file can any one help me plz......

applying a NumberFormat problem

japa62 — Wed, 10 Apr 2013 08:49:38 GMT

p>Hi,

After several hours of testing I am stumped.

Basically I have a NumberFormat

<numFmt numFmtId="44" formatCode="_-&quot;$&quot;* #,##0.00_-;\-&quot;$&quot;* #,##0.00_-;_-&quot;$&quot;* &quot;-&quot;??_-;_-@_-"/>

Which returns as

"_-\"$\"* #,##0.00_-;\\-\"$\"* #,##0.00_-;_-\"$\"* \"-\"??_-;_-@_-"

but when I

string returnValue = "123560";
string formatString = "_-\"$\"* #,##0.00_-;\\-\"$\"* #,##0.00_-;_-\"$\"* \"-\"??_-;_-@_-" ;
returnValue = float.Parse(returnValue).ToString(formatString);

returnValue is returned as "_-$* 123,560.00_-" when excel is displaying "$123,560.00"

I know I could apply custom format like "$#,##0.00;-$#,##0.00;-" but need to start moving away from specifiying custom formats for each cell.

Has anyone traversed this issue before and if so, could you nudge me towards a fix please?

James

Repaire Message in Office 2013 but open fine in other version

AliAmjad — Tue, 02 Apr 2013 12:09:58 GMT

I've generated a presentation using OpenXML SDK 2.0 which opens fine in Office 2007 or 2010 but gives Repaire message in Office 2013, OpenXML SDK Productivity tool validation functionality didn't provide much help. Can anyone please tell me what's the problem? The presentation can be downloaded from:

https://skydrive.live.com/redir?resid=C4B0274BA6703509!300

How to copy slide that contains A hyperlink using PresentationBuilder ?

cYounes — Tue, 26 Mar 2013 13:07:16 GMT

Hi,

I'm using PresentationBuilder to copy some slides from Powerpoint presentation ,

All things copied correctly except the Hyperlinks, When i try to copy a slide that contains a hyperlink, i get a new slide on the output Powerpoint however, it doesn't contain the hyperlink, it contains only the text, I use the following lines:

var sourceDoc = new PmlDocument ( mySourceFile);
    List<SlideSource> sources = new List<SlideSource> ()
    {
           // I want to copy just the 2nd slide that contains a hyperlink
           new SlideSource(sourceDoc, 1, 1, false),
     };

     OpenXmlPowerTools.PresentationBuilder.BuildPresentation ( sources, myOutputFile );

the code above, is correct, and the program compiles and runs correctly.

What do you think? does PresentationBuilder copy the hyperlink ??!

Adding image to a table cell

Shenbagaram — Tue, 26 Mar 2013 09:59:49 GMT

Hi,

I have just created a table in powerpoint with 9 column headers. I have tried adding texting values read from the datatable to these columns in ppt. I w as able to proceed with binding the text. Now as a second step i want to load images in these cells based on the conditions that are applied on the input datatable.

Now how to show those images inside the table cells.? im totally new to this openxml.. Expecting replies that would guide me through this task:):)

thanks in advance:)

for (int i = 0; i < dtbStatusReportData.Rows.Count; i++)
                    {
                        tr = new A.TableRow();
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Project Name"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Project Description"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Schedule Adherence"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Effort Adherence"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["SLA Adherence"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Staffing"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Escalation"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Issue"].ToString()));
                        tr.Append(CreateTextCell(dtbStatusReportData.Rows[i]["Summary Update"].ToString()));
                        tbl.Append(tr);
                    }

now after the second column..i want to insert an image in the thirdcell.!the image is of .png format.!! waiting for your replies:)

Vertical Alignment of an image in a Paragraph (Relative to paragraph)

mrjonie — Wed, 20 Mar 2013 20:27:00 GMT

Hi,

I am new to OpenXML and tryin out various methods to place an image in the bottom right corner of a paragraph.. Here is the code I tried , but did not work.

For some reason this is not working, i've been breaking my head over this for couple of days and any help would be appreciated. I searched several examples , but all of them refer to just inserting image to a document or horizontal positioning or vertical positioning wrt to page. None of them give details on how to get the the vertical positoning relative to a paragraph Thanks John

private static Paragraph CreateParagraph2(string fillText1, long imageWidthEMU, long imageHeightEMU, string imageFileName){
            string GraphicDataUri = "http://schemas.openxmlformats.org/drawingml/2006/picture";

            double imageWidthInInches = imageWidthEMU / 914400.0;
            double imageHeightInInches = imageHeightEMU / 914400.0;

            long horizontalWrapPolygonUnitsPerInch =
              (long)(21600L / imageWidthInInches);

            long verticalWrapPolygonUnitsPerInch =
              (long)(21600L / imageHeightInInches);

            wp.WrapPolygon wrapPolygon1 = new wp.WrapPolygon() { Edited = false };
            wp.StartPoint startPoint1 = new wp.StartPoint() { X = -150L, Y = 0L };
            wp.LineTo lineTo1 = new wp.LineTo() { X = -250L, Y = 21521L };
            wp.LineTo lineTo2 = new wp.LineTo() { X = 21600L, Y = 21521L };
            wp.LineTo lineTo3 = new wp.LineTo() { X = 21600L, Y = 0L };
            wp.LineTo lineTo4 = new wp.LineTo() { X = -250L, Y = 0L };
            wrapPolygon1.Append(startPoint1);
            wrapPolygon1.Append(lineTo1);
            wrapPolygon1.Append(lineTo2);
            wrapPolygon1.Append(lineTo3);
            wrapPolygon1.Append(lineTo4);

            wp.WrapTight wrapTight = new wp.WrapTight(wrapPolygon1) { WrapText = wp.WrapTextValues.BothSides };

            wp.VerticalPosition vertPostition = new wp.VerticalPosition
                (new wp.VerticalAlignment("bottom")) { RelativeFrom = wp.VerticalRelativePositionValues.Paragraph};
            
            Paragraph p2 = new Paragraph(

                   new ParagraphProperties(
                     new Justification() { Val = JustificationValues.Both },

                   new Run(

                     new Drawing(

                       new wp.Anchor(

                         new wp.SimplePosition() { X = 0L, Y = 0L },

                         // Center the image horizontally on the page. 
                         new wp.HorizontalPosition(new wp.HorizontalAlignment("right"))
                         {
                             RelativeFrom =wp.HorizontalRelativePositionValues.Margin 
                         },

                        vertPostition,
                         new wp.Extent()
                         {
                             Cx = imageWidthEMU,
                             Cy = imageHeightEMU
                         },

                         new wp.EffectExtent()
                         {
                             LeftEdge = 0L,
                             TopEdge = 0L,
                             RightEdge = 0L,
                             BottomEdge = 0L
                         },

                         wrapTight,

                         new wp.DocProperties()
                         {
                             Id = (UInt32Value)2U,
                             Name = "Tight Text Wrapping Picture",
                             Description = "imageFileName"
                         },

                         new wp.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 = "imageFileName"
                                 },
                                 new pic.NonVisualPictureDrawingProperties()),

                               new pic.BlipFill(
                                 new a.Blip() { Embed = "rId1" },
                                 new a.Stretch(
                                   new a.FillRectangle())),

                               new pic.ShapeProperties(

                                 new a.Transform2D(
                                   new a.Offset() { X = 0L, Y = 0L },

                                   new a.Extents()
                                   {
                                       Cx = imageWidthEMU,
                                       Cy = imageHeightEMU
                                   }),

                                 new a.PresetGeometry(
                                   new a.AdjustValueList()
                                 ) { Preset = a.ShapeTypeValues.Rectangle }
                               )
                             )
                       ) { Uri = GraphicDataUri })
                     )
                       {
                           DistanceFromTop = (UInt32Value)0U,
                           DistanceFromBottom = (UInt32Value)0U,
                           DistanceFromLeft = (UInt32Value)114300U,
                           DistanceFromRight = (UInt32Value)114300U,
                           SimplePos = false,
                           RelativeHeight = (UInt32Value)251658240U,
                           BehindDoc = true,
                           Locked = false,
                           LayoutInCell = true,
                           AllowOverlap = true
                       })),

                       new Run(
                         new Text(fillText1))
                 )
               );

            return p2;

        }

How to Create hierarchical bookmarks ?

swami — Tue, 19 Mar 2013 13:31:48 GMT

Hi,

I am working on MS Word Add-in project, i am using Open XML SDK 2.0, i need create hierarchy of bookmarks (Parent/Child)

1. insert bookmark(say B1) for selected text.

2. insert another bookmark(say B2) by selecting text which is in range of (part of) first bookmark

3. now inner bookmark is child of outer one (i.e. B1 is parent of B2)

I have inserted these bookmarks, and when try to select text using bookmark, both are messed up, selection is not proper.

when i am trying to select first bookmark, it takes endbookmark of second one

and when i am trying to select second bookmark, it takes endbookmark of first one

can anybody please help me to getrid of this problem ?

please reply to this post, thank you in advance.

Thank you,

swami.

Break Line In Chart Axis Label

Jeka — Tue, 19 Mar 2013 08:11:35 GMT

Hello

I'm using OpenXml to draw PowerPoint chart I need to implement Configurable Axis Labels unfortunately I can’t programmaticly break Line

in the Axis Label Text I have tried \n,\n\r etc. but its doesn’t work (break Line after numbers)

This functionality is same as ALT+Enter in Excel

Best Regards

Jeka

Newbie to OpenXml: How do I read the contents of a TextBox in an Excel 2010 Spreadsheet?

TonnyC — Fri, 15 Mar 2013 08:59:58 GMT

Thanks for your advice

Br.

c#-openxml word Replacement and page break

hasan — Fri, 15 Mar 2013 08:03:52 GMT

My problem is I want to replace a word document using openxml and add a page break. Then I want to write replaced text on the second page.BUT I CAN NOT WRITE THE SECOND PAGE
how do i this ?

Here my code:

using (WordprocessingDocument wordDoc = WordprocessingDocument.Open(@"d:\a.docx", true)) {
 
            using (StreamReader reader = new StreamReader(wordDoc.MainDocumentPart.GetStream()))
            {
                text = reader.ReadToEnd();
            }
            Regex regexText = new Regex("#db#");
            text = regexText.Replace(text, textBox4.Text.Trim());
 
            using (StreamWriter sw = new StreamWriter(wordDoc.MainDocumentPart.GetStream(FileMode.Create)))
            {
 
                sw.Write(text);
 

            }
 
            MainDocumentPart mainPart = wordDoc.MainDocumentPart;
            Run r = new Run();
            Paragraph para = new Paragraph(new Run(new Break() { Type = BreakValues.Page }));
 
            using (StreamWriter sw1 = new StreamWriter(mainPart.GetStream(FileMode.Create)))
            {
                sw1.Write(text);
 
            }
 
            mainPart.Document.Body.InsertAfter(para, mainPart.Document.Body.LastChild);
            mainPart.Document.Save();
        }
    }

Document Protection

VeryBiztalker — Thu, 14 Mar 2013 21:20:42 GMT

        using (WordprocessingDocument wdoc = WordprocessingDocument.Open(strPath, true))
        {
            DocumentSettingsPart docSett = wdoc.MainDocumentPart.DocumentSettingsPart;
            docSett.RootElement.Append(new DocumentProtection { Edit = DocumentProtectionValues.ReadOnly });
            docSett.RootElement.Save();
        }

We are creating word document using openxml programatically. Everything works fine but when we protect the document also programactially using openxml for editing then contents of the document are getting affected for example the sentence نحاول اصلاح التقرير اليوم وشكرا will become اليوم وشكرا نحاول اصلاح التقرير

If the generated document is not protected then everything stays fine.

Any help would appreciated.

Thanks in advance.

The code we are using to protec the document is pasted above

Headings lose numbering when using DocumentBuilder 2.2

dave.dawley — Wed, 13 Mar 2013 00:31:33 GMT

I'm working with OpenXmlTools/DocumentBuilder 2.2 and experiencing an issue with numbered heading styles in my primary document. The numbering is removed from the generated document. I've distilled this down to the simplest case - creating a document from a single source document and the issue persists.

Document identified by "m_source" has numbered heading styles using multilevel list.

Code for document assembly:

List<Source> m_sources = new List<Source>();

m_sources.Add(new Source(new WmlDocument(m_source), true));

DocumentBuilder.BuildDocument(m_sources, m_destination);

Document at m_destination has heading styles, but numbering is now set to "none".

Is this a known issue in DocumentBuilder? Is there a workaround? Could it be issue with my source doc?

Replacing a Content Control with a Linked Image in a Word Document

Constantine — Tue, 12 Mar 2013 01:43:49 GMT

I am having problems trying to replace a content control with a linked image. I have created a template in word with content controls that I am swapping out to build my final document. My linked image is showing up but it is showing a message saying "The linked image cannot be displayed. The file may have been moved, renamed, or deleted. Verify that the link points to the correct file and location." I am thinking it has something to do with the relationship but I cannot seem to figure it out. Can you please take a look at the below code and let me know if I am doing something wrong or not?

private static void InsertPicture(MainDocumentPart mainDocumentPart, string profilePictureUrl)
        {
            Document doc = mainDocumentPart.Document;

            //Get the body
            var body = doc.GetFirstChild<Body>();
            //Get the first table which has our picture
            var table1 = body.GetFirstChild<Table>();

            var tableRow1 = table1.GetFirstChild<TableRow>();

            var tableCell1 = tableRow1.GetFirstChild<TableCell>();

            //Remove content control before replacing it with the linked image
            //sdtCell1.Remove();

            var paragraph1 = tableCell1.GetFirstChild<Paragraph>();

            var run1 = new Run();

            var drawing1 = new Drawing();

            var inline1 = new Inline
                              {
                                  DistanceFromTop = 0U,
                                  DistanceFromBottom = 0U,
                                  DistanceFromLeft = 0U,
                                  DistanceFromRight = 0U
                              };

            var extent1 = new Extent {Cx = 2286000L, Cy = 2159000L};
            var effectExtent1 = new EffectExtent {LeftEdge = 0L, TopEdge = 0L, RightEdge = 0L, BottomEdge = 0L};
            var docProperties1 = new DocProperties {Id = 2U, Name = "Profile_Picture.jpg"};

            var nonVisualGraphicFrameDrawingProperties1 = new Wp.NonVisualGraphicFrameDrawingProperties();

            var graphicFrameLocks1 = new GraphicFrameLocks {NoChangeAspect = true};
            graphicFrameLocks1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            nonVisualGraphicFrameDrawingProperties1.Append(graphicFrameLocks1);

            var graphic1 = new Graphic();
            graphic1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            var graphicData1 = new GraphicData {Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture"};

            var picture1 = new Pic.Picture();
            picture1.AddNamespaceDeclaration("pic", "http://schemas.openxmlformats.org/drawingml/2006/picture");

            var nonVisualPictureProperties1 = new Pic.NonVisualPictureProperties();
            var nonVisualDrawingProperties1 = new Pic.NonVisualDrawingProperties {Id = 2U, Name = "Profile_Picture.jpg"};
            var nonVisualPictureDrawingProperties1 = new Pic.NonVisualPictureDrawingProperties();

            nonVisualPictureProperties1.Append(nonVisualDrawingProperties1);
            nonVisualPictureProperties1.Append(nonVisualPictureDrawingProperties1);

            //Add relationship to document 
            mainDocumentPart.AddExternalRelationship(
                "http://schemas.openxmlformats.org/officeDocument/2006/relationships/image",
                new Uri(profilePictureUrl, UriKind.Absolute), "ProfilePhoto");

            var blipFill1 = new Pic.BlipFill();
            var blip1 = new Blip {Link = "ProfilePhoto"};

            var stretch1 = new Stretch();
            var fillRectangle1 = new FillRectangle();

            stretch1.Append(fillRectangle1);

            blipFill1.Append(blip1);
            blipFill1.Append(stretch1);

            var shapeProperties1 = new Pic.ShapeProperties();

            var transform2D1 = new Transform2D();
            var offset1 = new Offset {X = 0L, Y = 0L};
            var extents1 = new Extents {Cx = 2286000L, Cy = 2159000L};

            transform2D1.Append(offset1);
            transform2D1.Append(extents1);

            var presetGeometry1 = new PresetGeometry {Preset = ShapeTypeValues.Rectangle};
            var adjustValueList1 = new AdjustValueList();

            presetGeometry1.Append(adjustValueList1);

            shapeProperties1.Append(transform2D1);
            shapeProperties1.Append(presetGeometry1);

            picture1.Append(nonVisualPictureProperties1);
            picture1.Append(blipFill1);
            picture1.Append(shapeProperties1);

            graphicData1.Append(picture1);

            graphic1.Append(graphicData1);

            inline1.Append(extent1);
            inline1.Append(effectExtent1);
            inline1.Append(docProperties1);
            inline1.Append(nonVisualGraphicFrameDrawingProperties1);
            inline1.Append(graphic1);

            drawing1.Append(inline1);

            run1.Append(drawing1);
            paragraph1.Append(run1);
        }

Binding Data from DB to Powerpoint Chart using OpenXml in Asp.Net

dineshharaveer — Mon, 11 Mar 2013 16:30:29 GMT

Hi All,

As i was new to OpenXML,i have seen some of the videos posted in the youtube,from those examples i have tried to save the ppt i was successfully done which i have copied the code from the openxml sdk v2.0 productivity tool which i have opened an created ppt file contains a chart in that. Upto now the code runs fine but i tried to implement to get the dynamic data from db which i tried in two ways. FIrstly, i without using any array the data in the x-axis is showing only the lastly binded data. Secondly i have tried using object collection array it throws an error "Object is not set to an instance".The code which i have written in the asp.net page.

private void GenerateChartPart1Content(ChartPart chartPart1)

{

C.ChartSpace chartSpace1 = new C.ChartSpace();

chartSpace1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

chartSpace1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

chartSpace1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

C.Date1904 date19041 = new C.Date1904() { Val = false };

C.EditingLanguage editingLanguage1 = new C.EditingLanguage() { Val = "en-US" };

C.RoundedCorners roundedCorners1 = new C.RoundedCorners() { Val = false };

AlternateContent alternateContent1 = new AlternateContent();

alternateContent1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");

AlternateContentChoice alternateContentChoice1 = new AlternateContentChoice() { Requires = "c14" };

alternateContentChoice1.AddNamespaceDeclaration("c14", "http://schemas.microsoft.com/office/drawing/2007/8/2/chart");

C14.Style style1 = new C14.Style() { Val = 102 };

alternateContentChoice1.Append(style1);

AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback();

C.Style style2 = new C.Style() { Val = 2 };

alternateContentFallback1.Append(style2);

alternateContent1.Append(alternateContentChoice1);

alternateContent1.Append(alternateContentFallback1);

C.Chart chart1 = new C.Chart();

C.AutoTitleDeleted autoTitleDeleted1 = new C.AutoTitleDeleted() { Val = false };

C.PlotArea plotArea1 = new C.PlotArea();

C.Layout layout1 = new C.Layout();

C.LineChart lineChart1 = new C.LineChart();

C.Grouping grouping1 = new C.Grouping() { Val = C.GroupingValues.Standard };

C.VaryColors varyColors1 = new C.VaryColors() { Val = false };

C.LineChartSeries lineChartSeries1 = new C.LineChartSeries();

C.Index index1 = new C.Index() { Val = (UInt32Value)0U };

C.Order order1 = new C.Order() { Val = (UInt32Value)0U };

C.SeriesText seriesText1 = new C.SeriesText();

C.StringReference stringReference1 = new C.StringReference();

C.Formula formula1 = new C.Formula();

formula1.Text = "Sheet1!$B$1";

C.StringCache stringCache1 = new C.StringCache();

C.PointCount pointCount1 = new C.PointCount() { Val = (UInt32Value)1U };

C.StringPoint stringPoint1 = new C.StringPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue1 = new C.NumericValue();

numericValue1.Text = "FY11";

stringPoint1.Append(numericValue1);

stringCache1.Append(pointCount1);

stringCache1.Append(stringPoint1);

stringReference1.Append(formula1);

stringReference1.Append(stringCache1);

seriesText1.Append(stringReference1);

C.Marker marker1 = new C.Marker();

C.Symbol symbol1 = new C.Symbol() { Val = C.MarkerStyleValues.None };

marker1.Append(symbol1);

C.CategoryAxisData categoryAxisData1 = new C.CategoryAxisData();

C.StringReference stringReference2 = new C.StringReference();

C.Formula formula2 = new C.Formula();

formula2.Text = "Sheet1!$A$2:$A$5";

C.StringCache stringCache2 = new C.StringCache();

C.PointCount pointCount2 = new C.PointCount() { Val = (UInt32Value)4U };

C.StringPoint stringPoint2 = new C.StringPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue2 = new C.NumericValue();

numericValue2.Text = "Bikes";

stringPoint2.Append(numericValue2);

C.StringPoint stringPoint3 = new C.StringPoint() { Index = (UInt32Value)1U };

C.NumericValue numericValue3 = new C.NumericValue();

numericValue3.Text = "Cars";

stringPoint3.Append(numericValue3);

C.StringPoint stringPoint4 = new C.StringPoint() { Index = (UInt32Value)2U };

C.NumericValue numericValue4 = new C.NumericValue();

numericValue4.Text = "Cycles";

stringPoint4.Append(numericValue4);

C.StringPoint stringPoint5 = new C.StringPoint() { Index = (UInt32Value)3U };

C.NumericValue numericValue5 = new C.NumericValue();

numericValue5.Text = "Buses";

stringPoint5.Append(numericValue5);

stringCache2.Append(pointCount2);

stringCache2.Append(stringPoint2);

stringCache2.Append(stringPoint3);

stringCache2.Append(stringPoint4);

stringCache2.Append(stringPoint5);

stringReference2.Append(formula2);

stringReference2.Append(stringCache2);

categoryAxisData1.Append(stringReference2);

C.Values values1 = new C.Values();

C.NumberReference numberReference1 = new C.NumberReference();

C.Formula formula3 = new C.Formula();

formula3.Text = "Sheet1!$B$2:$B$5";

C.NumberingCache numberingCache1 = new C.NumberingCache();

C.FormatCode formatCode1 = new C.FormatCode();

formatCode1.Text = "General";

C.PointCount pointCount3 = new C.PointCount() { Val = (UInt32Value)4U };

C.NumericPoint numericPoint1 = new C.NumericPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue6 = new C.NumericValue();

numericValue6.Text = "4.3";

numericPoint1.Append(numericValue6);

C.NumericPoint numericPoint2 = new C.NumericPoint() { Index = (UInt32Value)1U };

C.NumericValue numericValue7 = new C.NumericValue();

numericValue7.Text = "2.5";

numericPoint2.Append(numericValue7);

C.NumericPoint numericPoint3 = new C.NumericPoint() { Index = (UInt32Value)2U };

C.NumericValue numericValue8 = new C.NumericValue();

numericValue8.Text = "3.5";

numericPoint3.Append(numericValue8);

C.NumericPoint numericPoint4 = new C.NumericPoint() { Index = (UInt32Value)3U };

C.NumericValue numericValue9 = new C.NumericValue();

numericValue9.Text = "4.5";

numericPoint4.Append(numericValue9);

numberingCache1.Append(formatCode1);

numberingCache1.Append(pointCount3);

numberingCache1.Append(numericPoint1);

numberingCache1.Append(numericPoint2);

numberingCache1.Append(numericPoint3);

numberingCache1.Append(numericPoint4);

numberReference1.Append(formula3);

numberReference1.Append(numberingCache1);

values1.Append(numberReference1);

C.Smooth smooth1 = new C.Smooth() { Val = false };

lineChartSeries1.Append(index1);

lineChartSeries1.Append(order1);

lineChartSeries1.Append(seriesText1);

lineChartSeries1.Append(marker1);

lineChartSeries1.Append(categoryAxisData1);

lineChartSeries1.Append(values1);

lineChartSeries1.Append(smooth1);

C.LineChartSeries lineChartSeries2 = new C.LineChartSeries();

C.Index index2 = new C.Index() { Val = (UInt32Value)1U };

C.Order order2 = new C.Order() { Val = (UInt32Value)1U };

C.SeriesText seriesText2 = new C.SeriesText();

C.StringReference stringReference3 = new C.StringReference();

C.Formula formula4 = new C.Formula();

formula4.Text = "Sheet1!$C$1";

C.StringCache stringCache3 = new C.StringCache();

C.PointCount pointCount4 = new C.PointCount() { Val = (UInt32Value)1U };

C.StringPoint stringPoint6 = new C.StringPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue10 = new C.NumericValue();

numericValue10.Text = "FY12";

stringPoint6.Append(numericValue10);

stringCache3.Append(pointCount4);

stringCache3.Append(stringPoint6);

stringReference3.Append(formula4);

stringReference3.Append(stringCache3);

seriesText2.Append(stringReference3);

C.Marker marker2 = new C.Marker();

C.Symbol symbol2 = new C.Symbol() { Val = C.MarkerStyleValues.None };

marker2.Append(symbol2);

C.CategoryAxisData categoryAxisData2 = new C.CategoryAxisData();

C.StringReference stringReference4 = new C.StringReference();

C.Formula formula5 = new C.Formula();

formula5.Text = "Sheet1!$A$2:$A$5";

C.StringCache stringCache4 = new C.StringCache();

C.PointCount pointCount5 = new C.PointCount() { Val = (UInt32Value)4U };

C.StringPoint stringPoint7 = new C.StringPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue11 = new C.NumericValue();

numericValue11.Text = "Bikes";

stringPoint7.Append(numericValue11);

C.StringPoint stringPoint8 = new C.StringPoint() { Index = (UInt32Value)1U };

C.NumericValue numericValue12 = new C.NumericValue();

numericValue12.Text = "Cars";

stringPoint8.Append(numericValue12);

C.StringPoint stringPoint9 = new C.StringPoint() { Index = (UInt32Value)2U };

C.NumericValue numericValue13 = new C.NumericValue();

numericValue13.Text = "Cycles";

stringPoint9.Append(numericValue13);

C.StringPoint stringPoint10 = new C.StringPoint() { Index = (UInt32Value)3U };

C.NumericValue numericValue14 = new C.NumericValue();

numericValue14.Text = "Buses";

stringPoint10.Append(numericValue14);

stringCache4.Append(pointCount5);

stringCache4.Append(stringPoint7);

stringCache4.Append(stringPoint8);

stringCache4.Append(stringPoint9);

stringCache4.Append(stringPoint10);

stringReference4.Append(formula5);

stringReference4.Append(stringCache4);

categoryAxisData2.Append(stringReference4);

C.Values values2 = new C.Values();

C.NumberReference numberReference2 = new C.NumberReference();

C.Formula formula6 = new C.Formula();

formula6.Text = "Sheet1!$C$2:$C$5";

C.NumberingCache numberingCache2 = new C.NumberingCache();

C.FormatCode formatCode2 = new C.FormatCode();

formatCode2.Text = "General";

C.PointCount pointCount6 = new C.PointCount() { Val = (UInt32Value)4U };

C.NumericPoint numericPoint5 = new C.NumericPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue15 = new C.NumericValue();

numericValue15.Text = "2.4";

numericPoint5.Append(numericValue15);

C.NumericPoint numericPoint6 = new C.NumericPoint() { Index = (UInt32Value)1U };

C.NumericValue numericValue16 = new C.NumericValue();

numericValue16.Text = "4.4000000000000004";

numericPoint6.Append(numericValue16);

C.NumericPoint numericPoint7 = new C.NumericPoint() { Index = (UInt32Value)2U };

C.NumericValue numericValue17 = new C.NumericValue();

numericValue17.Text = "1.8";

numericPoint7.Append(numericValue17);

C.NumericPoint numericPoint8 = new C.NumericPoint() { Index = (UInt32Value)3U };

C.NumericValue numericValue18 = new C.NumericValue();

numericValue18.Text = "2.8";

numericPoint8.Append(numericValue18);

numberingCache2.Append(formatCode2);

numberingCache2.Append(pointCount6);

numberingCache2.Append(numericPoint5);

numberingCache2.Append(numericPoint6);

numberingCache2.Append(numericPoint7);

numberingCache2.Append(numericPoint8);

numberReference2.Append(formula6);

numberReference2.Append(numberingCache2);

values2.Append(numberReference2);

C.Smooth smooth2 = new C.Smooth() { Val = false };

lineChartSeries2.Append(index2);

lineChartSeries2.Append(order2);

lineChartSeries2.Append(seriesText2);

lineChartSeries2.Append(marker2);

lineChartSeries2.Append(categoryAxisData2);

lineChartSeries2.Append(values2);

lineChartSeries2.Append(smooth2);

C.LineChartSeries lineChartSeries3 = new C.LineChartSeries();

C.Index index3 = new C.Index() { Val = (UInt32Value)2U };

C.Order order3 = new C.Order() { Val = (UInt32Value)2U };

C.SeriesText seriesText3 = new C.SeriesText();

C.StringReference stringReference5 = new C.StringReference();

C.Formula formula7 = new C.Formula();

formula7.Text = "Sheet1!$D$1";

C.StringCache stringCache5 = new C.StringCache();

C.PointCount pointCount7 = new C.PointCount() { Val = (UInt32Value)1U };

C.StringPoint stringPoint11 = new C.StringPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue19 = new C.NumericValue();

numericValue19.Text = "FY13";

stringPoint11.Append(numericValue19);

stringCache5.Append(pointCount7);

stringCache5.Append(stringPoint11);

stringReference5.Append(formula7);

stringReference5.Append(stringCache5);

seriesText3.Append(stringReference5);

C.Marker marker3 = new C.Marker();

C.Symbol symbol3 = new C.Symbol() { Val = C.MarkerStyleValues.None };

marker3.Append(symbol3);

C.CategoryAxisData categoryAxisData3 = new C.CategoryAxisData();

C.StringReference stringReference6 = new C.StringReference();

C.Formula formula8 = new C.Formula();

formula8.Text = "Sheet1!$A$2:$A$5";

C.StringCache stringCache6 = new C.StringCache();

C.PointCount pointCount8 = new C.PointCount() { Val = (UInt32Value)4U };

stringCache6.Append(pointCount8);

//--->Newly Added

PPTChartData obj = new PPTChartData();

DataSet ds = obj.ChartData();

C.StringPoint[] strPt = null;

C.NumericValue[] numVal = null;

for (int i = 0; ds.Tables[0].Rows.Count; i++)

{

strPt[i] = new C.StringPoint() { Index = (UInt32Value)0U };

numVal[i] = new C.NumericValue();

numVal[i].Text = ds.Tables[0].Rows[i]["ProductName"].ToString();

}

////C.StringPoint stringPoint12 = new C.StringPoint() { Index = (UInt32Value)0U };

////C.NumericValue numericValue20 = new C.NumericValue();

////numericValue20.Text = "Bikes";

////stringPoint12.Append(numericValue20);

////C.StringPoint stringPoint13 = new C.StringPoint() { Index = (UInt32Value)1U };

////C.NumericValue numericValue21 = new C.NumericValue();

////numericValue21.Text = "Cars";

////stringPoint13.Append(numericValue21);

////C.StringPoint stringPoint14 = new C.StringPoint() { Index = (UInt32Value)2U };

////C.NumericValue numericValue22 = new C.NumericValue();

////numericValue22.Text = "Cycles";

////stringPoint14.Append(numericValue22);

////C.StringPoint stringPoint15 = new C.StringPoint() { Index = (UInt32Value)3U };

////C.NumericValue numericValue23 = new C.NumericValue();

////numericValue23.Text = "Buses";

////stringPoint15.Append(numericValue23);

////stringCache6.Append(pointCount8);

////stringCache6.Append(stringPoint12);

////stringCache6.Append(stringPoint13);

////stringCache6.Append(stringPoint14);

////stringCache6.Append(stringPoint15);

stringReference6.Append(formula8);

stringReference6.Append(stringCache6);

categoryAxisData3.Append(stringReference6);

C.Values values3 = new C.Values();

C.NumberReference numberReference3 = new C.NumberReference();

C.Formula formula9 = new C.Formula();

formula9.Text = "Sheet1!$D$2:$D$5";

C.NumberingCache numberingCache3 = new C.NumberingCache();

C.FormatCode formatCode3 = new C.FormatCode();

formatCode3.Text = "General";

C.PointCount pointCount9 = new C.PointCount() { Val = (UInt32Value)4U };

C.NumericPoint numericPoint9 = new C.NumericPoint() { Index = (UInt32Value)0U };

C.NumericValue numericValue24 = new C.NumericValue();

numericValue24.Text = "2";

numericPoint9.Append(numericValue24);

C.NumericPoint numericPoint10 = new C.NumericPoint() { Index = (UInt32Value)1U };

C.NumericValue numericValue25 = new C.NumericValue();

numericValue25.Text = "2";

numericPoint10.Append(numericValue25);

C.NumericPoint numericPoint11 = new C.NumericPoint() { Index = (UInt32Value)2U };

C.NumericValue numericValue26 = new C.NumericValue();

numericValue26.Text = "3";

numericPoint11.Append(numericValue26);

C.NumericPoint numericPoint12 = new C.NumericPoint() { Index = (UInt32Value)3U };

C.NumericValue numericValue27 = new C.NumericValue();

numericValue27.Text = "5";

numericPoint12.Append(numericValue27);

numberingCache3.Append(formatCode3);

numberingCache3.Append(pointCount9);

numberingCache3.Append(numericPoint9);

numberingCache3.Append(numericPoint10);

numberingCache3.Append(numericPoint11);

numberingCache3.Append(numericPoint12);

numberReference3.Append(formula9);

numberReference3.Append(numberingCache3);

values3.Append(numberReference3);

C.Smooth smooth3 = new C.Smooth() { Val = false };

lineChartSeries3.Append(index3);

lineChartSeries3.Append(order3);

lineChartSeries3.Append(seriesText3);

lineChartSeries3.Append(marker3);

lineChartSeries3.Append(categoryAxisData3);

lineChartSeries3.Append(values3);

lineChartSeries3.Append(smooth3);

C.DataLabels dataLabels1 = new C.DataLabels();

C.ShowLegendKey showLegendKey1 = new C.ShowLegendKey() { Val = false };

C.ShowValue showValue1 = new C.ShowValue() { Val = false };

C.ShowCategoryName showCategoryName1 = new C.ShowCategoryName() { Val = false };

C.ShowSeriesName showSeriesName1 = new C.ShowSeriesName() { Val = false };

C.ShowPercent showPercent1 = new C.ShowPercent() { Val = false };

C.ShowBubbleSize showBubbleSize1 = new C.ShowBubbleSize() { Val = false };

dataLabels1.Append(showLegendKey1);

dataLabels1.Append(showValue1);

dataLabels1.Append(showCategoryName1);

dataLabels1.Append(showSeriesName1);

dataLabels1.Append(showPercent1);

dataLabels1.Append(showBubbleSize1);

C.ShowMarker showMarker1 = new C.ShowMarker() { Val = true };

C.Smooth smooth4 = new C.Smooth() { Val = false };

C.AxisId axisId1 = new C.AxisId() { Val = (UInt32Value)21315584U };

C.AxisId axisId2 = new C.AxisId() { Val = (UInt32Value)21317120U };

lineChart1.Append(grouping1);

lineChart1.Append(varyColors1);

lineChart1.Append(lineChartSeries1);

lineChart1.Append(lineChartSeries2);

lineChart1.Append(lineChartSeries3);

lineChart1.Append(dataLabels1);

lineChart1.Append(showMarker1);

lineChart1.Append(smooth4);

lineChart1.Append(axisId1);

lineChart1.Append(axisId2);

C.CategoryAxis categoryAxis1 = new C.CategoryAxis();

C.AxisId axisId3 = new C.AxisId() { Val = (UInt32Value)21315584U };

C.Scaling scaling1 = new C.Scaling();

C.Orientation orientation1 = new C.Orientation() { Val = C.OrientationValues.MinMax };

scaling1.Append(orientation1);

C.Delete delete1 = new C.Delete() { Val = false };

C.AxisPosition axisPosition1 = new C.AxisPosition() { Val = C.AxisPositionValues.Bottom };

C.MajorTickMark majorTickMark1 = new C.MajorTickMark() { Val = C.TickMarkValues.Outside };

C.MinorTickMark minorTickMark1 = new C.MinorTickMark() { Val = C.TickMarkValues.None };

C.TickLabelPosition tickLabelPosition1 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo };

C.CrossingAxis crossingAxis1 = new C.CrossingAxis() { Val = (UInt32Value)21317120U };

C.Crosses crosses1 = new C.Crosses() { Val = C.CrossesValues.AutoZero };

C.AutoLabeled autoLabeled1 = new C.AutoLabeled() { Val = true };

C.LabelAlignment labelAlignment1 = new C.LabelAlignment() { Val = C.LabelAlignmentValues.Center };

C.LabelOffset labelOffset1 = new C.LabelOffset() { Val = (UInt16Value)100U };

C.NoMultiLevelLabels noMultiLevelLabels1 = new C.NoMultiLevelLabels() { Val = false };

categoryAxis1.Append(axisId3);

categoryAxis1.Append(scaling1);

categoryAxis1.Append(delete1);

categoryAxis1.Append(axisPosition1);

categoryAxis1.Append(majorTickMark1);

categoryAxis1.Append(minorTickMark1);

categoryAxis1.Append(tickLabelPosition1);

categoryAxis1.Append(crossingAxis1);

categoryAxis1.Append(crosses1);

categoryAxis1.Append(autoLabeled1);

categoryAxis1.Append(labelAlignment1);

categoryAxis1.Append(labelOffset1);

categoryAxis1.Append(noMultiLevelLabels1);

C.ValueAxis valueAxis1 = new C.ValueAxis();

C.AxisId axisId4 = new C.AxisId() { Val = (UInt32Value)21317120U };

C.Scaling scaling2 = new C.Scaling();

C.Orientation orientation2 = new C.Orientation() { Val = C.OrientationValues.MinMax };

scaling2.Append(orientation2);

C.Delete delete2 = new C.Delete() { Val = false };

C.AxisPosition axisPosition2 = new C.AxisPosition() { Val = C.AxisPositionValues.Left };

C.MajorGridlines majorGridlines1 = new C.MajorGridlines();

C.NumberingFormat numberingFormat1 = new C.NumberingFormat() { FormatCode = "General", SourceLinked = true };

C.MajorTickMark majorTickMark2 = new C.MajorTickMark() { Val = C.TickMarkValues.Outside };

C.MinorTickMark minorTickMark2 = new C.MinorTickMark() { Val = C.TickMarkValues.None };

C.TickLabelPosition tickLabelPosition2 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo };

C.CrossingAxis crossingAxis2 = new C.CrossingAxis() { Val = (UInt32Value)21315584U };

C.Crosses crosses2 = new C.Crosses() { Val = C.CrossesValues.AutoZero };

C.CrossBetween crossBetween1 = new C.CrossBetween() { Val = C.CrossBetweenValues.Between };

valueAxis1.Append(axisId4);

valueAxis1.Append(scaling2);

valueAxis1.Append(delete2);

valueAxis1.Append(axisPosition2);

valueAxis1.Append(majorGridlines1);

valueAxis1.Append(numberingFormat1);

valueAxis1.Append(majorTickMark2);

valueAxis1.Append(minorTickMark2);

valueAxis1.Append(tickLabelPosition2);

valueAxis1.Append(crossingAxis2);

valueAxis1.Append(crosses2);

valueAxis1.Append(crossBetween1);

plotArea1.Append(layout1);

plotArea1.Append(lineChart1);

plotArea1.Append(categoryAxis1);

plotArea1.Append(valueAxis1);

C.Legend legend1 = new C.Legend();

C.LegendPosition legendPosition1 = new C.LegendPosition() { Val = C.LegendPositionValues.Right };

C.Layout layout2 = new C.Layout();

C.Overlay overlay1 = new C.Overlay() { Val = false };

legend1.Append(legendPosition1);

legend1.Append(layout2);

legend1.Append(overlay1);

C.PlotVisibleOnly plotVisibleOnly1 = new C.PlotVisibleOnly() { Val = true };

C.DisplayBlanksAs displayBlanksAs1 = new C.DisplayBlanksAs() { Val = C.DisplayBlanksAsValues.Gap };

C.ShowDataLabelsOverMaximum showDataLabelsOverMaximum1 = new C.ShowDataLabelsOverMaximum() { Val = false };

chart1.Append(autoTitleDeleted1);

chart1.Append(plotArea1);

chart1.Append(legend1);

chart1.Append(plotVisibleOnly1);

chart1.Append(displayBlanksAs1);

chart1.Append(showDataLabelsOverMaximum1);

C.TextProperties textProperties1 = new C.TextProperties();

A.BodyProperties bodyProperties1 = new A.BodyProperties();

A.ListStyle listStyle1 = new A.ListStyle();

A.Paragraph paragraph1 = new A.Paragraph();

A.ParagraphProperties paragraphProperties1 = new A.ParagraphProperties();

A.DefaultRunProperties defaultRunProperties11 = new A.DefaultRunProperties() { FontSize = 1800 };

paragraphProperties1.Append(defaultRunProperties11);

A.EndParagraphRunProperties endParagraphRunProperties1 = new A.EndParagraphRunProperties() { Language = "en-US" };

paragraph1.Append(paragraphProperties1);

paragraph1.Append(endParagraphRunProperties1);

textProperties1.Append(bodyProperties1);

textProperties1.Append(listStyle1);

textProperties1.Append(paragraph1);

C.ExternalData externalData1 = new C.ExternalData() { Id = "rId1" };

C.AutoUpdate autoUpdate1 = new C.AutoUpdate() { Val = false };

externalData1.Append(autoUpdate1);

chartSpace1.Append(date19041);

chartSpace1.Append(editingLanguage1);

chartSpace1.Append(roundedCorners1);

chartSpace1.Append(alternateContent1);

chartSpace1.Append(chart1);

chartSpace1.Append(textProperties1);

chartSpace1.Append(externalData1);

chartPart1.ChartSpace = chartSpace1;

}

Binding Data from Database to PowerPoint in OPENXML in Asp.Net

dineshharaveer — Mon, 11 Mar 2013 16:29:19 GMT