亚洲日本欧洲欧美视频,日韩中文字幕有码av,一本一道av中文字幕无码,国产线播放免费人成视频播放,人妻少妇偷人无码视频,日夜啪啪一区二区三区,国产尤物精品自在拍视频首页,久热这里只有精品12

c# 操作 excel 導入

Code

public void ExpExcel(string fileName, DataTable dataTable)

{

Excel.ApplicationClass apc = new Excel.ApplicationClass();

apc.Visible = false;

Excel.Workbook wkbook = apc.Workbooks.Add(true);

Excel.Worksheet wksheet = (Excel.Worksheet)wkbook.ActiveSheet;

int rowIndex = 2;

int colIndex = 1;

//設置第一行為文本

wksheet.get_Range(apc.Cells[1, 1], apc.Cells[dataTable.Rows.Count, dataTable.Columns.Count]).NumberFormatLocal = "@";

//取得列標題

foreach (DataColumn dc in dataTable.Columns)

{

wksheet.Cells[1, colIndex] = dc.ColumnName;

colIndex++;

}

colIndex = 1;

int rowCount = dataTable.Rows.Count;

int colCount = dataTable.Columns.Count;

//建立二維數組　將數據填充

object[,] dataArray = new object[rowCount, colCount];

for (int i = 0; i < rowCount; i++)

{

for (int j = 0; j < colCount; j++)

{

dataArray[i, j] = dataTable.Rows[i][j];

}

//將二維數組的值賦給excel wksheet.Cells[rowIndex, colIndex] 起開始單元格 wksheet.Cells[rowCount + rowIndex-1, colCount + colIndex-1] 結束單元格

* 假如開始單元格 wksheet.Cells[x, y] 結束單元格 wksheet.Cells[i,j] i-x 數據的行數 j-y 數據的列數

wksheet.get_Range(wksheet.Cells[rowIndex, colIndex], wksheet.Cells[rowCount + rowIndex-1, colCount + colIndex-1]).Value2 = dataArray;

//設置表格樣式表頭樣式

wksheet.get_Range(apc.Cells[1, 1], apc.Cells[1, dataTable.Columns.Count]).Interior.ColorIndex = 20;

wksheet.get_Range(apc.Cells[1, 1], apc.Cells[1, dataTable.Columns.Count]).Font.ColorIndex = 3;

wksheet.get_Range(apc.Cells[1, 1], apc.Cells[1, dataTable.Columns.Count]).Borders.Weight = Excel.XlBorderWeight.xlThin;

wksheet.get_Range(apc.Cells[1, 1], apc.Cells[dataTable.Rows.Count, dataTable.Columns.Count]).Columns.AutoFit();

if (File.Exists(fileName))

{

File.Delete(fileName);

}

wkbook.SaveAs(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

wkbook.Close(Type.Missing, Type.Missing, Type.Missing);

apc.Quit();

wkbook = null;

apc = null;

GC.Collect();

}

posted @ 2008-08-02 15:45 嘯翱姜糊閱讀(256) 評論(0) 收藏舉報

刷新頁面返回頂部

嘯翱姜糊

堅持就會成功!

c# 操作 excel 導入

公告