<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.dotnetzone.gr:443/cs/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Office Development</title><link>https://www.dotnetzone.gr:443/cs/forums/35/ShowForum.aspx</link><description>Ανάπτυξη με το VSTO και το Office SDK</description><dc:language>el</dc:language><generator>CommunityServer 2.1 SP3 (Build: 20423.1)</generator><item><title>DocumentFormat.OpenXml.Packaging;</title><link>https://www.dotnetzone.gr:443/cs/forums/thread/70981.aspx</link><pubDate>Fri, 27 Jul 2012 00:16:42 GMT</pubDate><guid isPermaLink="false">2622095e-976c-431a-859e-16783ec7ecd7:70981</guid><dc:creator>evagelos</dc:creator><slash:comments>0</slash:comments><comments>https://www.dotnetzone.gr:443/cs/forums/thread/70981.aspx</comments><wfw:commentRss>https://www.dotnetzone.gr:443/cs/forums/commentrss.aspx?SectionID=35&amp;PostID=70981</wfw:commentRss><description>&lt;p&gt;Γεια σας παιδιά.&amp;nbsp;&lt;/p&gt;&lt;p&gt;Προσπαθώ να κάνω edit ένα word και να προσθέσω τιμες στους πινακες που έχει&lt;/p&gt;&lt;p&gt;θέλω να προσθέσω&amp;nbsp;γραμμές σε στους πίνακες πως μπορώ να το κάνω; &lt;/p&gt;&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;pre&gt;&lt;span style="color:black;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;&lt;span style="color:blue;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;for&lt;/span&gt; (&lt;span style="color:blue;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;int&lt;/span&gt; i &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; 0; i &amp;lt; SrvLines.Count; i++)
                    {
                        dataSrv &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; XSupport.GetSQLDataSet(&lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"SELECT * FROM MTRL WHERE MTRL = "&lt;/span&gt; &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;+&lt;/span&gt; Convert.ToInt32(SrvLines[i, &lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"MTRL"&lt;/span&gt;]));
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;//rowIte = iteTbl.Elements&amp;lt;TableRow&amp;gt;().ElementAt(i + 1);&lt;/span&gt;

                          

                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;//cellSrvName.Append(new Paragraph(new DocumentFormat.OpenXml.Wordprocessing.Run(new DocumentFormat.OpenXml.Wordprocessing.Text("aaa"))));&lt;/span&gt;
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;//row.Append(cellSrvName);&lt;/span&gt;

                        
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;// Find the row in the table.&lt;/span&gt;
                        rowSrv &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; srvTbl.Elements&amp;lt;TableRow&amp;gt;().ElementAt(i &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;+&lt;/span&gt; 1);
                        
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;// Find the cell in the row.&lt;/span&gt;
                        cellSrvName &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rowSrv.Elements&amp;lt;TableCell&amp;gt;().ElementAt(0);
                        cellSrvQty &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rowSrv.Elements&amp;lt;TableCell&amp;gt;().ElementAt(i+1);
                        cellSrvPrice &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rowSrv.Elements&amp;lt;TableCell&amp;gt;().ElementAt(2);
                        cellSrvValue &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rowSrv.Elements&amp;lt;TableCell&amp;gt;().ElementAt(3);
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;// Find the first paragraph in the table cell.&lt;/span&gt;
                        Paragraph pSrvName &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; cellSrvName.Elements&amp;lt;Paragraph&amp;gt;().First();
                        Paragraph pSrvQty &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; cellSrvQty.Elements&amp;lt;Paragraph&amp;gt;().First();
                        Paragraph pSrvPrice &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; cellSrvPrice.Elements&amp;lt;Paragraph&amp;gt;().First();
                        Paragraph pSrvValue &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; cellSrvValue.Elements&amp;lt;Paragraph&amp;gt;().First();
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;// Find the first run in the paragraph.&lt;/span&gt;
                        Run rSrvName &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; pSrvName.Elements&amp;lt;Run&amp;gt;().First();
                        Run rSrvQty &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; pSrvQty.Elements&amp;lt;Run&amp;gt;().First();
                        Run rSrvPrice &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; pSrvPrice.Elements&amp;lt;Run&amp;gt;().First();
                        Run rSrvValue &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; pSrvValue.Elements&amp;lt;Run&amp;gt;().First();
                        &lt;span style="color:green;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;// Set the text for the run.&lt;/span&gt;
                        Text tSrvName &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rSrvName.Elements&amp;lt;Text&amp;gt;().First();
                        Text tSrvQty &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rSrvQty.Elements&amp;lt;Text&amp;gt;().First();
                        Text tSrvPrice &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rSrvPrice.Elements&amp;lt;Text&amp;gt;().First();
                        Text tSrvValue &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; rSrvValue.Elements&amp;lt;Text&amp;gt;().First();

                        tSrvName.Text &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; dataSrv[0, &lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"NAME"&lt;/span&gt;].ToString();
                        tSrvQty.Text &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; SrvLines[i, &lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"QTY1"&lt;/span&gt;].ToString();
                        tSrvPrice.Text &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; SrvLines[i, &lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"PRICE"&lt;/span&gt;].ToString();
                        tSrvValue.Text &lt;span style="color:red;font-family:Courier New;font-size:11px;font-weight:normal;background-color:transparent;"&gt;=&lt;/span&gt; SrvLines[i, &lt;span style="font-family:Courier New;font-size:11px;font-weight:normal;"&gt;"LINEVAL"&lt;/span&gt;].ToString();
                                                
                    }&lt;/span&gt;&lt;/pre&gt;&lt;p&gt;Ευχαριστώω&lt;/p&gt;</description></item></channel></rss>