public static List <Dados.Site> GetDados(string path)
{
string extension = path.Remove(0, path.LastIndexOf('.'));
string[] rows = new string[0];
switch (extension)
{
case ".csv":
rows = CSV.CSVReader(path);
break;
case ".XLSX":
return(XLSX.ExcelReader(path));
}
List <Dados.Site> produtos = new List <Dados.Site>();
for (int i = 1; i < rows.Length; i++)
{
string[] collumns = rows[i].Split(',');
Dados.Site produto = new Dados.Site();
produto.ID = int.Parse(collumns[0]);
produto.Ref = collumns[1];
produto.Name = collumns[2];
int stock = 0;
int.TryParse(collumns[3], out stock);
produto.Stock = stock;
produto.Price = collumns[4];
produtos.Add(produto);
}
return(produtos);
}
private void Button1_Click(object sender, EventArgs e)
{
XLSX excel = new XLSX();
string base_directory = AppDomain.CurrentDomain.BaseDirectory;
string filePath = ConfigReader.PersistableObject.Load <ConfigReader.Configuration>(String.Format("{0}\\config.xml", base_directory)).excel_path;
excel.elaboraExcel(filePath);//"D:\\provaExcel.xlsx"
}
private void Button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Word.Document documento = Globals.ThisAddIn.Application.ActiveDocument;
messaggio = documento.Content.Text;
/*XLSX excel = new XLSX();
* string base_directory = AppDomain.CurrentDomain.BaseDirectory;
* string filePath = ConfigReader.PersistableObject.Load<ConfigReader.Configuration>(String.Format("{0}\\config.xml", base_directory)).excel_path;
* excel.elaboraExcel(filePath,messaggio);*/
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.CheckFileExists = true;
openFileDialog.AddExtension = true;
openFileDialog.Multiselect = false;
openFileDialog.Filter = "Excel Files|*.xls;*.xlsx";
if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
XLSX xlsx = new XLSX();
pnlControlloEmail.Hide();
pnlRiepilogo.Hide();
pnlCaricamento.BringToFront();
pnlCaricamento.Show();
listaMessaggi = xlsx.elaboraExcel(Path.GetFullPath(openFileDialog.FileName), messaggio);
}
Microsoft.Office.Interop.Outlook.Application olkApp1 = new Outlook.Application();
Outlook.MailItem olkMail1 = (MailItem)olkApp1.CreateItem(OlItemType.olMailItem);
Accounts accounts = olkApp1.Application.Session.Accounts;
cbIndirizzi.Items.Clear();
foreach (Outlook.Account account in accounts)
{
cbIndirizzi.Items.Add(account.SmtpAddress.ToString());
}
cbIndirizzi.SelectedIndex = 0;
List <messaggiErrati> listaMessaggiErrati = (from item in listaMessaggi where item.errore
select(new messaggiErrati()
{
MessaggioTest = item.MessaggioTest ? "SI" : "NO",
Destinatario = item.Destinatario,
Allegati = String.Concat(item.Allegati)
})
).ToList();
dataGridView1.DataSource = listaMessaggiErrati;
lblCheckMail.Text = "Caricate " + listaMessaggi.Count + " righe";
pnlCaricamento.Hide();
pnlRiepilogo.Hide();
pnlControlloEmail.BringToFront();
pnlControlloEmail.Show();
}
private void Button1_Click(object sender, EventArgs e)
{
XLSX excel = new XLSX();
excel.elaboraExcel("D:\\provaExcel.xlsx");
}
