CAD二次开发-c#创建Excel表格及其一系列简单应用

创建Excel

创建Excel必要索引库：NetOffice 需版本对应

 			Excel.Application application = new Excel.Application();

            Excel.Workbook book = new Excel.Workbook();

            Excel.Worksheet sheet = (Excel.Worksheet)book.Worksheets[1];

            sheet.Cells[1, 1].Value = "测试";

            book.Save();

            application.Quit();

            application.Dispose();

Excel保存对话框

 public static string OpenSaveDialog(Editor editor,Database db)
        {
   
            string directoryName = Path.GetDirectoryName(db.Filename);

            string fileName = Path.GetFileName(db.Filename);

            fileName = fileName.Substring(0, fileName.IndexOf('.'));

            PromptSaveFileOptions promptSaveFile = new PromptSaveFileOptions("保存Excel文件");

            promptSaveFile.DialogCaption = "保存Excel文件";

            promptSaveFile.Filter = "Excel 97-2003 工作薄(*.xls)|*.xls|Excel 工作簿(*.xlsx)|*.xlsx";

            promptSaveFile.FilterIndex = 1;

            promptSaveFile.InitialDirectory = directoryName;

            promptSaveFile.InitialFileName = fileName;

            PromptFileNameResult fileRes = editor.GetFileNameForSave(promptSaveFile);

            if(fileRes.Status == PromptStatus.OK)
            {
   
                fileName = fileRes.StringResult;
            }
            else
            {
   
                fileName = "";
            }

            return fileName;
        } 

自定义数据

      public struct TextData
        {
   
            public string content;
            public double x;
            public double y;
            public double z;
        }

将获取到的id数组数据转为自定义数据数组

 private TextData[] GetTextDatas(ObjectId[] ids,