public CExcelStreamWriter(string strEntireFileName, bool blnAppend = false, int intWorkSheets = 1)
{
if (strEntireFileName == null || strEntireFileName == "")
{
strEntireFileName = CHelpFuncExcel.OpenAnExcel();
}
this.sw = new StreamWriter(strEntireFileName + ".xls", blnAppend, Encoding.GetEncoding(-0)); //it's better if we can output a file with ".xlsx", but that causes problems
}
public CExcelOperator(string strEntireFileName)
{
this.strEntireFileName = strEntireFileName;
if (strEntireFileName == null || strEntireFileName == "")
{
this.strEntireFileName = CHelpFuncExcel.OpenAnExcel();
}
this.pExcelAPP = new Excel.Application();
pExcelAPP.Visible = false;
}