Category Archives: Microsoft Office

C# Read Excel file with worksheets

using System.Data; using System.Data.OleDb; private void readExcel () { OleDbConnection conn = new System.Data.OleDb.OleDbConnection((“provider=Microsoft.ACE.OLEDB.12.0; ” + (“data source=C:\\Projects\\Driver Reports.xlsx; ” + “Extended Properties=’Excel 12.0;HDR=Yes;IMEX=1;’;”))); // Select the data from Sheet1 of the workbook. OleDbDataAdapter ada = new OleDbDataAdapter(“select * from … Continue reading

Posted in Excel, SharePoint 2016, Visual Studio 2010 | Leave a comment

Outlook 2010 sync “SharePoint List cannot be found.”

Reference: http://mikessharepoint.wordpress.com/2011/04/18/outlook-2010-sync-sharepoint-list-cannot-be-found/ Ran into a funny problem today and decided to blog about it, since I spent so much time with it. A user came to me today saying he couldn’t get the “Connect to Outlook” sync working with a … Continue reading

Posted in Outlook, SharePoint 2010 | Leave a comment

WORD, EXCEL file from SharePoint is opened very slowly

Go to IE >> Internet Options >> Connections >> LAN Settings: Then uncheck the box for “Automatically detect settings” This will make opening WORD and EXCEL file faster.

Posted in Microsoft Office, SharePoint 2010 | Leave a comment

Update Single/Multiple Lookup field in SharePoint 2010 using WCF Data Services, REST API, C#

If you want to use SharePoint 2010 WCF Data Services to update SharePoint lookup field in a list; you need remember following things: To update single Lookup field: Use Id to reference to the looked up list object to the … Continue reading

Posted in Outlook, SharePoint 2010, Visual Studio 2010 | Leave a comment

Access and SharePoint 2010 Integration

Option 1: Save the Access file into a SharePoint document library and share with others; Option 2: Create lists and document libraries in SharePoint; Go to “Datasheet View”, open the task pane on the right, “Track this list in Access”; … Continue reading

Posted in Access, Microsoft Office, SharePoint 2010 | Leave a comment

Examples of commonly used Excel formulas

http://office.microsoft.com/en-us/excel-help/examples-of-commonly-used-formulas-HP005200127.aspx  

Posted in Excel, Microsoft Office | Leave a comment

Excel Magic Trick: Date Functions & Formulas

Posted in Excel, Microsoft Office | Leave a comment