C# (CSharp) HSBC.InsuranceDataAnalysis.ExcelCore ExcelConvert.ToIndex Examples

Example #1

File: ExcelCore.cs Project: omHsbc517/HSBC.Excel

        public void SetCellValue(string sheetName, int rowIndex, string columnName, string value)
        {
            dynamic xlsWorkSheet = wkb.Worksheets[sheetName];

            xlsWorkSheet.Cells[rowIndex, ExcelConvert.ToIndex(columnName) + 1] = value;
        }

Example #2

File: ExcelCore.cs Project: omHsbc517/HSBC.Excel

 public void SetCellValue(int rowIndex, string columnName, string value)
 {
     app.ActiveSheet.Cells[rowIndex, ExcelConvert.ToIndex(columnName) + 1] = value;
 }