private void toolStripButton1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
foreach (DataGridViewColumn col in DGV.Columns)
{
dt.Columns.Add(col.HeaderText);
}
foreach (DataGridViewRow row in DGV.Rows)
{
DataRow dRow = dt.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
dRow[cell.ColumnIndex] = cell.Value;
}
dt.Rows.Add(dRow);
}
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.AddExtension = true;
saveFileDialog1.DefaultExt = "xlsx";
saveFileDialog1.Filter = "*.xlsx|*.*";
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
obj.WriteDataTableToExcel(dt, "Excel Report", saveFileDialog1.FileName, "Details");
}
}
public void ExportToExcel()
{
var chartTitle = currentChartDto.ChartTitle;
var obj = new Excel.ExcelUtlity();
var labels = currentChartDto.Labels;
var values = currentChartDto.Values;
var list = new List <ExportClass>();
foreach (var seriesHandler in values)
{
var it = 0;
var seriesHandlerCounts = seriesHandler.Counts;
var seriesHandlerDoubleCounts = seriesHandler.DoubleCounts;
if (seriesHandlerCounts != null)
{
foreach (var seriesHandlerCount in seriesHandlerCounts)
{
list.Add(new ExportClass
{
Serie = seriesHandler.SerieTitle,
Item = labels.ElementAt(it),
Nombre = seriesHandlerCount
});
it++;
}
}
else if (seriesHandlerDoubleCounts != null)
{
foreach (var seriesHandlerDoubleCount in seriesHandlerDoubleCounts)
{
list.Add(new ExportClass
{
Serie = seriesHandler.SerieTitle,
Item = labels.ElementAt(it),
Nombre = seriesHandlerDoubleCount
});
it++;
}
}
}
var dt = ConvertToDataTable(list);
var myDocumentPath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
obj.WriteDataTableToExcel(dt, "MOTS", $"{myDocumentPath}\\MOTS_Export.xlsx", chartTitle);
}
private void GenerateExcelMOBySysID(string sysid)
{
try
{
npgsqlConnection = new NpgsqlConnection(CONNECTION_STRING);
npgsqlConnection.Open();
DataTable dataTable = new DataTable();
string requete = requeteSmsMO.Replace("%WEEK%", _week.ToString()).Replace("%YEAR%", _year.ToString());
requete = requete.Replace("%id_sms_mo%", idSmsMoMin).Replace("%SYSID%", sysid);
dataTable.Columns.Add("sysid", typeof(String));
dataTable.Columns.Add("id_sms_mo", typeof(String));
dataTable.Columns.Add("sms", typeof(String));
dataTable.Columns.Add("msisdn", typeof(String));
dataTable.Columns.Add("shortcode", typeof(String));
dataTable.Columns.Add("codser", typeof(String));
dataTable.Columns.Add("status", typeof(String));
dataTable.Columns.Add("entry_date", typeof(String));
dataTable.Columns.Add("login", typeof(String));
NpgsqlCommand npgsqlCommand = new NpgsqlCommand(requete, npgsqlConnection);
NpgsqlDataReader dr = npgsqlCommand.ExecuteReader();
while (dr.Read())
{
dataTable.Rows.Add(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(), dr[4].ToString(), dr[5].ToString(), GetStatutMO(dr[6].ToString()), dr[7].ToString(), dr[8].ToString());
}
dr.Close();
npgsqlConnection.Close();
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
string title = "STAT SYSID " + sysid + " -Y" + _year.ToString() + " - W" + _week.ToString();
string fileName = "Content_MO_Y" + _year.ToString() + "_W" + GetWeek(_week) + "_S-" + sysid + ".xlsx";
obj.WriteDataTableToExcel(dataTable, title, PARAM_PATH_EXCEL + fileName, "");
}
catch (Exception ex)
{
throw ex;
}
}
private void iconButtonUpdateData_Click(object sender, EventArgs e)
{
var folderBrowserDialog1 = new FolderBrowserDialog();
// Show the FolderBrowserDialog.
DialogResult result = folderBrowserDialog1.ShowDialog();
if (result == DialogResult.OK)
{
labelTime.Visible = true;
string command = "select * from " + "historysearch order by id DESC";
Database.load(command);
DataView view = new DataView(Database.loadData);
DataTable selected = view.ToTable(false, "Word", "Meaning", "TimeSearch", "Bookmark", "Translate");
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
string folderName = folderBrowserDialog1.SelectedPath;
obj.WriteDataTableToExcel(selected, "Saved Translated Data", folderName + "TranslatedList.xlsx", "TranslatedList");
MessageBox.Show("Folder was created");
}
}
private void btnExpSocios_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.InitialDirectory = "c:\\";
sfd.Filter = "Archivos de excel (*.xlsx)|*.xlsx";
sfd.FilterIndex = 1;
sfd.RestoreDirectory = true;
if (sfd.ShowDialog() == DialogResult.OK)
{
try
{
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
obj.WriteDataTableToExcel((DataTable)dgvListaSocios.DataSource, "Socios", sfd.FileName, "Socios");
MessageBox.Show(this, "Archivo de excel creado en la ubicación [" + sfd.FileName + "]", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(this, "Error del Sistema: " + ex.Message, "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
foreach (DataGridViewColumn col in DGV.Columns)
{
dt.Columns.Add(col.HeaderText);
}
foreach (DataGridViewRow row in DGV.Rows)
{
DataRow dRow = dt.NewRow();
foreach (DataGridViewCell cell in row.Cells)
{
var s = cell.Value;
if (s == null)
{
goto Finish;
}
if (Regex.IsMatch(s.ToString(), @"[=]") && s !=null )
{
string[] operands = Regex.Split(s.ToString(), @"\D+");
string[] operands2 = Regex.Split(s.ToString(), @"\d+");
string ar = "";
foreach (string value in operands)
{
//
// Parse the value to get the number.
//
int number1;
if (int.TryParse(value, out number1))
{
int er = Convert.ToInt32(value) + 1;
// MessageBox.Show(er.ToString());
ar += Convert.ToString(er)+",";
}
}
string[] operan3 = Regex.Split(ar, @"\D+");
string[] arr = new string[operan3.Length];
string ar2 = "";
for (int i = 0, j = 0; i < operan3.Length; i++, j++)
{
// arr[i] = operands2[i] + operan3[j];
ar2 += Convert.ToString(operands2[i] + operan3[j]);
}
s = ar2;
}
Finish :
dRow[cell.ColumnIndex] = s;
}
dt.Rows.Add(dRow);
}
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.AddExtension = true;
saveFileDialog1.DefaultExt = "xls";
saveFileDialog1.Filter = "*.xls|*.*";
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
obj.WriteDataTableToExcel(dt, "Excel Report", saveFileDialog1.FileName, "Details");
}
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
try {
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.AddExtension = true;
saveFileDialog1.DefaultExt = "xlsx";
saveFileDialog1.Filter = "*.xlsx|*.*";
if(saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
// DataTable dt = new DataTable("ExcelTable");
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
DataView dv = new DataView(Global.Instance.OrdetTable);
dv.RowFilter = "status = 'Traded'";
dv.ToTable("ExcelTable");
DataTable dt = dv.ToTable("ExcelTable");
obj.WriteDataTableToExcel(dt, "Excel Report", saveFileDialog1.FileName, "Details");
}
}
catch (Exception ex)
{
//MessageBox.Show("Order Book - Funtion Name- btnExportExcel_Click " + ex.Message);
}
}
private void btnExportExcel_Click(object sender, EventArgs e)
{
try {
Global.Instance.TradeTracker.WriteXml(Application.StartupPath + Path.DirectorySeparatorChar + System.DateTime.Now.Date.ToString("dddd, MMMM d, yyyy") + "tradetrack.xml");
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.AddExtension = true;
saveFileDialog1.DefaultExt = "xlsx";
saveFileDialog1.Filter = "*.xlsx|*.*";
if(saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
// DataTable dt = new DataTable("ExcelTable");
Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
DataView dv = new DataView(Global.Instance.OrdetTable);
dv.RowFilter = "status = 'Traded'";
dv.ToTable("ExcelTable");
DataTable dt = dv.ToTable("ExcelTable");
obj.WriteDataTableToExcel(dt, "Excel Report", saveFileDialog1.FileName, "Details");
}
}
catch (Exception ex)
{
MessageBox.Show("Order Book - Funtion Name- btnExportExcel_Click " + ex.Message);
}
}