public void EmptyDataSetCreateTest()
{
string tempFilePath = Path.GetTempFileName();
DataSet ds = new DataSet();
DataSetHelper.CreateWorkbook(tempFilePath, ds);
}
protected void butGenerateU_Click(object sender, EventArgs e)
{
if (dpFromU.SelectedDate.HasValue && dpToU.SelectedDate.HasValue)
{
DataSet ds = new DataSet("New_DataSet");
DataTable dt = new DataTable();
//dtp.TableName = "Оплата";
dt = ((DataView)dsUAbonent.Select(DataSourceSelectArguments.Empty)).ToTable();
dt.TableName = "Юрлица";
ds.Tables.Add(dt);
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=file.xls");
MemoryStream m = new MemoryStream();
DataSetHelper.CreateWorkbook(m, ds);
m.WriteTo(Response.OutputStream);
Response.End();
}
else
{
radWM.RadAlert("Необходимо заполнить дату", null, null, "Предупреждение", "");
}
}
public IDictionary <string, Stream> Export(IBinnerDb db)
{
var streams = new Dictionary <string, Stream>();
var builder = new DataSetBuilder();
var dataSet = builder.Build(db);
var stream = new MemoryStream();
using (var writer = new StreamWriter(stream, Encoding.UTF8, 4096, true))
{
DataSetHelper.CreateWorkbook(stream, dataSet);
}
streams.Add("BinnerParts", stream);
return(streams);
}
/// <summary>
/// Export multiple tests to an Excel sheet, each test gets its own worksheet and a summary of all tests is created
/// </summary>
public static void ExportTestDataToExcel(List <TestData> pTests)
{
DataSet dataSet = new DataSet("Test Results");
dataSet.Tables.Add(createTestSummarySheet(pTests));
foreach (TestData data in pTests)
{
DataTable dataTable = logTestInfoToSheet(data);
dataSet.Tables.Add(dataTable);
}
string fileName = "TestResults_" + DateTime.Now.ToString("dd-MM-yyyy-h-mm").ToString() + ".xls";
DataSetHelper.CreateWorkbook(fileName, dataSet);
}
public void SimpleCreateTest()
{
string tempFilePath = Path.GetTempFileName();
{
DataSet ds = new DataSet();
DataTable dt1 = new DataTable("Table 1");
dt1.Columns.Add("Column A", typeof(String));
dt1.Columns.Add("Column B", typeof(String));
dt1.Rows.Add("Test 1", "Test 2");
dt1.Rows.Add("Test 3", "Test 4");
ds.Tables.Add(dt1);
DataTable dt2 = new DataTable("Table 2");
ds.Tables.Add(dt2);
DataTable dt3 = new DataTable("Table 3");
dt3.Columns.Add("Column C", typeof(String));
ds.Tables.Add(dt3);
DataSetHelper.CreateWorkbook(tempFilePath, ds);
}
{
DataSet ds = DataSetHelper.CreateDataSet(tempFilePath);
Assert.AreEqual(3, ds.Tables.Count);
Assert.AreEqual("Table 1", ds.Tables[0].TableName);
Assert.AreEqual("Table 2", ds.Tables[1].TableName);
Assert.AreEqual("Table 3", ds.Tables[2].TableName);
Assert.AreEqual(2, ds.Tables[0].Columns.Count);
Assert.AreEqual(1, ds.Tables[1].Columns.Count);
Assert.AreEqual(1, ds.Tables[2].Columns.Count);
Assert.AreEqual("Column A", ds.Tables[0].Columns[0].ColumnName);
Assert.AreEqual("Column B", ds.Tables[0].Columns[1].ColumnName);
Assert.AreEqual("Column C", ds.Tables[2].Columns[0].ColumnName);
Assert.AreEqual(2, ds.Tables[0].Rows.Count);
Assert.AreEqual(0, ds.Tables[1].Rows.Count);
Assert.AreEqual(0, ds.Tables[2].Rows.Count);
Assert.AreEqual("Test 1", ds.Tables[0].Rows[0][0]);
Assert.AreEqual("Test 2", ds.Tables[0].Rows[0][1]);
Assert.AreEqual("Test 3", ds.Tables[0].Rows[1][0]);
Assert.AreEqual("Test 4", ds.Tables[0].Rows[1][1]);
}
}
public static Boolean XLS(DataSet dataSet, string nombreArchivo)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Planilla de Calculo (*.xls)|*.xls";
saveFileDialog.FileName = nombreArchivo;
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
DataSetHelper.CreateWorkbook(saveFileDialog.FileName, dataSet);
MessageBox.Show("Reporte exportado con exito" + Environment.NewLine + saveFileDialog.FileName);
System.Diagnostics.Process.Start(saveFileDialog.FileName);
return(true);
}
else
{
return(false);
}
}
protected void butGenerateF_Click(object sender, EventArgs e)
{
if (dpFrom.SelectedDate.HasValue && dpTo.SelectedDate.HasValue)
{
if (cbNotPay.Checked || cbPay.Checked)
{
DataSet ds = new DataSet("New_DataSet");
DataTable dtp = new DataTable();
//dtp.TableName = "Оплата";
DataTable dtnp = new DataTable();
//dtnp.TableName = "Без оплаты";
if (cbNotPay.Checked)
{
dtnp = ((DataView)dsNotPay.Select(DataSourceSelectArguments.Empty)).ToTable();
dtnp.TableName = "Без оплаты";
ds.Tables.Add(dtnp);
}
if (cbPay.Checked)
{
dtp = ((DataView)dsPay.Select(DataSourceSelectArguments.Empty)).ToTable();
dtp.TableName = "Оплата";
ds.Tables.Add(dtp);
}
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=file.xls");
MemoryStream m = new MemoryStream();
DataSetHelper.CreateWorkbook(m, ds);
m.WriteTo(Response.OutputStream);
Response.End();
}
else
{
radWM.RadAlert("Необходимо выбрать тип расчета", null, null, "Предупреждение", "");
}
}
else
{
radWM.RadAlert("Необходимо заполнить дату", null, null, "Предупреждение", "");
}
}
private void BtnExport_Click(object sender, EventArgs e)
{
try
{
using (var sd = new SaveFileDialog())
{
var ds = (DataSet)dgWorkbook.DataSource;
sd.FileName = ds.DataSetName;
sd.Filter = "Excel files|*.xls";
if (sd.ShowDialog() == DialogResult.OK)
{
ds.AcceptChanges();
DataSetHelper.CreateWorkbook(sd.FileName, ds);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
