.NET news » Search results
Search results for query "excel 2016" (14):
Excel Services in SharePoint 2010
Excel services is yet another important pillar in Microsoft’s business intelligence offering. Business users really like Excel because it is easy to use and they can add complex formulas to Excel to express their logic.They can do so without involving the IT guy. The problem with this scenario, however, is that it becomes very difficult to share some Excel sheets with their coworkers. Usually users prefer to send workbooks via email, but sometimes the workbooks are too large for email, sometimes they have backend data connections, and sometimes workbooks send via email cause version confusion hell.
Excel XML Writer /Reader
How to : Get Excel data into a .NET DataSet object
Enterprise Reporting with Excel
You can create reports in many ways, with or without Excel. If you look only at reporting solutions that use Excel, the list roughly gets narrowed down to three:
- SQL Reporting Services
- Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System (VSTO)
- Server-side Excel Automation
Of course you can imagine more solutions, but in essence they will not deviate much from the above list. In this article, I'll first look at SQL Reporting Services and VSTO to examine their plusses and minuses, and then I'll take a detailed look at why and how you would build a server-side solution.
Excel Services: Develop A Calculation Engine For Your Apps
Excel to SQL without JET or OLE
Export .net MSChart to Excel/PDF Using Report Viewer 2010
How to Display ASP.NET DataGrid Data in Excel
Data Export from Database to Excel, PDF and Word for .NET without Automation and Acrobat Reader
The Baker’s Dozen: 13 Productivity Tips for Using Microsoft PowerPivot and DAX Formulas
I know what you’re thinking: an article in CODE Magazine about Excel and PowerPivot? Yes, that’s correct; this installment of the “Baker’s Dozen” covers an important new tool to come out of Redmond: Microsoft PowerPivot. In a nutshell, PowerPivot provides some of the business intelligence capabilities that developers are accustomed to seeing in OLAP tools like Microsoft Analysis Services. So why should you and I care? Because these “end-user” tools still require some programming and configuration. So in this article, I’ll cover the installation of PowerPivot, a brief example of how to use it in Excel - and of course, since this IS CODE Magazine, I’ll show some DAX formula expressions to get the most out of PowerPivot.