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");

 

转载于:https://www.cnblogs.com/jrzlldsj/archive/2012/09/25/2660703.html