C# - EXPORT DATATABLE TO TEMPLATE EXCEL XLSX - USE EPPLUS

C# - EXPORT DATATABLE TO TEMPLATE EXCEL XLSX - USE EPPLUS

public string[] EXPORT_DATATABLE_TO_EXCEL_XLSX_TEMPLATE_USE_EPPLUS(DataTable DATA_TABLE, string SHEET_NAME, string FILE_EXCEL_XLSX_TEMPLATE, string FILE_EXCEL_XLSX_NEW, bool EXPORT_HEADER = true, int ROW_BEGIN = 1, int COLUMN_BEGIN = 1)
{
	/*  PLEASE NOTE FOR USE
		-------------------
		STEP 1 - DOWNLOAD EPPLUS FROM EPPLUS.CODEPLEX.COM
		STEP 2 - ADD REFERENCE EPPLUS.DLL TO VISUAL STUDIO
		STEP 3 - SET COPY LOCAL = TRUE
		-------------------

		EXAMPLE FOR USE
		---------------

		using System.Data;

		DataTable DATA_TABLE = new DataTable();
		DATA_TABLE.Columns.Add("ID", typeof(string));
		DATA_TABLE.Columns.Add("NAME", typeof(string));
		DATA_TABLE.Rows.Add("1", "A");
		DATA_TABLE.Rows.Add("2", "B");
		DATA_TABLE.Rows.Add("3", "C");
		DATA_TABLE.Rows.Add("4", "D");
		DATA_TABLE.Rows.Add("5", "E");
		DATA_TABLE.Rows.Add("6", "F");
		string FILE_EXCEL_XLSX_TEMPLATE = @"D:\FILE_EXCEL_XLSX_TEMPLATE.xlsx";
		string FILE_EXCEL_XLSX_NEW = @"D:\FILE_EXCEL_XLSX_NEW.xlsx";
		string[] STATUS = EXPORT_DATATABLE_TO_EXCEL_XLSX_TEMPLATE_USE_EPPLUS(DATA_TABLE, "SHEET1", FILE_EXCEL_XLSX_TEMPLATE, FILE_EXCEL_XLSX_NEW, true, 2, 3);
		if (STATUS[0] == "ERROR") { MessageBox.Show(STATUS[1], "ERROR"); }
		if (STATUS[0] == "OK") { System.Diagnostics.Process.Start(FILE_EXCEL_XLSX_NEW); }

		---------------
	*/

	string[] KQ = { "OK", "" };

	if (ROW_BEGIN <= 0 || COLUMN_BEGIN <= 0)
	{
		KQ[0] = "ERROR";
		KQ[1] = "REQUIRE ROW_BEGIN AND COLUMN_BEGIN GREATER THAN 0";
		return KQ;
	}
	if (SHEET_NAME.Trim() == "" || FILE_EXCEL_XLSX_TEMPLATE.Trim() == "" || FILE_EXCEL_XLSX_NEW.Trim() == "")
	{
		KQ[0] = "ERROR";
		KQ[1] = "REQUIRE SHEET_NAME, FILE_EXCEL_XLSX_TEMPLATE, FILE_EXCEL_XLSX_NEW NOT BLANK";
		return KQ;
	}

	try
	{
		System.IO.FileInfo FILE_XLSX_TEMPLATE = new System.IO.FileInfo(FILE_EXCEL_XLSX_TEMPLATE.Trim());
		System.IO.FileInfo FILE_XLSX_NEW = new System.IO.FileInfo(FILE_EXCEL_XLSX_NEW.Trim());
		using (OfficeOpenXml.ExcelPackage ExPCK = new OfficeOpenXml.ExcelPackage(FILE_XLSX_TEMPLATE))
		{
			OfficeOpenXml.ExcelWorksheet ExWS = ExPCK.Workbook.Worksheets[SHEET_NAME.Trim()];
			ExWS.Cells[ROW_BEGIN, COLUMN_BEGIN].LoadFromDataTable(DATA_TABLE, EXPORT_HEADER);
			ExPCK.SaveAs(FILE_XLSX_NEW);
		}
	}
	catch (Exception ex)
	{
		KQ[0] = "ERROR";
		KQ[1] = ex.ToString();
	}

	return KQ;
}