public void UpdateWriteExcelFileLog(string filename, ref List <int[]> list_error) { if (!File.Exists(filename)) { return; } FileLog.WriteLog("进入UpdateWriteExcelFile..."); NIPOIReadExcel niponstrem = new NIPOIReadExcel(filename); niponstrem.UpdateWriteExcelFileLog(ref list_error); }
public void UpdateWriteExcelFileGP(string filename, string sheetname, ref List <int[]> redError, ref List <int[]> yellowError, ref List <int[]> blueError) { if (!File.Exists(filename)) { return; } FileLog.WriteLog("进入UpdateWriteExcelFile..."); NIPOIReadExcel niponstrem = new NIPOIReadExcel(filename); niponstrem.UpdateWriteExcelFileGP(sheetname, ref redError, ref yellowError, ref blueError); }
public void UpdateWriteExcelFile(string filename, string sheetname, ref List <Object[]> newData) { if (!File.Exists(filename)) { return; } FileLog.WriteLog("进入UpdateWriteExcelFile..."); NIPOIReadExcel niponstrem = new NIPOIReadExcel(filename); niponstrem.UpdateWriteExcelFile(sheetname, ref newData); }
public DataTable GetDataTableToExcelByHeard(string filename, int sheetindex, int[] rowColumnNum, string headName, Stream StremContent) { DataTable tables = null; if (StremContent == null) { StremContent = new FileInfo(filename).OpenRead(); } NIPOIReadExcel niponstrem = new NIPOIReadExcel(filename); if (filename.IndexOf(".xls") > 0) //2003 Excel { tables = niponstrem.GetExcelToTable03(StremContent, sheetindex, rowColumnNum, headName); } return(tables); }
/// <summary> /// 按SheetNames读取Excel并转换成Set /// </summary> /// <param name="fileName"></param> /// <param name="sheetNames"></param> /// <param name="StremContent"></param> /// <returns></returns> public DataSet GetDataSetToExcelByNames(string filename, string[] sheetnames, Stream StremContent) { DataSet dataset = null; if (StremContent == null) { StremContent = new FileInfo(filename).OpenRead(); } NIPOIReadExcel niponstrem = new NIPOIReadExcel(filename); if (filename.IndexOf(".xlsx") > 0) //2007 Excel { dataset = niponstrem.GetExcelToSet07(StremContent, sheetnames); } return(dataset); }
private DataTable GetDataTableToExcel(string fileName, string sheetName, int sheetIndex, Stream StremContent) { DataTable tables = null; if (StremContent == null) { StremContent = new FileInfo(fileName).OpenRead(); } //Stream StremContent = new FileInfo(fileName).OpenRead(); NIPOIReadExcel niponstrem = new NIPOIReadExcel(fileName); if (fileName.IndexOf(".xlsx") > 0) //2007 Excel { tables = niponstrem.GetExcelToTable07(StremContent, sheetName, sheetIndex); } else if (fileName.IndexOf(".xls") > 0) //2003 Excel { tables = niponstrem.GetExcelToTable03(StremContent, sheetName, sheetIndex); } return(tables); }