java多线程excel上传_C# 文件上传下载(Excel导入,多线程下载)功能的实现代码

废话不多说了，直接给大家贴代码，具体代码如下所示：

//打开Excel文件，转换为DataTable

DataTable dtExcel;

private void OpenFile()

{

OpenFileDialog dialog = new OpenFileDialog();

dialog.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx"; //筛选打开文件类型 ：图片 *.jpg|*.jpg|*.bmp|*.bmp ;"音频文|*.mp3;*.wma;*.aac;*.midi;*.wav" 等等

if (dialog.ShowDialog() == DialogResult.OK)

{

dialogFileName = dialog.FileName;

dtExcel = ExcelToDataTable(dialogFileName, "sheet1", true);

}

}

///

/// Excel转Datatable

///

/// 文件名含后缀名

/// Excel文件，页名称

/// 是否将第一列作为表头

///

private DataTable ExcelToDataTable(string fileName, string sheetName, bool isFirstRowColumn)

{

IWorkbook workbook = null;

FileStream fs = null;

ISheet sheet = null;

DataTable data = new DataTable();

int startRow = 0;

try

{

fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);

if (fileName.IndexOf(".xlsx") > 0) // 2007版本

workbook = new XSSFWorkbook(fs);

else if (fileName.IndexOf(".xls") > 0) // 2003版本

workbook = new HSSFWorkbook(fs);

if (sheetName != null)

{

sheet = workbook.GetSheet(sheetName);

if (sheet == null) //如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheet

{

sheet = workbook.GetSheetAt(0);

}

}

else

{

sheet = workbook.GetSheetAt(0);

}

if (sheet != null)

{

IRow firstRow = sheet.GetRow(0);

int cellCount = firstRow.LastCellNum; //一行最后一个cell的编号 即总的列数

if (isFirstRowColumn)

{

for (int i = firstRow.FirstCellNum; i < cellCount; ++i)

{