spreadsheetControl1 单元格

spreadsheetControl1 单元格

   spreadsheetControl1.LoadDocument(Application.StartupPath + "//table//1水//水质分析试验记录表.xlsx", DocumentFormat.OpenXml);
            IWorkbook workbook = spreadsheetControl1.Document;
            Worksheet worksheet = workbook.Worksheets[0];
            worksheet.Cells["B1"].Value = DateTime.Now;

//要设置的单元格

       CellRange usedRange = worksheet.Range["C3:D4"];

设置的单元格的形式

 worksheet.CustomCellInplaceEditors.Add(usedRange, CustomCellInplaceEditorType.ComboBox, ValueObject.FromRange(worksheet["T9:T9"]));

alueObject.FromRange(worksheet["T9:T9"]  取值地