private void btnCSV_Click(object sender, EventArgs e) { try { MyExcelExport.GenericFormattedExcel2003Export gExp = new MyExcelExport.GenericFormattedExcel2003Export("CSV", dataGridView1, MyExcelExport.Theme.CSV, null, null, null); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { string mode = rCsv.Checked ? "CSV" : "XLS"; List <MyExcelExport.ColumnConditions> conds = new List <MyExcelExport.ColumnConditions>(); MyExcelExport.ColumnConditions curr = null; //no need to specify alignment //only if you wish/needed. It defaults to MyExcelExport.Align.None curr = new MyExcelExport.ColumnConditions(); curr.Column = 2; curr.Cond = MyExcelExport.Conditon.CurrencyEuro; conds.Add(curr); //specify Alignment curr = new MyExcelExport.ColumnConditions(); curr.Column = 3; curr.Cond = MyExcelExport.Conditon.Percentage; curr.Alignment = MyExcelExport.Align.Right; conds.Add(curr); List <MyExcelExport.ColumnRowConditon> rowConds = new List <MyExcelExport.ColumnRowConditon>(); MyExcelExport.ColumnRowConditon row = new MyExcelExport.ColumnRowConditon(); row.Column = 1; row.ConditionValue = "Total"; rowConds.Add(row); try { MyExcelExport.GenericFormattedExcel2003Export gExp = new MyExcelExport.GenericFormattedExcel2003Export(mode, dataGridView1, MyExcelExport.Theme.SweetPink, conds, rowConds, null); } catch (COMException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnBluCondition_Click(object sender, EventArgs e) { string mode = rCsv.Checked ? "CSV" : "XLS"; List <MyExcelExport.ColumnConditions> conds = new List <MyExcelExport.ColumnConditions>(); MyExcelExport.ColumnConditions curr = null; curr = new MyExcelExport.ColumnConditions(); curr.Column = 2; curr.Cond = MyExcelExport.Conditon.CurrencyEuro; conds.Add(curr); curr = new MyExcelExport.ColumnConditions(); curr.Column = 3; curr.Cond = MyExcelExport.Conditon.Percentage; conds.Add(curr); List <MyExcelExport.ColumnRowConditon> rowConds = new List <MyExcelExport.ColumnRowConditon>(); MyExcelExport.ColumnRowConditon row = new MyExcelExport.ColumnRowConditon(); row.Column = 1; row.ConditionValue = "Total"; rowConds.Add(row); try { MyExcelExport.GenericFormattedExcel2003Export gExp = new MyExcelExport.GenericFormattedExcel2003Export(mode, dataGridView1, MyExcelExport.Theme.ClassicGray, conds, rowConds, null); } catch (COMException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message); } }