.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.

2010-07-01 19:00:00   Source: Excel Services in SharePoint 2010   Tags: SharePoint

Excel XML Writer /Reader

Excel XML Writer /Reader - Enables to generate excel xml with hidden columns and lookups
2010-07-25 16:38:00   Source: Excel XML Writer /Reader   Tags: Office

How to : Get Excel data into a .NET DataSet object

There may be requirement where in data in an Excel sheet has to be manipulated inside .NET Applications. Although there are many ways to achieve this (like using Excel object of COM), the most preferred way is to use the .NET Data providers to achieve this. This article discusses on the same.
2005-12-22 11:12:42   Source: How to : Get Excel data into a .NET DataSet object   Tags: Examples

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.

2007-03-13 23:08:46   Source: Enterprise Reporting with Excel   Tags: Office

Excel Services: Develop A Calculation Engine For Your Apps

The Excel Services architecture lets users design their own algorithms and share workbooks on a server.
2007-06-18 19:00:00   Source: Excel Services: Develop A Calculation Engine For Your Apps   Tags: Office

Excel to SQL without JET or OLE

Import an Excel ".xls" into SQL without the use of JET or OLE
2010-07-13 08:48:00   Source: Excel to SQL without JET or OLE   Tags: Office

Export .net MSChart to Excel/PDF Using Report Viewer 2010

This article will demonstrate the approach to use the report viewer control to act as a medium to export image,web form in PDF/Excel .This will help us to do away with third party control to achieve our end objectives.
2011-10-03 04:27:00   Source: Export .net MSChart to Excel/PDF Using Report Viewer 2010   Tags: Office

How to Display ASP.NET DataGrid Data in Excel

This tip shares code that allows you to display ASP.NET DataGrid data in Excel.
2006-04-17 22:57:40   Source: How to Display ASP.NET DataGrid Data in Excel   Tags: ASP.NET

Data Export from Database to Excel, PDF and Word for .NET without Automation and Acrobat Reader

This article introduces how to export data from database to Excel, PDF, MS Word, HTML, MS clipboard ,XML, DBF, SQL Script, SYLK, DIF, CSV without Automation and Acrobat Reader.
2011-02-12 02:18:00   Source: Data Export from Database to Excel, PDF and Word for .NET...   Tags: XML

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.

2010-12-27 18:00:00   Source: The Baker’s Dozen: 13 Productivity Tips for Using...   Tags: Examples
‹ Previous12Next ›