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); } }