Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

Why Office server side automation is not supported, EWS Links, Open XML starter pack

1)      Considerations for server-side Automation of Office – http://support.microsoft.com/kb/257757/en-us

 2)      EWS API links – Below are some starter links. 

 Exchange for developers – http://msdn.microsoft.com/en-us/office/dn448484

 Developer roadmap for Exchange – http://msdn.microsoft.com//library/office/dd877025(v=exchg.150)

 Get started with EWS Managed API client applications –http://msdn.microsoft.com/en-us/library/office/jj220499(v=exchg.80).aspx

 EWS Managed API concepts – http://msdn.microsoft.com/en-us/library/office/dd633649(v=exchg.80).aspx  

 Working with the EWS Managed API – http://msdn.microsoft.com/en-us/library/office/dd633696(v=exchg.80).aspx

 Microsoft Exchange Web Services Managed API 2.1  – http://www.microsoft.com/en-us/download/details.aspx?id=42022

 C# Sample code:

        //pass the credential and EWS asmx detail

       privateint GetUnreadCount()

        {

            ExchangeService service = newExchangeService(ExchangeVersion.Exchange2013);

            service.Url = newUri(“https://yourcasserver/ews/exchange.asmx“);

            service.Credentials = newWebCredentials(“Username”, “Password”);

 

            Folder inbox = Folder.Bind(service, WellKnownFolderName.Root);

            SearchFilter sf = newSearchFilter.SearchFilterCollection(LogicalOperator.And, newSearchFilter.IsEqualTo(EmailMessageSchema.IsRead, false));

            ItemView view = newItemView(50);

            view.Traversal = ItemTraversal.Shallow;

            FindItemsResults<Item> findResults = service.FindItems(WellKnownFolderName.Inbox, sf, view);

            //get the count

            int count = findResults.Count();

            return count;

        }

3)      For Open XML, http://www.microsoft.com/en-us/download/details.aspx?id=17985

By default, this download installs files to the following locations:

i. Visual C# snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual C#\Open XML SDK 2.0 for Microsoft Office 2010

ii.  Visual Basic snippets. PersonalFolder\Visual Studio 2010\Code Snippets\Visual Basic\Open XML SDK 2.0 for Microsoft Office 2010

Generating Excel 2010 Workbooks by using the Open XML SDK 2.0  

http://msdn.microsoft.com/en-us/library/hh180830(v=office.14).aspx

4)      Regarding EWS Editor – http://ewseditor.codeplex.com/

Advertisements

May 29, 2014 - Posted by | Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: