且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在一个excel表格在Excel中开始添加一个新列

更新时间:2023-11-30 09:09:04

结帐出的 Range.Insert 方法,你可以在一个单元格区域称在他们面前插入整个行/列:

Checkout out the Range.Insert method which you can call on a range of cells to insert entire rows/columns in front of them:

Worksheet sheet = (Worksheet) workBookIn.Sheets[1]; // Worksheet indexes are one based

Range rng = sheet.get_Range("A1", Missing.Value);

rng.EntireColumn.Insert(XlInsertShiftDirection.xlShiftToRight,
                        XlInsertFormatOrigin.xlFormatFromRightOrBelow);