Site Root

Forum Post: Re: LINK a picture in wordprocessing document (NOT EMBED)

bobm — Fri, 03 Feb 2012 23:59:00 GMT

The general idea is to use AddExternalRelationship and specify the relationship type and the Uri for what you want to link. The returned object has an Id member that I believe can be used for the link. You should be able to get the correct value for the relationship type string by manually creating a document with a linked picture and then examine the XML.

Forum Post: Re: PowerTools Core 2.2.2 and Example Pivot Tables error

bobm — Fri, 03 Feb 2012 23:27:00 GMT

Something is clearly wrong, but not so clear why. The code that you said is causing a problem should be within an "if" statement that checks to see if "value" is a double or Int32 type. String values should never be executing the code you say is a problem. Blanks could be another issue. I can't think of why I would have blank or empty cells in pivot table source data.

If you would like to post your CSV, I could look at it, but I don't see what you are hoping to accomplish with that data.

Forum Post: How is spreadsheetPrinterSettingsPart1Data generated?

otudorache — Fri, 03 Feb 2012 13:27:00 GMT

What is spreadsheetPrinterSettingsPart1Data and how is it generated?

Forum Post: Re: openxml mailmerge

Wonderflik — Fri, 03 Feb 2012 12:12:00 GMT

Thanks!

Forum Post: Re: OpenXML Spreadsheet, how to copy and insert specified rows

ykk157 — Fri, 03 Feb 2012 08:35:00 GMT

Hi,

Where can we find the implementations of the methods MergeCellInRange() and CreateChangedRowMergeCell() used in the above example?

is it possible to share the body of the above mentioned two methods ?

Thanks and Regards,

YKK Reddy

Forum Post: Aspose.Newsletter February 2012 Edition is out Now

aspose_seo — Fri, 03 Feb 2012 03:57:00 GMT

Aspose Newsletter for February 2012 has now been published that highlights all the newly supported features offered in the recent releases of its JasperReports exporters, SQL Server rendering extensions, .NET, Java & SharePoint components. This month’s technical article shows performing OCR with Aspose.OCR for .NET & a migration tip for extracting messages from a PST file with Aspose.Email for .NET. A video tutorial for creating Code3128 barcode and set its background color using Aspose.BarCode.

In December we ran a sweepstake on Facebook; in January we had a grand prize draw. The winner of the sweepstake prize, an iPad 2, was Michael Sevast. He was much surprised to find that he had won but also had kind words to say about Aspose: “We have used the Apose.Total for .NET components, for several years now. These tools greatly simplify our ability to interact with and export to known Microsoft formats. The speed of these components saves us considerable time over custom in-house solutions.

Supporting User Groups – How Can We Help?

Aspose value our developer community and do what we can to support over 150,000 users. One way we support the community is by supporting user groups. User groups bring developers from different industries and with different experience together to learn from each other. We already sponsor several groups and provide swag and free licenses for competitions. If you lead a user group, or know of one that could benefit from our support, please contact us. We’d love to hear from you.

Product Spotlight – Aspose.Diagram for .NET

Aspose.Diagram is a class library for working with MS Visio files & is a pure .NET alternate for MS Visio Object Model.It enables developers to work with VSD & VDX files on ASP.NET web applications, web services & Windows applications. It makes use of the advanced functionality of Visio's services to manipulate Visio docs on a server. Developer can open files & manipulate the elements of the diagram, from lines and fills, to more complex elements, and then export to native Visio formats or XML. Click here to download the latest release of Aspose.Diagram for .NET

Technical Article – Performing OCR with Aspose.OCR for .NET

Aspose.OCR for .NET (and Java, too) gives software developers a tool for incorporating optical character recognition in their applications. This article explains how to get started and performing OCR on an image. For more links and information about Aspose.OCR, check out our Facebook fan page. Every month, we’ll post links there that help you get more out of our products. Click here to read the complete article.

Updates about new product releases

