private void lbButton14_Click(object sender, EventArgs e) { if (!led4.Active) { if (saveFileDialog1.ShowDialog() == DialogResult.OK) { writer = new CsvWriter(saveFileDialog1.FileName); led4.Active = true; if (led1.Active) { SetButtonsActivate(true); } timer1.Interval = Convert.ToInt16(textBox2.Text); counter = 0; saveFileDialog1.Dispose(); lbButton14.Label = "Close"; } } else { writer.EndRecord(); writer.Close(); led4.Active = false; SetButtonsActivate(false); lbButton14.Label = "Save"; } }
public void TestCSV() { var layout = RowLayout.CreateTyped(typeof(TestStruct)); var t1 = new TestStruct(); t1.Init(TimeSpan.MinValue); var t2 = new TestStruct(); t2.Init(TimeSpan.MaxValue); var t3 = new TestStruct(); t3.Init(DateTime.Now.TimeOfDay); var ms = new MemoryStream(); var w = new CsvWriter(layout, ms); w.Write(t1); w.Write(t2); w.Write(t3); w.Close(); var ms2 = new MemoryStream(ms.ToArray()); var r = new CsvReader(layout, ms2); var list = r.ReadList <TestStruct>(); Assert.AreEqual(3, list.Count); Assert.AreEqual(t1, list[0]); Assert.AreEqual(t2, list[1]); Assert.AreEqual(t3, list[2]); }
private void StopLogging() { // Don't do anything if logging is already in "stopped" state. // Otherwise it will get stuck in the WaitOne loop. if (_logging != 2) { // Ensure timer is in "idle" state before stopping it. // If logging = 0 "idle", set logging = 2 "stopped" // but don't let another thrad change logging at the same time. // If logging was not 0 "idle", wait until it is. while (Interlocked.CompareExchange(ref _logging, 2, 0) != 0) { _loggingLock.WaitOne(); } try { // Disable the timer. _timer.Enabled = false; // Close the filestream if necessary. _writer?.Close(); // TODO: Close the DUT serial port. // Update GUI. toolStripStatusLabel1.Text = "Ready..."; } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR"); } } }
/// <summary> /// Cierra un archivo si estaba abierto /// </summary> private void CloseFile(CsvWriter writer) { if (writer != null) { writer.Flush(); writer.Close(); } }
// method - public: writes out a unit intelligence's action set to the associated file // public void WriteOutBehaviors() { //Error handling if (unitIntelligenceScript == null) { throw new MissingReferenceException("'Unit Intelligence' instance not assigned. Please assign the file in the Inspector and try again."); } if (actionSetFile == null) { throw new MissingReferenceException("CSV file 'Action Set File' not assigned. Please assign the file in the Inspector and try again."); } filePath = AssetDatabase.GetAssetPath(actionSetFile); //Gets file path if (filePath == "") { throw new MissingReferenceException("CSV file 'Action Set File' could not be found. Please assign a valid file in the Inspector and try again."); } if (filePath.Substring(filePath.Length - 3, 3) != "csv") { throw new MissingReferenceException("CSV file 'Action Set File' is not a valid .csv file. Please assign a valid file in the Inspector and try again."); } //Reads, clears, then builds writer for file string[] fileLines = File.ReadAllLines(filePath); string tempPath = filePath.Substring(0, filePath.Length - 4) + "_temp.csv"; CsvWriter writer = new CsvWriter(tempPath); //Writes header lines for (int i = 0; i < rowsToSkip; i++) { if (fileLines.Length <= rowsToSkip) { //TODO update to read from header lines writer.WriteRow(fileLines[i]); } else { writer.WriteRow(fileLines[i]); } } //Writes in action items string[] actions = FormatActionsToCsv(unitIntelligenceScript.GetActions()); for (int j = 0; j < actions.Length; j++) { writer.WriteRow(actions[j]); } //Cleans up the writer and writes to the file writer.Close(); if (File.Exists(filePath)) { File.Delete(filePath); } File.Move(tempPath, filePath); File.Delete(tempPath); Debug.Log("Writing successful!"); }
public void Close() { var stream = new MemoryStream(); var writer = new CsvWriter(stream, Encoding.ASCII, 1024, false); writer.Close(); stream.Close(); writer.WriteField("Hello"); }
public void close_calls_dispose() { var textWriter = new Mock <TextWriter>(); textWriter.Protected().Setup("Dispose", true).Verifiable(); var writer = new CsvWriter(textWriter.Object); writer.Close(); textWriter.Verify(); }
public void CloseTest() { using var memory = new MemoryStream(); var writer = new CsvWriter(new StreamWriter(memory)); writer.Close(); Assert.Throws <ObjectDisposedException>(() => { writer.Write("Eren", 16); }); }
static void Main(string[] args) { var writer = new CsvWriter <Person>("Persons.csv"); writer.AddFormatter <DateTime>(d => d.ToString("MM/dd/yyyy")); writer.WriteHeaders(); writer.WriteRows(GetPersons()); writer.Flush(); writer.Close(); }
private async void test_t_Click(object sender, RoutedEventArgs e) { double[] test_dis = new double[] { 0, 7.5, 15, -7.5, -15 }; //new int[] { 0, 0, 0, 0, 0, 0, 0 }; List <double> list_dis = new List <double>(); int[] test_time = new int[] { 10, 50, 100, 150, 200 };//0.01 0,05 ,0.1,0.15 List <int> list_time = new List <int>(); string[] file_t = System.IO.Directory.GetFiles(@"C:\Users\S2\OneDrive\デスクトップ\研究室\音\ランダム5文字_女性\wav_音量", "*", System.IO.SearchOption.AllDirectories); System.Random r = new System.Random(); List <string> listtext = new List <string>(); list_time.AddRange(test_time); for (int i = 0; i < test_time.Length; i++) { int rand_t = r.Next(list_time.Count); slice.Value = list_time[rand_t]; div_sl.Content = slice.Value / 1000; list_time.RemoveAt(rand_t); listtext.Add(div_sl.Content.ToString()); listtext.Add("\r\n"); list_dis.AddRange(test_dis); for (int j = 0; j < test_dis.Length; j++) { int rand_d = r.Next(list_dis.Count); distance.Value = list_dis[rand_d]; listtext.Add(distance.Value.ToString()); await Task.Delay(2500); //あきらめた string url = test_time_play(file_t[r.Next(file_t.Length)]); listtext.Add(url.Substring(url.Length - 9, 5)); listtext.Add("\r\n"); list_dis.RemoveAt(rand_d); await Task.Delay(4500); } using (var csv = new CsvWriter(@"C:\Users\S2\OneDrive\デスクトップ\研究室\子音と母音\jikanjiku.csv")) { Console.Write(listtext); csv.WriteRow(listtext); csv.Close(); } listtext = new List <string>(); } }
public void StopLogging() { if (!IsActive) { return; } FARLogger.Debug($"Stopping logging to {FileName}"); StopCoroutine(coroutine); writer.Close(); coroutine = null; }
public static void ExportCSV(string path, Guid pollId) { var poll = DataService.PerThread.ContentSet.OfType <Poll>().SingleOrDefault(x => x.Id == pollId); if (poll == null) { throw new BusinessLogicException("Указан неверный идентификатор голосования"); } else { var bulletins = poll.Bulletins.OrderByDescending(x => x.Weight).ThenByDescending(x => x.Result).ThenBy(x => x.Id).ToList(); using (var writer = new CsvWriter(path)) { writer.ValueSeparator = ';'; writer.WriteHeaderRecord("Номер бюллетеня", "Голос", "Вес"); foreach (var pollBulletin in bulletins) { if (pollBulletin.Weight.Equals(0)) { writer.WriteDataRecord(pollBulletin.Id, "Голос делегирован", "-"); } else { switch ((VoteOption)pollBulletin.Result) { case VoteOption.Yes: writer.WriteDataRecord(pollBulletin.Id, "За", pollBulletin.Weight); break; case VoteOption.No: writer.WriteDataRecord(pollBulletin.Id, "Против", pollBulletin.Weight); break; case VoteOption.NotVoted: writer.WriteDataRecord(pollBulletin.Id, "Не голосовал", pollBulletin.Weight); break; case VoteOption.Refrained: writer.WriteDataRecord(pollBulletin.Id, "Воздержался", pollBulletin.Weight); break; default: writer.WriteDataRecord(pollBulletin.Id, "Неизвестно", pollBulletin.Weight); break; } } } writer.Close(); } } }
public void CsvWriter_Basic() { StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); CsvWriter writer = new CsvWriter(sw); writer.WriteLine(10, 20, 11.5, "Hello", "Hello,World", "Hello \"Cruel\" World", null); writer.WriteLine("End"); writer.Close(); Assert.Equal( @"10,20,11.5,Hello,""Hello,World"",""Hello """"Cruel"""" World"", End ", sb.ToString()); }
private void ButtonFolder_Click(object sender, RoutedEventArgs e) { try { CsvWriter outCSV = new CsvWriter(tbOutputCSVFolder.Text); outCSV.WriteRecord("TYPE", "PATH", "FILENAME"); RecurseFolder(tbFolder.Text, "\\", outCSV); outCSV.Close(); if (MessageBox.Show("Complete! Would you like to open the file?", "Complete!", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { System.Diagnostics.Process.Start(tbOutputCSVFolder.Text); } } catch (Exception excp) { MessageBox.Show("Error: " + excp.Message); } }
private async void test_Click(object sender, RoutedEventArgs e) { System.Random r = new System.Random(); List <string> listtext = new List <string>(); double[] test_dis = new double[] { 0, 7.5, 15, -7.5, -15 }; //new int[] { 0, 0, 0, 0, 0, 0, 0 }; List <double> list_dis = new List <double>(); list_dis.AddRange(test_dis); await Task.Delay(10000); for (int j = 0; j < 7; j++) { for (int i = 0; i < test_dis.Length; i++) { int rand = r.Next(list_dis.Count); distance.Value = list_dis[rand]; textBox.Text = string.Join("", rand_hiragana()); listtext.Add(textBox.Text); listtext.Add(distance.Value.ToString("#;-#;0")); listtext.Add("\r\n"); shin_boin_play(); await Task.Delay(7000); //あきらめた list_dis.RemoveAt(rand); } list_dis.AddRange(test_dis); using (var csv = new CsvWriter(@"C:\Users\S2\OneDrive\デスクトップ\研究室\子音と母音\hiragana.csv")) { Console.Write(listtext); csv.WriteRow(listtext); csv.Close(); } listtext = new List <string>(); } listtext.Add("\r\n"); }
private void Button_Click(object sender, RoutedEventArgs e) { try { CsvWriter outCSV = new CsvWriter(tbOutputCSV.Text); outCSV.WriteRecord("TYPE", "PATH", "FILENAME"); System.IO.Stream s = new FileStream(tbZipFile.Text, FileMode.Open); String zipName = tbZipFile.Text.Split('\\').Last(); RecurseZip("\\" + zipName, s, outCSV); outCSV.Close(); if (MessageBox.Show("Complete! Would you like to open the file?", "Complete!", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { System.Diagnostics.Process.Start(tbOutputCSV.Text); } } catch (Exception excp) { MessageBox.Show("Error: " + excp.Message); } }
private FileContentResult BuildFormResultsCSV(List <string> leadingHeaders) { //debug Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " started"); string includeParts = Request["includeParts"] as string; Dictionary <string, int> formPartMap = (Dictionary <string, int>)Session["formPartMap"]; string formId = Request["formId"] as string; ExportModel exportModel = (ExportModel)Session["ExportModel"]; int iFormId = Convert.ToInt32(formId); List <def_Forms> forms = new List <def_Forms>(); if (iFormId == 0) { foreach (int?id in exportModel.formIds) { forms.Add(formsRepo.GetFormById(Convert.ToInt32(id))); } } else { forms.Add(formsRepo.GetFormById(iFormId)); } string outpath = ControllerContext.HttpContext.Server.MapPath("../Content/formResults_" + System.DateTime.Now.Ticks + ".csv"); Stream stream = new FileStream(outpath, FileMode.Create); CsvWriter writer = new CsvWriter(stream); // Build a map of with all relevent itemVariable identifiers Dictionary <int, string> ivIdentifiersById = new Dictionary <int, string>(); foreach (string leadingIdent in leadingHeaders) { int id = leadingIdent.StartsWith("FORMRESULT_") ? -1 - ivIdentifiersById.Count : formsRepo.GetItemVariableByIdentifier(leadingIdent).itemVariableId; ivIdentifiersById.Add(id, leadingIdent); } int i = 0; Dictionary <int, List <string> > formIdentMap = new Dictionary <int, List <string> >(); foreach (def_Forms form in forms) { List <string> map = new List <string>(); // Use the formPartMap when its not empty. i = (formPartMap.Count() > 0) ? formPartMap[form.formId + " start"] : 0; foreach (def_Parts prt in formsRepo.GetFormParts(form)) { if (prt.identifier.Contains("Scores")) { continue; } if (includeParts[i++] == '1') { //formPartMap.Add(form.formId + " " + prt.partId + " ident start", ivIdentifiersById.Count()); foreach (def_Sections sctn in formsRepo.GetSectionsInPart(prt)) { formsRepo.CollectItemVariableIdentifiersById(sctn, ivIdentifiersById); foreach (def_Items item in formsRepo.GetAllItemsForSection(sctn)) { map.AddRange(formsRepo.GetItemVariablesByItemId(item.itemId).Select(iv => iv.identifier).ToList()); } } Debug.WriteLine("Added more sections to ivIdentifiersById, form: " + form.formId + " part: " + prt.partId + " new Count: " + ivIdentifiersById.Count()); //formPartMap.Add(form.formId + " " + prt.partId + " ident end", ivIdentifiersById.Count()); } } formIdentMap.Add(form.formId, map); } //add additional columns for any unhandled data the comes back from CommonExport.GetFormResultValues foreach (FormResultExportTagName tagName in Enum.GetValues(typeof(FormResultExportTagName))) { string header = "FORMRESULT_" + tagName.ToString(); if (!ivIdentifiersById.Values.Contains(header)) { int id = -1 - ivIdentifiersById.Count; //not used, but must be unique to act as dictionary key ivIdentifiersById.Add(id, header); } } //debug Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished Build a map of with all column identifiers"); // Build a list of formresults to export List <int?> formResultIds = exportModel.formResultIds; List <def_FormResults> formResultsToExport; if (iFormId == 0) { formResultsToExport = new List <def_FormResults>(); foreach (def_Forms form in forms) { formResultsToExport.AddRange(formsRepo.GetFormResultsByFormId(form.formId).Where(r => formResultIds.Contains(r.formResultId)).ToList()); } } else { if (formResultIds == null) { formResultsToExport = formsRepo.GetFormResultsByFormId(iFormId).ToList(); } else { formResultsToExport = formsRepo.GetFormResultsByFormId(iFormId).Where(r => formResultIds.Contains(r.formResultId)).ToList(); } } Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished building a list of formresults to export"); //build a header record with identifiers int n = ivIdentifiersById.Count; List <int> ivIds = new List <int>(); List <string> identifiers = new List <string>(); List <string> headerText = new List <string>(); int j = 0; foreach (KeyValuePair <int, string> de in ivIdentifiersById) { ivIds.Add(de.Key); identifiers.Add(de.Value); headerText.Add(de.Value.Replace("FORMRESULT_", "")); j++; } HeaderRecord hr = new HeaderRecord(true, headerText); writer.WriteRecord(hr); Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished build a header record with identifiers"); //Build a DataRecord with item labels (second row in the output file) string[] values = new string[n]; //used to temporarily store the values for each row in the export for (int k = 0; k < n; k++) { if (identifiers[k].StartsWith("FORMRESULT_")) { FormResultExportTagName tag = (FormResultExportTagName)Enum.Parse(typeof(FormResultExportTagName), headerText[k]); values[k] = getCSVSecondRowLabelForFormResultTagName(tag); } else { values[k] = formsRepo.GetItemVariableById(ivIds[k]).def_Items.label; } } writer.WriteRecord(new DataRecord(hr, values)); Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished Build a DataRecord with item labels"); //insert access logs (one for each assessment being exported) int[] arrFrIds = formResultIds.Where(id => id.HasValue).Select(id => id.Value).ToArray(); AccessLogging.InsertMultipleAccessLogRecords(formsRepo, arrFrIds, (int)AccessLogging.accessLogFunctions.EXPORT, "Export CSV of assessment"); // Build a DataRecord for each form result int count = 0, total = formResultsToExport.Count(); foreach (def_FormResults fr in formResultsToExport) { //pull all necessary data for this formResult List <ValuePair> rspValues = CommonExport.GetDataByFormResultId(fr.formResultId); List <ValuePair> frValues = CommonExport.GetFormResultValues(fr, forms.Where(f => f.formId == fr.formId).FirstOrDefault()); //fill in values from formResult for (int k = 0; k < n; k++) { if (identifiers[k].StartsWith("FORMRESULT_")) { //values[k] = GetFormResultValue(fr, headerText[k]); ValuePair vp = frValues.Where(vpt => vpt.identifier == headerText[k]).FirstOrDefault(); if (vp != null) { values[k] = vp.rspValue; } else { values[k] = ""; } } } //replace reponse values (numbers) with meaningful text for certain cells //FormResults_formStatus status; //Enum.TryParse(values[colIndex_status], out status); //values[colIndex_status] = status.ToString(); //values[colIndex_sis_why] = GetDropdownText("assmtReason", values[colIndex_sis_why]); //fill in values from responseVariables for (i = 0; i < n; i++) { if (identifiers[i].StartsWith("FORMRESULT_")) { continue; } ValuePair vp = null; if (identifiers[i].StartsWith("FORMRESULT_") || formIdentMap[fr.formId].Contains(identifiers[i])) { vp = rspValues.Where(vpt => vpt.identifier == identifiers[i]).FirstOrDefault(); } values[i] = vp == null ? "" : vp.rspValue; } writer.WriteRecord(new DataRecord(hr, values)); //debug Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished " + (++count) + "/" + total + " records"); } writer.Close(); //<- calls stream.Close() //debug Debug.WriteLine(" * * * BuildFormResultsCSV - " + DateTime.Now.Ticks + " finished everything"); return(File(System.IO.File.ReadAllBytes(outpath), "text/csv", "results.csv")); }
private void CleanUp() { writer.Close(); stream.Close(); }
public void close_calls_dispose() { var textWriter = new Mock<TextWriter>(); textWriter.Protected().Setup("Dispose", true).Verifiable(); var writer = new CsvWriter(textWriter.Object); writer.Close(); textWriter.Verify(); }