Excel.Worksheet a = workbook.Worksheets[sheetName];
a.UsedRange.Clear();
b.UsedRange.Copy(a.Range[b.UsedRange.Address]);
若果直接格子会错位用上面的好使
b.UsedRange.Copy(a.UsedRange]);
Excel.Worksheet a = workbook.Worksheets[sheetName];
a.UsedRange.Clear();
b.UsedRange.Copy(a.Range[b.UsedRange.Address]);
若果直接格子会错位用上面的好使
b.UsedRange.Copy(a.UsedRange]);