execl 里面 G1 后面自动增加，H1,I1,J1,K1,L1,M1,N1,O1

[u010072032]

                            for (int j = 0; j < dtOtherCompany.Rows.Count; j++)
                            {
                                //"A" + (startIndex + j)
                                Excel.Range rngCompanyName = xsheet.get_Range("G1", Missing.Value);
                                rngCompanyName.Value2 = dtOtherCompany.Rows[j]["companyName"].ToString();

                                Excel.Range rngProductCode = xsheet.get_Range("G2", Missing.Value);
                                rngProductCode.Value2 = this.GetValue(Convert.ToString(dtOtherCompany.Rows[j]["productCode"]));
                            }

Excel.Range rngCompanyName = xsheet.get_Range("G1", Missing.Value);

execl 里面 G1 后面自动增加，H1,I1,J1,K1,L1,M1,N1,O1 .... 一直加到for循环完为止，请问有高手会吗，

就是ABCDE一直往后加

[u010072032]

顶啊。。

[md5e]

for (int i = Char.ConvertToUtf32("G",0); i <= Char.ConvertToUtf32("Z",0); i++) { Response.Write(Char.ConvertFromUtf32(i)); }