private void DtOutput_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); string outputLocation = Properties.Settings.Default.OutputLocation; if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string filePath = openFileDialog.ToString(); string fileName = Path.GetFileName(filePath); string fileLocation = outputLocation + "\\" + fileName; List <string> headers = new List <string>(); headers.Add("Reference"); headers.Add("name 1"); headers.Add("name 2"); ReferenceScanner.ReferenceCheckedData speedCheck = new ReferenceScanner.ReferenceCheckedData(); DataTable checkedData = speedCheck.ReturnReferenceScannedDataTable(fileLocation, ReferenceScanner.OutputFormat.DataTable, ReferenceScanner.FileType.csv, headers); dataGridView1.DataSource = checkedData; } }
private void ExlOutput_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); string outputLocation = Properties.Settings.Default.OutputLocation; if (openFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { ReferenceScanner.ReferenceCheckedData ScanforRefs = new ReferenceScanner.ReferenceCheckedData(); string filePath = openFileDialog.ToString(); string fileName = Path.GetFileName(filePath); string fileLocation = outputLocation + "\\" + fileName; List <string> headers = new List <string>(); headers.Add("Reference"); headers.Add("name 1"); headers.Add("name 2"); string sheetName = "EBU Daily"; ScanforRefs.ReturnReferenceScannedData(fileLocation, ReferenceScanner.OutputFormat.Excel, headers, outputLocation, fileName, sheetName); } }