wordpress hit counter
Feedback Requested: Are you developing for the Cloud with Open XML? - OpenXML Developer - Blog - OpenXML Developer
Goodbye and Hello

OpenXmlDeveloper.org is Shutting Down

There is a time for all good things to come to an end, and the time has come to shut down OpenXmlDeveloper.org.

Screen-casts and blog posts: Content on OpenXmlDeveloper.org will be moving to EricWhite.com.

Forums: We are moving the forums to EricWhite.com and StackOverflow.com. Please do not post in the forums on OpenXmlDeveloper.org. Instead, please post in the forums at EricWhite.com or at StackOverflow.com.

Please see this blog post for more information about my plans moving forward.  Cheers, Eric

Feedback Requested: Are you developing for the Cloud with Open XML?

Feedback Requested: Are you developing for the Cloud with Open XML?

  • Comments 10

This blog post is a request for information. We’re interested in doing a series on how to build with Open XML in the cloud and we want to hear what you are doing and how we can help. 

  • Are you developing for the cloud, and does Open XML figure into your solution in any way, shape, or form?
  • Do you want to use Open XML in the cloud, but don’t know the correct technologies to use?
  • In what scenarios (broadly speaking) would Open XML be useful to you in the cloud?
  • What examples or proofs-of-concept would be useful to you?

I’ve been considering all of the following usage scenarios for Open XML in the cloud. Do these fit your needs? Are there more you would like to see?

  • Generation of a document in the cloud, and making it available for download to the user’s computer through the browser.  Imagine updating a database in the cloud, and then generating a report for upper management from that database.
  • An advanced version of document generation: compile a complex document from a variety of other Open XML documents.  Imagine assembling a legal document from a collection of ‘stock’ legal documents.
  • Document validation – imagine a scenario where a large government organization accepts grant applications via Open XML.  They might have some requirements, such as that the document contains no tracked revisions or comments.

Of course, I am very much interested in what you can do with Open XML in Windows Azure, but I am also interested in what you can do with Open XML on a variety of other cloud platforms.

Please respond in the comments below – let’s make this a public discussion.  I am fully aware that the vast majority of Office and Open XML development does not happen in the cloud, so if you are in the minority that is doing cloud development and are using Open XML, please let me know what you are doing, and how we can help.

