VSTO 绘制Excel图形

最新推荐文章于 2023-12-19 15:58:28 发布

原创

最新推荐文章于 2023-12-19 15:58:28 发布 · 885 阅读

3 ·

CC 4.0 BY-SA版权

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

namespace ExcelAddIn1
{
    public partial class Ribbon1
    {
        private void Ribbon1_Load(object sender, RibbonUIEventArgs e)
        {

        }

        private void button1_Click(object sender, RibbonControlEventArgs e)
        {
            Worksheet currentSheet = Globals.ThisAddIn.Application.ActiveSheet;

            var activeApp = Globals.ThisAddIn.Application;

            int sRowCount = currentSheet.UsedRange.Rows.Count;
            Range serialNumbers = currentSheet.Range["A2:A" + sRowCount];
            Range dataCells = currentSheet.Range["B2:B" + sRowCount];

            //Put the datacells into array
            object[,] originalData;
            originalData = dataCells.Value2;

            int elementCount = 0;
            double[] originalDataArr = new dou