Every file created by a Microsoft Office application supports a set of built-in document properties. In addition, you can add your own custom properties to an Office document either manually or through code. You can use document properties to create, maintain, and track information about an Office document such as when it was created, who the author is, where it is stored, and so on. To get or set the properties you can use automation to extract the Microsoft Office application properties.
Take a look at the following links for samples:
But what happens if you are working with a Web-based application and you want to avoid the use of automation in a Web server…
I found a nice workaround to extract Office document properties without using automation. You can use the Dsofile, an in-process ActiveX component that allows you to read and to edit the OLE document properties that are associated with Microsoft Office files, such as the following: • Microsoft Excel workbooks• Microsoft PowerPoint presentations• Microsoft Word documents• Microsoft Project projects• Microsoft Visio drawings• Other files without those Office products installed
If you are working with a managed application follow the next steps:
You can also extract custom properties using the DSOFile control. Have a peek and enjoy!
Office has a deeper integration with XML technology and developers are always looking for tips and tricks to work with XML documents. Office provides support to work with XML and you might be one of those developers that is programmatically generating Word documents (using WordprocessingML) , Excel spreadsheets (using SpreadsheetML), PowerPoint slides (using PresentationML), or Visio diagrams using (DataDiagrammingML). I think it always comes handy to have a list of tips and tricks to work with XML, and today I will share with you three simple ways of indenting an XML file/document.
Indenting XML files might sound as one of those netpick or nice-to-have enhancements that you don’t really need when you are working with XML. However, lots of applications and tools generate programmatically XML files and it always comes handy to open a nice and readable indented XML file instead of a “how can I edit this!” single line of eternal XML elements.
For managed applications:
For any platform:
Happy Office XML programming!
Today is a great day for Microsoft: Visual Studio 2005, SQL Server 2005, and Biztalk were launched. I want to share with you the list of my favorite Visual Studio 2005 features and some pointers to articles, videos, code samples, and sites where you can find further information:
Watch this video:
You can find more videos here: Absolute Beginner’s Video Series
I know that when someone from Microsoft states that a product is good, it sounds like marketing. But I have to tell you that I am being honest and talking only as a developer that is quite excited to experience and work with Visual Studio 2005. The best you can do is to give it a try.
I am currently developing an application that will help my team (Office Developer Documents) to manage all the metadata associated with the publishing process in MSDN. The name of the tool is Rawhide and it’s a Web-based application. I am really excited of developing this tool because I am working with Whidbey, ASP.NET 2.0, SQL Server, Windows Sharepoint Services, and a cool set Office development features. Soon I will start adding Office “12” enhancements such as Excel Services and Windows Sharepoint Services “v3”. I can’t wait!
I am learning a lot from my peers about how interesting it is to publish content in MSDN and I hope this tool will improve our working experience and become a great source of code snippets that I can share with the community.
Today I was reading the newsgroups and I was looking at lots of posts where developers are looking for code that will help to upload programmatically files to a SharePoint library. I was surprised to see that there are lots of developers struggling with this issue. I am too :). One of Rawhide’s features is to submit our articles, code samples, and art to a SharePoint Library.
I found two great articles that are helping me out to accomplish my mission. I know there are many ways of doing that, but this is the recommended one by Microsoft and I love it because it has just what I needed and it has code in C# and VB.NET:
Uploading a File to a SharePoint Site from a Local Folder
I also found this page that has all the information I need to work with the SPFileClass.
And finally, I found this interesting blog entry at Bill Simser’s blog where he talks about the Syncronization of Office Document Properties with WSS Document Libraries. I haven't tested this yet, but apparently, if you create the following properties in a Sharepoint library or list:
Subject Author Manager Company Category Keywords Comments Hyperlink base "The MS/Office documents that are upload inherit such corresponding custom MS/Office properties : "Subject0 Author0 Manager0 Company0 Category0 Keywords0 Comments0 As soon as I complete my "upload files to SharePoint" features in Rawhide, I will keep you posted with the outcome.
Technology and the Internet created an information revolution that has changed our lives. Today, Bill Gates announced a new set of internet-based services that change the delivery and business models for software. Microsoft has been quite successful with X-Box live and I can tell you that I have seen that having a “live” game completely modifies the experience. So I find quite exciting that Windows Live™ and Microsoft® Office Live were announced.
Windows Live™ is a set of personal Internet-based services and software that you can subscribe to get the information and resources that YOU want, for example email, messenger, your favorites, and more. What is the advantage? For example, you no longer will need to transfer your favorites (I hate that) from machine to machine. Subscribe and take a look at some Windows Live services here: http://ideas.live.com.
Microsoft® Office Live is a new set of Internet-based services and software that will allow people and organizations to subscribe to specific services that integrate with Microsoft Office programs including Microsoft Outlook®, Microsoft Excel®, Microsoft Office Live Meeting and Microsoft Office Small Business Edition. Subscribe and take a look at some Microsoft® Office Live services here:http://www.microsoft.com/office/officelive/
Office Live has different offerings:
So depending on your needs you can choose the best services and over time, both Windows Live and Office Live services will expand and provide new services that you can subscribe to.