循环取出单元格中的内容,类似这样:
Range r1 = sh.get_Range("A2", Missing.Value);
string s= System.convert.tostring(r1.Value2);
后面的处理可用如下代码:
string s = "FW-a001-FW-1";
Regex r = new Regex(@"FW");
MatchCollection mc = r.Matches(s);
if (mc.Count == 2)
{
s=s.Substring(0,s.LastIndexOf("FW"));
}
Console.WriteLine(s);