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);
}
