public ActionResult ExportExcel()
{
string b = Request["me"].ToString();
RKLib.ExportData.Export obj = new RKLib.ExportData.Export("Web");
System.Net.WebClient client = new System.Net.WebClient();
//client.Encoding = System.Text.Encoding.UTF8;
var doc = new HtmlAgilityPack.HtmlDocument();
//string str = this.TextBox1.Text;
//string b = HiddenField1.Value;
doc.LoadHtml(b);
//doc.LoadHtml(b);
var nodesT = doc.DocumentNode.SelectNodes("//table/tr");
var table = new System.Data.DataTable("MyTable");
var headers = nodesT[0]
.Elements("th")
.Select(th => th.InnerText.Trim());
foreach (var header in headers)
{
table.Columns.Add(header);
}
var rows = nodesT.Skip(1).Select(tr => tr
.Elements("td")
.Select(td => td.InnerText.Trim())
.ToArray());
foreach (var row in rows)
{
table.Rows.Add(row);
}
Response.ContentEncoding = System.Text.Encoding.Unicode;
Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
obj.ExportDetails(table, RKLib.ExportData.Export.ExportFormat.Excel, "Mahsa");
return(RedirectToAction("View"));
}
private void btnExport1_Click(object sender, System.EventArgs e)
{
// Export all the details
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet)Session["dsEmployee"]).Tables["Employee"].Copy();
// Export all the details to CSV
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, Export.ExportFormat.CSV, "EmployeesInfo1");
}
catch (Exception Ex)
{
lblError.Text = Ex.Message;
}
}
private void btnExportExcel_Click(object sender, System.EventArgs e)
{
lblMessage.Text = "";
DataTable dt = ds.Tables["Table1"].Copy();
try
{
string file = textBoxFolder.Text + "table1.xls";
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
objExport.ExportDetails(dt, Export.ExportFormat.Excel, file);
lblMessage.Text = "Successfully exported to " + file;
}
catch (Exception Ex)
{
lblMessage.Text = Ex.Message;
}
}
private void btnExport1_Click(object sender, System.EventArgs e)
{
// Export all the details
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet) Session["dsEmployee"]).Tables["Employee"].Copy();
// Export all the details to CSV
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, Export.ExportFormat.CSV, "EmployeesInfo1");
}
catch(Exception Ex)
{
lblError.Text = Ex.Message;
}
}
private void btnExport2_Click(object sender, System.EventArgs e)
{
// Export the details of specified columns
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet)Session["dsEmployee"]).Tables["Employee"].Copy();
// Specify the column list to export
int[] iColumns = { 1, 2, 3, 5, 6 };
// Export the details of specified columns to Excel
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, iColumns, Export.ExportFormat.Excel, "EmployeesInfo2");
}
catch (Exception Ex)
{
lblError.Text = Ex.Message;
}
}
public static string ExportCsv(DataTable table)
{
if (table == null)
{
return("");
}
if (table.TableName == "")
{
table.TableName = "ExportedData";
}
string fileName = table.TableName.Replace(" ", "") + ".csv";
RKLib.ExportData.Export x = new RKLib.ExportData.Export("Win");
x.ExportDetails(table, RKLib.ExportData.Export.ExportFormat.CSV, fileName);
return(Ap.FolderAppBin + fileName);
}
private void btnExport2_Click(object sender, System.EventArgs e)
{
// Export the details of specified columns
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet) Session["dsEmployee"]).Tables["Employee"].Copy();
// Specify the column list to export
int[] iColumns = {1,2,3,5,6};
// Export the details of specified columns to Excel
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, iColumns, Export.ExportFormat.Excel, "EmployeesInfo2");
}
catch(Exception Ex)
{
lblError.Text = Ex.Message;
}
}
private void btnExport3_Click(object sender, System.EventArgs e)
{
// Export the details of specified columns with specified headers
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet)Session["dsEmployee"]).Tables["Employee"].Copy();
// Specify the column list and headers to export
int[] iColumns = { 1, 2, 3, 5, 6 };
string[] sHeaders = { "LastName", "FirstName", "DOB", "Address", "ZipCode" };
// Export the details of specified columns with specified headers to CSV
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, iColumns, sHeaders, Export.ExportFormat.CSV, "EmployeesInfo3");
}
catch (Exception Ex)
{
lblError.Text = Ex.Message;
}
}
private void btnExportCSV_Click(object sender, System.EventArgs e)
{
lblMessage.Text = "";
DataTable dt = ds.Tables["Table1"].Copy();
int nCol = ds.Tables["Table1"].Columns.Count;
int[] iColumns = new int[nCol];
for (int i = 1; i < nCol; i++)
{
iColumns[i] = i;
}
try
{
string file = textBoxFolder.Text + "table1.csv";
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
objExport.ExportDetails(dt, iColumns, Export.ExportFormat.CSV, file);
lblMessage.Text = "Successfully exported to " + file;
}
catch (Exception Ex)
{
lblMessage.Text = Ex.Message;
}
}
private void btnExportExcel_Click(object sender, System.EventArgs e)
{
lblMessage.Text = "";
// Export all the details
try
{
// Get the datatable to export
DataTable dtEmployee = dsEmployee.Tables["Employee"].Copy();
// Export all the details to Excel
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
objExport.ExportDetails(dtEmployee, Export.ExportFormat.Excel, "C:\\EmployeesInfo.xls");
lblMessage.Text = "Successfully exported to C:\\EmployeesInfo.xls";
}
catch(Exception Ex)
{
lblMessage.Text = Ex.Message;
}
}
private void btnExportCSV_Click(object sender, System.EventArgs e)
{
// Export all the details
try
{
lblMessage.Text = "";
// Get the datatable to export
DataTable dtEmployee = dsEmployee.Tables["Employee"].Copy();
// Specify the column list to export
int[] iColumns = {1,2,3,5,6};
// Export the details of specified columns to CSV
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
objExport.ExportDetails(dtEmployee, iColumns, Export.ExportFormat.CSV, "C:\\EmployeesInfo.csv");
lblMessage.Text = "Successfully exported to C:\\EmployeesInfo.csv";
}
catch(Exception Ex)
{
lblMessage.Text = Ex.Message;
}
}
public static string ExportCsv(DataTable table)
{
if (table == null)
{
return "";
}
if (table.TableName == "")
{
table.TableName = "ExportedData";
}
string fileName = table.TableName.Replace(" ", "") + ".csv";
RKLib.ExportData.Export x = new RKLib.ExportData.Export("Win");
x.ExportDetails(table, RKLib.ExportData.Export.ExportFormat.CSV, fileName);
return Config.FolderAppBin + fileName;
}
private void DoExport(Boolean bToCSV)
{
ClassReport oRep = new ClassReport();
DataSet oDs = GetGridData();
Boolean bOkay = false;
this.RowError1.Visible = false;
this.RowError2.Visible = false;
if (oDs != null)
{
if (oDs.Tables.Count > 0)
{
if (oDs.Tables[0].Rows.Count > 0)
{
bOkay = true;
}
}
}
if (bOkay == true)
{
RKLib.ExportData.Export oExp = new RKLib.ExportData.Export("Web");
Int32[] Columns = { 0, 1, 2 };
if (bToCSV == true)
{
// Export to CSV file.
oExp.ExportDetails(oDs.Tables[0], Columns, RKLib.ExportData.Export.ExportFormat.CSV, "Report.csv");
}
else
{
// Export to Microsoft Excel.
oExp.ExportDetails(oDs.Tables[0], Columns, RKLib.ExportData.Export.ExportFormat.Excel, "Report.xls");
}
}
else
{
this.RowError1.Visible = true;
this.RowError2.Visible = true;
this.LblMsg.Text = "No Data Found!";
}
}
private void btnExport3_Click(object sender, System.EventArgs e)
{
// Export the details of specified columns with specified headers
try
{
// Get the datatable to export
DataTable dtEmployee = ((DataSet) Session["dsEmployee"]).Tables["Employee"].Copy();
// Specify the column list and headers to export
int[] iColumns = {1,2,3,5,6};
string[] sHeaders = {"LastName", "FirstName", "DOB", "Address", "ZipCode"};
// Export the details of specified columns with specified headers to CSV
RKLib.ExportData.Export objExport = new RKLib.ExportData.Export();
objExport.ExportDetails(dtEmployee, iColumns, sHeaders, Export.ExportFormat.CSV, "EmployeesInfo3");
}
catch(Exception Ex)
{
lblError.Text = Ex.Message;
}
}
