Microsoft Excel 2013 Programming by Example with VBA, XML, and ASP (Paperback)

Julitta Korol

  • 出版商: Mercury Learning
  • 出版日期: 2014-03-27
  • 售價: $2,040
  • 貴賓價: 9.5$1,938
  • 語言: 英文
  • 頁數: 800
  • 裝訂: Paperback
  • ISBN: 1938549910
  • ISBN-13: 9781938549915
  • 相關分類: ExcelXML
  • 無法訂購

買這商品的人也買了...

商品描述

This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web. Microsoft Excel 2013 Programming by Example with VBA, XML and ASP is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2010, this book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and programming advanced Excel features such as PivotTables, PivotCharts, and SmartTags. The chapters are loaded with illustrated hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.

Features:
  • Explores in great detail the latest version of Excel and all of its features.
  • Covers recording and editing a macro and writing VBA code through working with XL documents and using ASP to display data on the Web.
  • Covers Office Web Apps.
  • 商品描述(中文翻譯)

    這本書適合已經熟悉 Excel 使用者介面的讀者,並通過多個多步驟的實際練習介紹程式設計概念。更進階的主題則透過自定義專案引入。本書涵蓋了錄製和編輯巨集以及使用 VBA 程式碼,並透過處理 XML 文件和使用 ASP 在網頁上顯示資料來進行學習。《Microsoft Excel 2013 Programming by Example with VBA, XML and ASP》是一本實用的 Excel 程式設計指南,適合已經熟悉 Excel 使用者介面的讀者。本書通過多個多步驟、圖解、實際操作的練習介紹程式設計概念。更進階的主題則透過自定義專案引入。從錄製和編輯巨集以及撰寫 VBA 程式碼,到處理 XML 文件和使用經典 ASP 存取和顯示網頁上的資料,本書將帶領您進入一個改變您與 Excel 互動方式的程式設計之旅。本書已完全更新至 Excel 2010,提供了有關在檔案、資料夾和其他 Microsoft Office 應用程式上執行自動操作的資訊。它還涵蓋了事件程序的正確使用、測試和除錯,以及程式設計進階的 Excel 功能,如樞紐分析表、樞紐圖和智慧標籤。每個章節都充滿了圖解實際操作的專案和練習,告訴您在哪裡輸入程式碼、如何進行除錯,然後運行它。本書的特點包括:詳細探索最新版本的 Excel 及其所有功能、涵蓋錄製和編輯巨集以及使用 VBA 程式碼,並透過處理 XL 文件和使用 ASP 在網頁上顯示資料進行學習、涵蓋 Office Web Apps。