Aspose.Total for .NET – a compilation of our latest .NET products.
Aspose.Cells for .NET 7.1.0 –supports conditional formatting for pivot tables, converting work sheets to SVG and introducing a number of enhancements.
Aspose.Words for .NET – our monthly Aspose.Words release.
Aspose.Pdf for .NET 6.6.0 –introduces PDf to PDF/A or PDF/A-1a conversion, PDF portfolio, CGM to PDF conversion and a number of other enhancements.
Aspose.Slides for .NET 5.8.0 –resolves a number of issues, from exceptions when working with PPTX files to charts being excluded from PDF output.
Aspose.BarCode for .NET 4.5.0 – adds support for Windows Phone 7, saving barcode to EMF stream and Singapore Post 4-State barcode.
Aspose.Tasks for .NET 4.0.0: – supports changing task progress and adds a number of other improvements.
Aspose.Diagram for .NET 1.8.0 – allows you to set page size when rendering TIFFs and ads layout shapes to compact tree and flowchart diagrams.
Aspose.Imaging for .NET 1.3.0 – allows you to resize images.
Aspose.Email for .NET 1.3.0 – introduces a number of new features, including auto-detecting email format and support for EMLX.
Aspose.Total for Java – a compilation of our latest Java products.
Aspose.Cells for Java 7.1.0 – adds a number of enhancements and fixes.
Aspose.Words for Java – our monthly Aspose.Words release.
Aspose.Email for Java 1.2.0 – improves MSG to EML conversion, gives access to default folders and allows you to remove an item from a PST file.
Aspose.OCR for Java 1.1.0– adds support for more fonts.
Aspose.Total for SharePoint – a compilation of our latest SharePoint products.
Aspose.Total for Reporting Services – a compilation of our latest Reporting Services products.
Aspose.Cells for SSRS 1.8.0: - adds support for protecting workbooks and worksheets as well as filters and other optimizations and fixes.
Aspose.Slides for Reporting Services 4.0.0- improves performance and adds another few fixes.
Aspose.BarCode for Reporting Services 4.5.0 - adds support for Singapore Post 4-State barcodes and fixes an issue with licenses.
Aspose.Total for JasperReports – a compilation of our latest JasperReports products.
Aspose.Cells for JasperReports 1.1.1 – hotfix that fixes a couple of issues.

Tutorial Video –Using Aspose.BarCode for Java

SAspose.BarCode for Java makes it easy to read and create barcodes in Java applications. Many aspects of the barcode can be controlled. This tutorial shows how to create a Code3128 barcode and set the foreground, background and code text colors as well as other attributes. The video is just under 5 minutes long. Click below to watch the Video about creating a Code3128 barcode.

Migration Tip –Extracting messages from a PST file with Aspose.Email for .NET

One way of extracting messages from PST files in Microsoft Outlook is to use Microsoft Automation. For it to work, you need Outlook installed on the machine that the code runs on and you need to reference Microsoft Office Interop for Outlook. The other way is to use Aspose.Email for .NET. You can find the complete details here.

Collect your copy of Aspose Newsletter, October 2012 edition

Collect the English version of this newsletter
Collect the Japanese version of this newsletter

Keep in Touch

There are several ways for you to keep in touch with us. The monthly newsletter is a way for us to keep in touch with you, but we are always interested in hearing from you.

- Post a question on our forums
- Connect with us on Post a question on our Facebook

Contact Information

Aspose Pty Ltd Suite 163,

79 Longueville Road Lane Cove,

NSW, 2066 Australia

Aspose - Your File Format Experts

sales@aspose.com

Phone: 888.277.6734

Fax: 866.810.9465

Forum Post: Re: Regarding group shapes used in powerpoint

tendoors — Fri, 03 Feb 2012 00:08:00 GMT

I have sometimes turned to this form for help: social.msdn.microsoft.com/.../threads

Forum Post: Re: pptx file that validates OK in Open XML SDK 2.0 gives 'Powerpoint found unreadable content ...' errors when opened in PowerPoint 2007

tendoors — Fri, 03 Feb 2012 00:05:00 GMT

When I've had this problem in the past, what I've done is to allow PowerPoint to recover the presentation and then I save it under a different name. Then, unzipping both the corrupted and the recovered presentation, I compare the XML files in a diff program (I use Notepad++). From here, I can find out what is different in the corrupted one and then go down the path to seeing what I've done wrong. It's tedious, but it works for me.

