1 / 16

Excel Services

Excel Services. Dennis Vroegop. Over mij…. Dennis Vroegop Software Architect Detrio Microsoft C# MVP Voorzitter dotNed, de grootste nederlandse .net gebruikersgroep. Een verhaaltje. Excel Services. Overzicht. Demo!. Development.

Download Presentation

Excel Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Excel Services Dennis Vroegop

  2. Over mij… • Dennis Vroegop • Software Architect Detrio • Microsoft C# MVP • Voorzitter dotNed, de grootste nederlandse .net gebruikersgroep

  3. Eenverhaaltje

  4. Excel Services Overzicht

  5. Demo!

  6. Development (ikbenimmers C# MVP, dus C# hoorterbij….  )

  7. Development • http[s]://[server]/_vti_bin/ExcelService.asmx • Definieer Status[] outStatus • Gebruik de SessionIdvoorallecommunicatie • Vergeetniet de workbook tesluiten

  8. Demo!

  9. Beperkingen

  10. Niet ondersteund (I) • ActiveX Controls • External references (naar andere workbooks) • XML Expansion packs • XML Maps • Data validation • Query tables, SP lists • Workbook met Add-Ins

  11. Niet ondersteund (II) • Embedded pictures / clipart • Cell en sheet background pictures • Autoshapes en WordArt • Ink annotations • Organization charts / diagrams • DDE Links

  12. Niet afgebeeld • Split / frozen panes • Headers en Footers • Page Layout view • Cell Patterns • Zoom • Sommige formatting

  13. Beperkt aanwezig • Interactieve Pivot Charts • Interactieve Pivot Reports • Go To • Zoom, minimize, maximize • Page Layout • Goal Seek / Scenario Manager • Formules • Calculation mode veranderen • Watch Window

  14. Samenvatting • Excel is eengoederekentool • “One version of the truth” • Scheidingtussendomeinkennis en technischekennis • Probeer het eens!

  15. Dank voor de aandacht! dennis@dotned.nl http://www.dotned.nl

More Related