aaaaaaaaaaaaaa
System.ArgumentException: Specified value has invalid Control characters.
worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]).NumberFormat = "[DBNum1][$-804]G/通用格式";设置了单元格格式为小写中文。1~9没问题
Excel.Range ran1 = worksheet.Columns.get_Range("H:H", Type.Missing);//或者.get_Range("D1", "D1").get_Resize(50,1);//获取一整列D,行数为50
Range range1=worksheet.get_Range("A4","M35");
System.Array value=(System.Array)range1.formula;
//获取A1 到AM24范围的单元格
Excel.Range rang = sheet.get_Range("A1", "AM24");