chenxizhang

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Hosting;

namespace web
{
    public class Program

chenxizhang

/// <summary>
    /// 自定义的WebClient，支持Cookie，在多个请求之间可以重复利用
    /// 作者：陈希章
    /// 邮箱：ares@xizhang.com
    /// 时间：2017年9月17日
    /// </summary>
    public class WebClientWithCookie : WebClient
    {
        /// <summary>
        /// 默认构造器，创建一个空白的CookieContainer

chenxizhang

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Identity.Client;
using Microsoft.Graph;
using System.Net.Http;

/// <summary>

chenxizhang

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Tools.Ribbon;
using Microsoft.Office.Interop.Excel;

namespace ExcelAddIn3
{
    public partial class Ribbon1

chenxizhang

Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Tools.Ribbon

Public Class Ribbon1

    Private Sub Ribbon1_Load(ByVal sender As System.Object, ByVal e As RibbonUIEventArgs) Handles MyBase.Load

    End Sub

    Private Sub Button1_Click(sender As Object, e As RibbonControlEventArgs) Handles Button1.Click

chenxizhang

Sub ReportGeneration()
    ' 这个方法用来生成销售数据，并且基于这些数据生成一个柱状图表
    ' 作者：陈希章
    
    Dim sh As Worksheet
    Set sh = ThisWorkbook.Worksheets.Add
    
    sh.Activate
    
    Dim rng As Range

chenxizhang

name: GetAPIValues
description: ''
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    async function run() {
      await Excel.run(async (context) => {

chenxizhang

Summary

• 系列文章简介
• Office 365开发概述及生态环境介绍
  1. 上篇
  2. 下篇
• Office 365开发环境搭建
• Microsoft Graph
  1. Microsoft Graph 概述

1. 通过GraphExplorer体验Microsoft Graph

chenxizhang

using Microsoft.Graph;
using Microsoft.IdentityModel.Clients.ActiveDirectory;
using System;
using System.Threading.Tasks;

namespace MicrosoftGraphSampleUseADAL
{
    //这个代码演示了如何使用ADAL和Microsoft Graph库来实现访问，并且分别实现了国际版和国内版
    //作者：陈希章

chenxizhang

name: YouImage
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(run));

    var dec2hex = function(d) {
      if (d > 15) {