In your case, if it has inserted tableStyles, theme1 and viewProps - and there are no other changes besides these - than yes, those files are required. At a minimum, your file should always have viewProps and at least one theme. That it now has tableStyles means you've created at least one table.

To create a minimumly valid PPTX, just open PowerPoint and save the deck as is (if you want, you can also delete the slide and save it without any slides).

Forum Post: Re: Possible to include an img in spreadsheet using Open XML SDK 2.0 & ASP.NET?

ykk157 — Wed, 01 Feb 2012 08:32:00 GMT

Can you elaborate the code ?

I am also facing the same issue.

Also i need to insert the image at a particular cell (Say D5)

Wiki: OpenXMLDeveloper Wiki

Anonymous — Tue, 31 Jan 2012 21:59:00 GMT

Wiki Page: PowerTools for Open XML

bobm — Tue, 31 Jan 2012 15:59:00 GMT

PowerTools for Open XML consists of example code and guidance for implementing various types of functionality using the Open XML document format. At one level, PowerTools for Open XML consists of PowerShell cmdlets that enable you to process Open XML documents in interesting ways. At a deeper level, PowerTools provides C# source code that shows how to implement some interesting functionality using Open XML.

This page is the central repository for all PowerTools for Open XML content. Subscribe to the OpenXMLDeveloper RSS feed, follow OpenXmlDev, and EricWhiteDev on twitter, and subscribe to http://ericwhite.com/blog/feed/ to stay current with PowerTools progress.

PowerTools for Open XML was first released in June, 2008. Some of the content listed below applies to version 1.0 or 1.0 of PowerTools for Open XML. That content is still relevant to PowerTools for Open XML 2.0, so you may find it interesting to review that material. Our goal is to update all of those blog posts and screen-casts, so that all material is specifically relevant to PowerTools for Open XML 2.2 (and beyond). As those old blog posts are rewritten, we will post that content here on OpenXMLDeveloper.org, and will update the links below appropriately.

PowerTools for Open XML 2.2

Link	Summary
Announcing the release of PowerTools for Open XML 2.2	Highlights the key enhancements of PowerTools for Open XML version 2.2.
PowerTools.CodePlex.com	Download the PowerTools for Open XML 2.2.1 source code from CodePlex. The new version includes a spreadsheet pivot table example.
Screen-cast: Building, installing, and running PowerTools for Open XML 2.2	Short screen-cast that shows how to build and install PowerTools 2.2. Shows running a cmdlet to verify that the installation worked properly.
[[PowerTools for Open XML 2.0 Cmdlets]]	List of PowerTools for Open XML 2.2 cmdlets, with a short description of each one. Several of the cmdlets now have screen-casts recorded for them, so this is a good place to find out more about all of the cmdlets.
PowerTools 2.2 Code Design and Organization	Shows technical overview of the new code for PowerTools 2.2 cmdlets and core code.
Screen-Cast: Functional Programming Utility Methods and Classes for Open XML	Screen-cast that walks through the functions and classes in PtUtil.cs, which contains utility functionality that make it easier to work with Open XML using LINQ to XML.
Screen-Cast Creating Excel Pivot Tables	Screen-cast shows how to use the PowerTools methods to create pivot tables for Excel.
Screen-Cast Open XML Code to Create Pivot Tables	Screen-cast shows the Open XML code and elements needed to create a pivot table from scratch for Excel.

DocumentBuilder 2.0

DocumentBuilder 2.0 is a very important part of PowerTools for Open XML, and has its own resource center:

DocumentBuilder Resource Center

PowerTools for Open XML 1.1

Link	Summary
Announcing the Release of PowerTools for Open XML V1.1	An introduction to PowerTools for Open XML 1.1.
Move/Insert/Delete Paragraphs in Word Processing Documents using the Open XML SDK	Provides a detailed explanation of DocumentBuilder 1.1.
Accepting Revisions in Open XML WordprocessingML Documents	Discusses the RevisionAccepter class.

PowerTools for Open XML 1.0

Link	Summary
Automated Processing of Open XML Documents using PowerShell	An introduction to PowerTools for Open XML 1.0.

Blog Post: Creating Pivot Tables, Part 3

bobm — Tue, 31 Jan 2012 15:55:00 GMT

