110,534
社区成员
发帖
与我相关
我的任务
分享
public void CreateExcel(string fileName)
{
object missing = System.Type.Missing;
Application App = new Application();
Workbooks books = App.Workbooks;
Workbook book = books.Add(true);
Sheets sheets = book.Sheets;
Worksheet ws = excel.GetWorksheetByName("Sheet1"); //A处
Worksheet worksheet = (Worksheet)sheets[1];
Range Range = ws.get_Range("A1", "A4");
Array list = (Array)Range.Cells.Value2;
for (int i = 1; i <= list.GetLength(0); i++) //B处
{ //B处
worksheet.Cells[i, 1] = list.GetValue(i, 1).ToString(); //B处
} //B处
book.SaveAs(fileName, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
book.Close(false, missing, missing);
App.Quit();
App = null;
excel.Close();
}