using DevExpress.XtraEditors;
|
using NPOI.HSSF.UserModel;
|
using System;
|
using System.IO;
|
|
namespace IStation.WinFrmUI.Curve
|
{
|
public partial class ExportToXLS
|
{
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
public static bool Export(string filePath, Model.FeatCurveExpressGroup curveExpressGroup, int FitPointNumQH = 15)
|
{
|
if (curveExpressGroup == null)
|
return false;
|
|
return Export(filePath, curveExpressGroup.CurveQH, curveExpressGroup.CurveQE, curveExpressGroup.CurveQP, FitPointNumQH);
|
}
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
public static bool Export(string filePath, Model.CurveExpress CurveExpressQH, Model.CurveExpress CurveExpressQE, Model.CurveExpress CurveExpressQP, int FitPointNumQH = 15)
|
{
|
try
|
{
|
int i = 0;
|
|
#region 初始化表格
|
HSSFWorkbook theBook = InitializeBook(filePath);
|
if (theBook == null)
|
{
|
return false;
|
}
|
|
var theSheet1 = theBook.GetSheet("Sheet1");
|
if (theSheet1 == null)
|
return false;
|
#endregion
|
NPOI.SS.UserModel.IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("序号");//
|
rowTile.CreateCell(1).SetCellValue("流量");
|
rowTile.CreateCell(2).SetCellValue("扬程");
|
rowTile.CreateCell(3).SetCellValue("效率");
|
rowTile.CreateCell(4).SetCellValue("功率");
|
|
//均匀插值点,计算点坐标
|
double rQmin = CurveExpressQH.Min;
|
double rQmax = CurveExpressQH.Max;
|
double space = (rQmax - rQmin) / (FitPointNumQH - 1);
|
double Q = rQmin;
|
double H, E, P;
|
for (i = 0; i < FitPointNumQH; i++)
|
{
|
H = Model.FitCurveHelper.GetFitPointY(CurveExpressQH, Q);
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
var eta = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
|
|
int col = 0;
|
NPOI.SS.UserModel.IRow rowtemp = theSheet1.CreateRow(i + 1);
|
|
rowtemp.CreateCell(col).SetCellValue(i + 1);//序号
|
col++;
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(Q));
|
col++;
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(H));
|
col++;
|
|
if (CurveExpressQE != null
|
&& Q <= CurveExpressQE.Max
|
&& Q >= CurveExpressQE.Min)
|
{
|
if (Q < 0.1)
|
E = 0;
|
else
|
E = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(E));
|
col++;
|
}
|
|
|
if (CurveExpressQP != null
|
&& Q <= CurveExpressQP.Max
|
&& Q >= CurveExpressQP.Min)
|
{
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(P));
|
col++;
|
}
|
|
|
Q = Q + space;
|
if (Q > CurveExpressQH.Max * 0.9999)
|
Q = CurveExpressQH.Max * 0.9999;
|
}
|
|
//Force excel to recalculate all the formula while open
|
theSheet1.ForceFormulaRecalculation = true;
|
|
//打开一个xls文件，如果没有则自行创建，如果存在myxls.xls文件则在创建是不要打开该文件!
|
using (FileStream fs = File.OpenWrite(filePath))
|
{
|
theBook.Write(fs); //向打开的这个xls文件中写入mySheet表并保存。
|
|
}
|
}
|
catch (TimeoutException ex)
|
{
|
XtraMessageBox.Show("通讯超时，请重试", "Error:249 " + ex.Message);
|
return false;
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
return false;
|
}
|
return true;
|
}
|
|
|
/// 导出
|
/// </summary>
|
public static bool ExportEasyExcel(string filePath, Model.FeatCurveExpressGroup curveExpressGroup, int FitPointNumQH = 15)
|
{
|
if (curveExpressGroup == null)
|
return false;
|
|
return ExportEasyExcel(filePath, curveExpressGroup.CurveQH, curveExpressGroup.CurveQE, curveExpressGroup.CurveQP, FitPointNumQH);
|
}
|
|
|
/// 导出
|
/// </summary>
|
public static bool ExportEasyExcel(string filePath, Model.CurveExpress CurveExpressQH, Model.CurveExpress CurveExpressQE, Model.CurveExpress CurveExpressQP, int FitPointNumQH = 15)
|
{
|
try
|
{
|
int i = 0;
|
|
#region 初始化表格
|
HSSFWorkbook theBook = InitializeBook(filePath);
|
if (theBook == null)
|
{
|
return false;
|
}
|
|
var theSheet1 = theBook.GetSheet("Sheet1");
|
if (theSheet1 == null)
|
return false;
|
#endregion
|
NPOI.SS.UserModel.IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("流量");
|
rowTile.CreateCell(1).SetCellValue("扬程");
|
rowTile.CreateCell(2).SetCellValue("效率");
|
rowTile.CreateCell(3).SetCellValue("功率");
|
|
//均匀插值点,计算点坐标
|
double rQmin = CurveExpressQH.Min;
|
double rQmax = CurveExpressQH.Max;
|
double space = (rQmax - rQmin) / (FitPointNumQH - 1);
|
double Q = rQmin;
|
double H, E, P;
|
for (i = 0; i < FitPointNumQH; i++)
|
{
|
H = Model.FitCurveHelper.GetFitPointY(CurveExpressQH, Q);
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
var eta = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
|
|
int col = 0;
|
NPOI.SS.UserModel.IRow rowtemp = theSheet1.CreateRow(i + 1);
|
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(Q));
|
col++;
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(H));
|
col++;
|
|
if (CurveExpressQE != null
|
&& Q <= CurveExpressQE.Max
|
&& Q >= CurveExpressQE.Min)
|
{
|
if (Q < 0.1)
|
E = 0;
|
else
|
E = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(E));
|
col++;
|
}
|
|
if (Q <= CurveExpressQP.Max)
|
{
|
|
}
|
|
if (Q >= CurveExpressQP.Min)
|
{
|
|
}
|
|
|
if (CurveExpressQP != null
|
&& Q <= CurveExpressQP.Max
|
&& Q >= CurveExpressQP.Min)
|
{
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(P));
|
col++;
|
}
|
//if (P==0)
|
//{
|
// var a = 1;
|
//}
|
|
|
Q = Q + space;
|
if (Q > CurveExpressQH.Max * 0.9999)
|
Q = CurveExpressQH.Max * 0.9999;
|
}
|
|
//Force excel to recalculate all the formula while open
|
theSheet1.ForceFormulaRecalculation = true;
|
|
//打开一个xls文件，如果没有则自行创建，如果存在myxls.xls文件则在创建是不要打开该文件!
|
using (FileStream fs = File.OpenWrite(filePath))
|
{
|
theBook.Write(fs); //向打开的这个xls文件中写入mySheet表并保存。
|
|
}
|
}
|
catch (TimeoutException ex)
|
{
|
XtraMessageBox.Show("通讯超时，请重试", "Error:249 " + ex.Message);
|
return false;
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
return false;
|
}
|
return true;
|
}
|
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
public static bool ExportDefinePoints(string filePath, Model.FeatCurveExpressGroup curveExpressGroup, int FitPointNumQH = 15)
|
{
|
if (curveExpressGroup == null)
|
return false;
|
|
return ExportDefinePoints(filePath, curveExpressGroup.CurveQH, curveExpressGroup.CurveQE, curveExpressGroup.CurveQP, FitPointNumQH);
|
}
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
public static bool ExportDefinePoints(string filePath, Model.CurveExpress CurveExpressQH, Model.CurveExpress CurveExpressQE, Model.CurveExpress CurveExpressQP, int FitPointNumQH = 15)
|
{
|
try
|
{
|
int i = 0;
|
#region 初始化表格
|
HSSFWorkbook theBook = InitializeBook(filePath);
|
if (theBook == null)
|
{
|
return false;
|
}
|
|
var theSheet1 = theBook.GetSheet("Sheet1");
|
if (theSheet1 == null)
|
return false;
|
#endregion
|
NPOI.SS.UserModel.IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("流量");
|
rowTile.CreateCell(1).SetCellValue("扬程");
|
rowTile.CreateCell(2).SetCellValue("功率");
|
rowTile.CreateCell(3).SetCellValue("效率");
|
|
var qhPoints = CurveExpressQH.DefinePoints;
|
if (qhPoints == null || qhPoints.Count < 1)
|
{
|
qhPoints = CurveExpressQH.GetFitPoints(FitPointNumQH);
|
}
|
if (qhPoints == null || qhPoints.Count < 1)
|
return false;
|
var qePoints = CurveExpressQE.DefinePoints;
|
var qpPoints = CurveExpressQP.DefinePoints;
|
|
//均匀插值点,计算点坐标
|
double rQmin = CurveExpressQH.Min;
|
double rQmax = CurveExpressQH.Max;
|
double space = (rQmax - rQmin) / (FitPointNumQH - 1);
|
double Q = 0;
|
double H, E, P;
|
|
|
foreach (var qhPoint in qhPoints)
|
{
|
Q = qhPoint.X;
|
H = qhPoint.Y;
|
if (qpPoints != null && qpPoints.Count > 0)
|
{
|
var qp = qpPoints.Find(x => x.X == Q);
|
if (qp != null)
|
{
|
P = qp.Y;
|
}
|
else
|
{
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
}
|
}
|
else
|
{
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
}
|
|
if (qePoints != null && qePoints.Count > 0)
|
{
|
var qe = qePoints.Find(x => x.X == Q);
|
if (qe != null)
|
{
|
E = qe.Y;
|
}
|
else
|
{
|
E = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
}
|
}
|
else
|
{
|
E = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
}
|
|
int col = 0;
|
i = ++i;
|
NPOI.SS.UserModel.IRow rowtemp = theSheet1.CreateRow(i);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(Q));
|
col++;
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(H));
|
col++;
|
|
|
if (P == 0)
|
{
|
if (CurveExpressQP != null && Q <= CurveExpressQP.Max && Q >= CurveExpressQP.Min)
|
{
|
P = Model.FitCurveHelper.GetFitPointY(CurveExpressQP, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(P));
|
col++;
|
}
|
}
|
else
|
{
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(P));
|
col++;
|
}
|
|
if (E == 0)
|
{
|
if (CurveExpressQE != null && Q <= CurveExpressQE.Max && Q >= CurveExpressQE.Min)
|
{
|
if (Q < 0.1)
|
E = 0;
|
else
|
E = Model.FitCurveHelper.GetFitPointY(CurveExpressQE, Q);
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(E));
|
col++;
|
}
|
}
|
else
|
{
|
rowtemp.CreateCell(col).SetCellValue(MyTrans(E));
|
col++;
|
}
|
|
|
}
|
|
//Force excel to recalculate all the formula while open
|
theSheet1.ForceFormulaRecalculation = true;
|
|
//打开一个xls文件，如果没有则自行创建，如果存在myxls.xls文件则在创建是不要打开该文件!
|
using (FileStream fs = File.OpenWrite(filePath))
|
{
|
theBook.Write(fs); //向打开的这个xls文件中写入mySheet表并保存。
|
|
}
|
}
|
catch (TimeoutException ex)
|
{
|
XtraMessageBox.Show("通讯超时，请重试", "Error:249 " + ex.Message);
|
return false;
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
return false;
|
}
|
return true;
|
}
|
|
}
|
}
|