This third part of the series is a screencast that explains the Open XML elements needed for a pivot table and how to create the parts and elements needed. Part 1 showed how to create a pivot table using an existing spreadsheet. Part 2 showed the example code for creating a pivot table from scratch.

(Please visit the site to view this video)

The next step would be to add rows, columns, filters, and data values. If you are interested in code for that, please comment. The code involves a number of steps, but I would be happy to work through it, if there is interest.

Forum Post: powerpoint 2010 axes problem with openxml interface

xelt — Mon, 30 Jan 2012 15:43:00 GMT

Hi All. I am trying to solve a problem that last from several time and still i have no idea how to fix it.

I am using openxml library in dot.net c# framework 4.0. I just take xxx.pptx files (every file contains only one slide) and trying to merge together in one unique file. I open an empty PowerPoint file and add a series of charts to it using the OpenXML interface.

These pptx contain axes. When i try to open with powerpoint 2007, it works fine and i can see all the axes (horizontal and vertical axis), while when i try to open directly from powerpoint 2010, the axes of all slides are hide by default and manually I must modify this property.

I discover another thing... if i try to open with powerpoint 2007 and save again the same file and open with powerpoint 2010, in this last case i can see the axes (it doesn't work if i save in the same file with powerpoint 2010) ... but i need before save with office 2007 and that is really annoying!!

I also tried to compare the xml files inside charts folder (unzipping content in one folder) and comparing xml together...

i noticed that if I show the axis (setting the usual property in office 2010), in the xml file (chartxxx.xml) after this operation i can see one tag called delete set to 0. If I try to modify that and force to 1, the axis is hide.

But it is not so simple because there isn't anything that differentiate horizontal and vertical axis. And sometimes there is no delete tag and I can see the axis equally

Anyone have some idea about the problem? Is it a Powerpoint 2010 bug?

Thanks a lot

Albert

Forum Post: How to save the changes to the document presentation?

razorln — Fri, 27 Jan 2012 13:28:00 GMT

How to save the changes to the document presentation when a property?

Property change Width:

 public class pptxTableColumn      {          Drawing.GridColumn _tablecolumns;                                public pptxTableColumn(Drawing.GridColumn tablecolumn)          {              this._tablecolumns = tablecolumn;                          }                                                   public Int64Value Width          {              get              {                  return _tablecolumns.Width;              }              set              {                                      _tablecolumns.Width = value;                                 }          }      }

Document.Table[0].columns[0].Width

Forum Post: Word being split to multiple RunItem

Pradyumna — Thu, 26 Jan 2012 17:48:00 GMT

when a word file is accessed thru openxml single word Content it is split into multiple runitems

Eg. "Figure 1 " is split as below

- <w:rPr>
<w:rStyle w:val="FigXref" />
</w:rPr>
<w:t>Fig</w:t>
</w:r>
- <w:r w:rsidRPr="00CE2373" w:rsidR="00AC5B6E">
- <w:rPr>
<w:rStyle w:val="FigXref" />
</w:rPr>
<w:t xml:space="preserve">ure</w:t>
</w:r>
- <w:r w:rsidRPr="00CE2373" w:rsidR="00CE3E6C">
- <w:rPr>
<w:rStyle w:val="FigXref" />
</w:rPr>
<w:t>1</w:t>
</w:r>

Is then any solution to avoid Splitting of single word content in multiple RunItem,Also any reason why the word has been split when style font and other are same

With Regards

Pradyumna.

Forum Post: Re: Excel becomes unreadable

swizzer2012 — Thu, 26 Jan 2012 17:15:00 GMT

Whooah?? Really? I haven't observe that yet. What version did you use?

Forum Post: Generate Reports Easily Using Templater Library for .Net and Java

Askade — Wed, 25 Jan 2012 16:00:00 GMT

Description:

Templater is a library that facilitates creating reports. Main advantage of Templater is that report templates are documents created using Office-like editor.

Main features:

Report templates are documents – create and design report templates using your favorite editor (e.g. Word, Excel etc.) and add tags as text, e.g. [[NAME_SURNAME]], [[MONTHLY_SALE]].
Tags will be replaced with actual data during runtime through .Net/Java.
NO additional plug-ins are required!
One method API is easily mastered in matter of minutes.
Templater supports various data types as well property/method navigation – navigate fields and invoke methods without arguments and use dot operator to select object properties.
Reasonable price.

Usage:

Video demonstration can be found on templater.info website or by following link youtu.be/V1QuEm5UaFo.

Templater is not a mere mail-merge library, but can be used to create both simple and complex reports. Although it is not a substitute for OfficeOpenXml SDK or other similar tools, it is more than sufficient for creating complete reports in most cases:

Generating reports and document
Generating invoices, proposals etc.
Aggregating data in Excel for later analysis
Filling out forms.

There are three license versions available:

Free
Standard
Enterprise.

If you have any questions regarding Templater feel free to contact us via info@templater.info or comment below. We’re looking forward to hearing from you.

Useful links:

Templater homepage: templater.info
Usage examples: templater.info/documents
Download and samples: templater.info/downloads
Purchase: templater.info/buy

Blog Post: Creating Pivot Tables, Part 2

bobm — Wed, 25 Jan 2012 04:10:00 GMT

In this second part, I will show the code for creating a pivot table in Excel from scratch using Open XML. This post contains a brief explanation of the example that can be found in PowerTools Core 2.2.2 from Codeplex (powertools.codeplex.com).

// Create from scratch row = 1; int maxColumn = 1; using (OpenXmlMemoryStreamDocument streamDoc = OpenXmlMemoryStreamDocument.CreateSpreadsheetDocument()) {     using (SpreadsheetDocument doc = streamDoc.GetSpreadsheetDocument())     {         WorksheetPart sheet = WorksheetAccessor.AddWorksheet(doc, "Range");         using (StreamReader source = new StreamReader("../../PivotData.txt"))         {             while (!source.EndOfStream)             {                 string line = source.ReadLine();                 if (line.Length > 3)                 {                     string[] fields = line.Split(',');                     int column = 1;                     foreach (string item in fields)                     {                         double num;                         if (double.TryParse(item, out num))                             WorksheetAccessor.SetCellValue(doc, sheet, row, column++, num);                         else                             WorksheetAccessor.SetCellValue(doc, sheet, row, column++, item);                     }                     maxColumn = column - 1;                 }                 row++;             }         }         sheet.PutXDocument();         WorksheetAccessor.SetRange(doc, "Sales", "Range", 1, 1, row - 1, maxColumn);         WorksheetPart pivot = WorksheetAccessor.AddWorksheet(doc, "Pivot");         WorksheetAccessor.CreatePivotTable(doc, "Sales", pivot);     }     streamDoc.GetModifiedSmlDocument().SaveAs("../../NewPivot.xlsx"); }

The first part of the code is much like the process I showed in Part 1. It fills in the data from an external text file. After that, there are just a few method calls to set up an empty pivot table that is ready to be configured. I discuss both parts in the screencast below. I will also be posting another screencast in a few days that goes over the technical details of creating the XML for a pivot table. Then next week, I will post more information about how to configure the rows, columns, filters, and data values for the pivot table. That gets really technical, so be warned. I don't have a sample for that, yet, but I might be encouraged to create one if there is enough interest.

(Please visit the site to view this video)

Forum Post: Html with base64 images

Ihor — Tue, 24 Jan 2012 09:52:00 GMT

I have html report with images in base64 format like <IMG src="data:image/gif;base64,R0lGODlhWAL6APcAA.../> ? now I try to insert this html into Word document by altChank
In result I have docx package with my html, but Word display image in document as box with [x].

How I can solve this task? All images must be works in offline. I think that i need to parse result document, find and replace img base64 to image files but how?

Forum Post: Re: Word Document Merging from new page

Hemanth — Tue, 24 Jan 2012 09:45:00 GMT

Hello,

Can anybody suggest any simpler way to merge the documents those have different formats and header & footers. The output document should have same page size and header & footer for all pages.

I guess there is a work around for this but, a bit lengthier way to execute. First we need to merge each document with the template that have predefined page size(Keep Sections as false), then merging all those documents with the keep sections property as true we can get the output document that has same page size for all pages in that document.

Regards,

Hemanth M