-Eric

  • Hi Eric,

    You and I corresponded via email some months back about an issue I was having repeating data across table columns (not just down rows). I managed to hack something together for that but it was elegant or dynamic so I moved on until the problem resurfaces. But I digress..

    For me, pretty much yes to all of the above!

    Basically every major web app I've put together in the last 6 months has features openxml in some form. At the moment I'm putting together a CRM in ASP.NET MVC which generates invoices from the database and emails to the end user. The same system is also producing order forms to external vendors again using openxml.

    The only shortcoming I have with this process is the ability to produce PDF's server side without Sharepoint (yes, I just tweeted about 5 minutes ago at you!). I'm working on a webserver and I've found little support for anything except Microsoft Office Automation which isn't the preferred method, or it costs about $2k per site.

    Apart from this I've done two pretty major implementations which are template driven but have more flexibility for the end user to interact and change the templates. One is a workflow and tracking system which produces a number of key documents during the lifecycle which are hosted and downloadable through the website, as well as emailed automatically as part of certain processes.

    My largest is a legal document preparation system which has hundreds of template documents which are populated based on user input through the app in the cloud and downloaded the local PC. I've extended that one to include a word addin which allows the users to generate templates based off a pre-defined structure with custom calcs etc.

    Is there any specific feedback you're all after? :)

  • I am. It's an cloud-based convertion service from Open XML to another format. The only reasons it is cloud-based instead of local are to ensure source-code of the conversion code is safe and can be easily updated regularly with fixes, new conversion routines, etc..

  • Great, thanks.  I think that cloud is important, and will be coming out with new content over the next six months showing how to use various technologies with Open XML.

    I appreciate the responses.  For folks who have not responded yet but are working in the cloud with Open XML, please do consider letting us know about your scenario.

    Thanks, Eric

  • NuPitch is a commercial application that utilizes OpenXml to generate personalized documents utilizing the Open Xml SDK in Azure.

    Users define templates within native Office applications with our plug-in that define variability in a document.   This can include simple variable replacement, dynamic table and charts, external images, rule based content selection, etc..  

    Data that drives the personalization can come from Salesforce.com, Microsoft Dynamics, any web service that returns XML or JSON, Excel spreadsheets, flat files, SQL Azure, or a variety of other commercial data providers.

    Once the template is complete the template is uploaded to Azure and can be requested through a Silverlight application or on the iPad.  

    The entire system requires no programming of any kind.  This includes data access, open xml manipulation, and the requester interfaces used to request the documents.

    Throughout the process of building the application we've found this site to be a very valuable resource.   As you move forward with a discussion about cloud hosted solutions that utilize Open Xml we'd love to return the favor and participate in the discussion.

  • Hi,

    I have published an applicationfor WP7 named 'Tennis Player Stats'. In this app, I upload to SkyDrive an xlsx file generated with fantastic Silverlight API by Chris Klug. Evrything works fine except that open xml schema doesn't accept French culture and I encounter an issue with decimal separator forced to '.' . Excel files don't open on Office web apps.

    I resolve that by dynamiclly change culture when writing the file. Now everything works fine !!!

  • HI Eric,

    We might start working on a system that is based on OpenXML to generate insurance documents like your scenario 2. The system will be hosted on the cloud. The user can upload the document templates and data to the cloud to assemble the complex insurance documents.

    Like the 'wildest' case, we found that the OpenXML and its SDK provides all of capability to create Docx but often a solution does not end up with a Docx document. We also need the ability to easily convert Docx to PDF from a server perspective.

    Thank you very much for teaching us the Open XML!

  • My company Active Interface is building cloud services for generating PowerPoint reports (and perhaps Word). Our current solutions use COM automation. We are designing our new system based upon OpenXML.

    I am looking for a developer/consultant to assist. Any PresentationML experts here feel free to contact me.

  • Yes, in particular expanding upon the Validation theme:  upon read/write/delete actions, reading some Document Properties and Content Controls, and file checksum, comparing against an external data source, before allowing an action.

  • Our company, Assette, offers a  cloud-based reporting solution for asset managers and investment advisers.  We have had a PPT based solution since ~2005, and now in the process of moving to PPTX using OpenXML.  Any development help, especially developing with Azure AppFabric will be much appreciated.  Likewise, we would be happy to help/participate in any initiative to further PresentationML knowledge and best practices across the Open XML development community.”

    I've started looking in to PresentationML, and your screen casts and I've gained some knowledge on OpenXml.  we do extensive table processing, custom pagination of tables, cloning slides, creating shapes via a custom PowerPoint Addin, and merging, manipulating table cells for formatting. i would really appreciate any help or references on these.

    Thanks,

    Aneef

  • www.futurebeyondtechnology.com Even in our less than stellar economic environment, college grads, if they are smart and are willing to think beyond their partying ways, can give themselves an edge by thinking ahead, between all those parties and games.

    http://www.futuristicjobs.com What does it take as a top-notched futurist? Well, there happens to be quite an improvement of opinion when it comes to this question. Not way back when, a young lady who'd served our nation in the armed forces and later experienced the real estate building sector asked me this question.

    www.greatseomarketing.com Online marketing is a way to reach out to a wider customer base, a way to get your business the accolades and the visibility it deserves and a way to earn all those profits that you might not have ever imagined of, if you're stuck performing only in real life.

    http://www.healthayrveda.com In the far faraway past in the majestic Himalayas, the science of Ayrveda began a long evolution over the course of 5, 000 years. A synergistic system which combines science, faith and philosophy, Ayurvedic medicine was originally practiced by the prophets known as rishis. Learn more about ayurvedic medicine here.

    www.healthosteopathy.com Osteopathy is the fastest growing health profession in america, Canada & Europe. It has been chosen as one of the top 25 occupations in demand by CIBC. It is a superb career choice for folks interested in becomming a physician.

    www.healthtraditional.com Are you tired of giving the same old gifts over and over again? Everyone has purchased and received numerous baskets of shower gel and lotion and quite a few small pots of flowers over the years. Eventually, everyone reaches a place where they want to give something different.

    http://www.helpmarketseo.com Marketing SEO solutions are powerful and effective tools that will greatly increase your online presence by generating quality traffic to your website. This will skyrockets your search engine ranking positions, which ultimately leads to making a lot of money using the internet.

    http://www.homeexclusively.com Find out why most home buyers try a Realtor to purchase their home, and are glad they did! Exclusive buyers agents provide home buyers with protection possible, plus have the experience to help you find the right home, and negotiation the best price and terms.

    http://www.improveautos.com In today's soft economy and having used the toughest years in the industry, auto dealers want closely at opportunities for enhanced and improved profit. Generally considered a "necessary evil", the describing department is now being looked at a source of new gross margin and profit.

    www.initialparenting.com Parents are the key to success. Programs begun to initiate parent weekends, parent seminars and other ways to pull the parents into the healing process. This encourages a more healthy view that these are family problems not just a child's problem.

    www.insurancedeadlines.com If you do not make a determination before it closes, "You rest, you lose". You will have to wait prior to the next open enrollment period to select a plan. Oh wait... You will have to pay a tax penalty as well. Whoa!

    www.insuranceextention.com There are so many health insurance coverages companies coming up these days that you can be sure you will get an insurance that will fit for you and the kind of premiums you want and that too at an affordable price.

    www.insuranceinevitable.com A term insurance policy of life insurance products is only to offer life coverage during the period you have decided as the term of that particular plan. When that term has ended, it's your wish if you continue, that you can, or leave the plan.

    www.insurancesuperhub.com If you are sitting in the middle of the spider web, with all the lines running outward linked to the other line, and whenever someone you are connected to create a connection for you, you can make the vibration coming from that direction. What is really happening is that all person you are connected to is the center of a web of their own.

    http://www.lawbasis.com To date, traditional international law does not consider human environmental rights to a clean and healthy environment to be a jus cogens human right. Jus cogens ("compelling law") refers to preemptory legal principles and norms that are binding on all international States, regardless of their consent.

    http://www.lawdecree.com Whenever you are looking to begin a business (doesn't matter if it is an online or traditional venture), it's always good to get in touch with legal experts or local governing bodies to get an idea of legal guidelines that will affect your business.

    http://www.lawyersdemand.com Bankruptcy is quite a serious matter and there is nothing worse for an individual or a corporation than having to file for bankruptcy. It can impact many people and ruin their careers and lives and establish them completely helpless.

    www.lawyersselection.com The damage may be in the form of physical injury, monetary loss or in the form of psychological effects. In legal language, we use the term personal injury for those three things. Personal injury can be physical, psychological and monetary or all of them in nature.

    www.livetelecastnews.com A watching live sports event on TV is an enjoyable experience for sports fans. Through cable and satellite ongoing, live telecast of soccer tournaments can be watched on TV. Ordinary people can also have the chance to watch the favorite sport on earth through their television set.

    www.myhomedevelopment.com When choosing a community to build your new home there are some key questions to ask the new home developer before deciding whether you want to build in that community or not. Read this article to find out what those key questions are.

    http://www.newsrepeats.com In our last article we discussed what is this great and media, and how you might know very well what underlying message they are giving us with the use of something called Narrative Theological Biblical criticism.

    http://www.overseebusiness.com It is all too easy to take the roof over your business for granted, and it is something that most people very rarely think about during the day time. It is always there; it's probably that it was there before you started working at your company, and it will probably be there long after you have moved on to another job.

    http://www.parentinggood.com Learn how to influence your son or daughter's behavior without them knowing it. Developing children with high self-esteem and confidence requires these 5 secrets that show you how help them win at life. Give them the edge they need to succeed and they'll have the skills needed to achieve their dreams.

    http://www.petsrights.com Fleas and ticks -- there's seems to be no end to their recurrence. Fortunately there's an easy way to control this, with Frontline Plus. Here's a concise guide on Frontline Plus and how it can benefit your dog.

    http://www.powerfulsport.com This article explains the common misconception that the sport of Powerlifting is a Power sport but in fact is the complete opposite. It is a strength sport. This article will explain the difference between the two types and show you how both are excellent tools for lessons in not just powerlifting but all sports.

    http://www.preferjob.com This installment of the ongoing resume writing tip series focuses on putting your title to work for you. This article suggests you in the ante (and power) by including an action focused title that demonstrates how you will impact the business.

    www.preferrealestate.com Buy low, sell high, it's a credo discomfort heard before, and it sounds like a sure way to make income using your real estate investment, right? Well, it's harder than that quote makes it sound and you have to work diligently to ensure you see a great, high return.

    http://www.proinjobs.com A plumber is a professional who accounts for repairing and installing the pipes that are used to carry sewage and water. The majority of plumbers work in the plumbing or ac industry, but nearly 14 percent of plumbers are self-employed.

    www.purchaseshopping.com Have you ever thought about growing your own hops, stop thinking and start now. It is easier than you think and coupled with the knowledge that the beer that you have hand crafted contains hops that you have grown in your own back garden and you have a compelling argument to give it a try.

    www.readyforservices.com College students are graduating, and Commemorative Day is fast approaching, which means summer is nearly here. Getting ready for summer doesn't have to be a painful experience; teach yourself healthy habits that you can continue all through the year that will help you get into shape and stay in shape.

Page 1 of 1 (10 items)