把对应的隐藏列显示出来,获取值,根据需要在隐藏对应的列:
//隐藏列
sheet.Range[string.Format("{0}1:{1}1", “A”,"AZ")].EntireColumn.Hidden = false;
var range=sheet.Range[string.Format("{0}1","A")];
var text=range.Text.Trim();
把对应的隐藏列显示出来,获取值,根据需要在隐藏对应的列:
//隐藏列
sheet.Range[string.Format("{0}1:{1}1", “A”,"AZ")].EntireColumn.Hidden = false;
var range=sheet.Range[string.Format("{0}1","A")];
var text=range.Text.Trim();