Category Archives: Excel

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

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

Link an Excel workbook to a SharePoint list

http://www.youtube.com/watch?v=weyli9OGJhk You can export a SharePoint list to an Excel workbook and do data analysis on Excel. When data in SharePoint list is changed, it will change the Excel workbook as well, so you will always have an up-to-date Excel … Continue reading

Posted in Excel, Microsoft Office, SharePoint 2010 | Tagged , | Leave a comment

Excel 2007 – How to Create a Summary Report from an Excel Table

Posted in Excel, Microsoft Office | Leave a comment