最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
C# 文件上传下载(Excel导入,多线程下载)功能的实现代码
时间:2022-06-25 07:47:57 编辑:袖梨 来源:一聚教程网
//打开Excel文件,转换为DataTable DataTable dtExcel; privatevoidOpenFile() { OpenFileDialog dialog =newOpenFileDialog(); 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文件,页名称 /// 是否将第一列作为表头 ///privateDataTable ExcelToDataTable(stringfileName,stringsheetName,boolisFirstRowColumn) { IWorkbook workbook =null; FileStream fs =null; ISheet sheet =null; DataTable data =newDataTable(); intstartRow = 0; try { fs =newFileStream(fileName, FileMode.Open, FileAccess.Read); if(fileName.IndexOf(".xlsx") > 0)// 2007版本 workbook =newXSSFWorkbook(fs); elseif(fileName.IndexOf(".xls") > 0)// 2003版本 workbook =newHSSFWorkbook(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); intcellCount = firstRow.LastCellNum;//一行最后一个cell的编号 即总的列数 if(isFirstRowColumn) { for(inti = firstRow.FirstCellNum; i < cellCount; ++i) { ICell cell = firstRow.GetCell(i); if(cell !=null) { stringcellValue = cell.StringCellValue; if(cellValue !=null) { DataColumn column =newDataColumn(cellValue); data.Columns.Add(column); } } } startRow = sheet.FirstRowNum + 1; } else { startRow = sheet.FirstRowNum; } //最后一列的标号 introwCount = sheet.LastRowNum; for(inti = startRow; i <= rowCount; ++i) { IRow row = sheet.GetRow(i); if(row ==null)continue;//没有数据的行默认是null DataRow dataRow = data.NewRow(); for(intj = row.FirstCellNum; j < cellCount; ++j) { if(row.GetCell(j) !=null)//同理,没有数据的单元格都默认是null dataRow[j] = row.GetCell(j).ToString(); } data.Rows.Add(dataRow); } } returndata; } catch(Exception ex) { MyMessageBox.Show(ex.Message); returnnull; } }
文件下载:
privatevoidDownLoad() { if(impdefineBM !=null) { FolderBrowserDialog path =newFolderBrowserDialog(); path.ShowDialog(); if(path !=null&& path.SelectedPath !="") { stringurl =@"http://192.168.1.1/XX.xls"; //下载地址 stringname ="FileName"; // 文件名称 stringsavefilepath = path.SelectedPath +""+ name + url.Substring(url.LastIndexOf("."));//注意:下载文件名的命名 ,可根据实际需求调整调用的文件创建方式 MultiDownload download =newMultiDownload(5, url, savefilepath);//调用多线程下载 download.Start(); } } } #region 多线程下载 publicclassMultiDownload { #region 变量 privateint_threadNum; //线程数量 privatelong_fileSize; //文件大小 privatestring_fileUrl; //文件地址 privatestring_fileName; //文件名 privatestring_savePath; //保存路径 privateshort_threadCompleteNum;//线程完成数量 privatebool_isComplete; //是否完成 privatevolatileint_downloadSize;//当前下载大小(实时的) privateThread[] _thread; //线程数组 privateList_tempFiles =newList (); privateobjectlocker =newobject(); #endregion #region 属性 /// /// 文件名 /// publicstringFileName { get { return_fileName; } set { _fileName = value; } } ////// 文件大小 /// publiclongFileSize { get { return_fileSize; } } ////// 当前下载大小(实时的) /// publicintDownloadSize { get { return_downloadSize; } } ////// 是否完成 /// publicboolIsComplete { get { return_isComplete; } } ////// 线程数量 /// publicintThreadNum { get { return_threadNum; } } ////// 保存路径 /// publicstringSavePath { get { return_savePath; } set { _savePath = value; } } #endregion ////// 构造函数 /// /// 线程数量 /// 文件Url路径 /// 本地保存路径 publicMultiDownload(intthreahNum,stringfileUrl,stringsavePath) { this._threadNum = threahNum; this._thread =newThread[threahNum]; this._fileUrl = fileUrl; this._savePath = savePath; } publicvoidStart() { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(_fileUrl); HttpWebResponse response = (HttpWebResponse)request.GetResponse(); _fileSize = response.ContentLength; intsingelNum = (int)(_fileSize / _threadNum); //平均分配 intremainder = (int)(_fileSize % _threadNum); //获取剩余的 request.Abort(); response.Close(); for(inti = 0; i < _threadNum; i++) { Listrange =newList (); range.Add(i * singelNum); if(remainder != 0 && (_threadNum - 1) == i)//剩余的交给最后一个线程 range.Add(i * singelNum + singelNum + remainder - 1); else range.Add(i * singelNum + singelNum - 1); //下载指定位置的数据 int[] ran =newint[] { range[0], range[1] }; _thread[i] =newThread(newParameterizedThreadStart(Download)); _thread[i].Name = System.IO.Path.GetFileNameWithoutExtension(_fileUrl) +"_{0}".Replace("{0}", Convert.ToString(i + 1)); _thread[i].Start(ran); } //MessageBox.Show("下载完成!"); } privatevoidDownload(objectobj) { Stream httpFileStream =null, localFileStram =null; try { int[] ran = objasint[]; stringtmpFileBlock = System.IO.Path.GetTempPath() + Thread.CurrentThread.Name +".tmp"; _tempFiles.Add(tmpFileBlock); HttpWebRequest httprequest = (HttpWebRequest)WebRequest.Create(_fileUrl); httprequest.AddRange(ran[0], ran[1]); HttpWebResponse httpresponse = (HttpWebResponse)httprequest.GetResponse(); httpFileStream = httpresponse.GetResponseStream(); localFileStram =newFileStream(tmpFileBlock, FileMode.Create); byte[] by =newbyte[5000]; intgetByteSize = httpFileStream.Read(by, 0, (int)by.Length);//Read方法将返回读入by变量中的总字节数 while(getByteSize > 0) { Thread.Sleep(20); lock(locker) _downloadSize += getByteSize; localFileStram.Write(by, 0, getByteSize); getByteSize = httpFileStream.Read(by, 0, (int)by.Length); } lock(locker) _threadCompleteNum++; } catch(Exception ex) { thrownewException(ex.Message.ToString()); } finally { if(httpFileStream !=null) httpFileStream.Dispose(); if(localFileStram !=null) localFileStram.Dispose(); } if(_threadCompleteNum == _threadNum) { Complete(); _isComplete =true; } } /// /// 下载完成后合并文件块 /// privatevoidComplete() { Stream mergeFile =null; BinaryWriter AddWriter =null; try { using(mergeFile =newFileStream(@_savePath, FileMode.Create))//根据实际情况调整FileMode { AddWriter =newBinaryWriter(mergeFile); foreach(stringfilein_tempFiles) { using(FileStream fs =newFileStream(file, FileMode.Open)) { BinaryReader TempReader =newBinaryReader(fs); AddWriter.Write(TempReader.ReadBytes((int)fs.Length)); TempReader.Close(); } File.Delete(file); } } MyMessageBox.Show("下载完成!"); } catch(Exception ex) { thrownewException(ex.Message); } finally { if(AddWriter !=null) { AddWriter.Close(); AddWriter.Dispose(); } if(mergeFile !=null) { mergeFile.Close(); mergeFile.Dispose(); } } } }
相关文章
- 蚂蚁新村小课堂今日答案12月12日 追得百花鲜迎来生活甜形容的是以下哪种职业的特点 12-23
- 蚂蚁庄园今日答案最新2024.12.13 12-23
- 无限暖暖奇迹之冠第二期巅峰赛怎么玩 12-23
- 光遇12.23每日任务怎么做 12-23
- 王者荣耀QQ飞车联动怎么样 12-23
- 原神5.3版本游迹怎么样 原神5.3版本绘想游迹新增活动介绍 12-23