public void Generate() { foreach (IAdj adj in _adjs) { SortedList<DateTime, AdjRateDatum> adjRateData = CreateAdjRateData(adj); //String dir = Directory.GetCurrentDirectory(); //String path = dir + "\\" + _excelAdjResultFileName; CsvFileWriter writer = new CsvFileWriter(String.Format("{0}_result.csv", adj.ToString())); WriteHeader(writer); foreach (KeyValuePair<DateTime, AdjRateDatum> datum in adjRateData) { CsvRow row = new CsvRow(); row.Add(datum.Key.ToString("yyyy-MM-dd")); row.Add(datum.Value.KospiRate.ToString("n5")); row.Add(datum.Value.KtbRate.ToString("n5")); row.Add(datum.Value.DollarRate.ToString("n5")); writer.WriteRow(row); } writer.Close(); } }
static void Main(string[] args) { Process[] BandwidthMonitor = Process.GetProcessesByName("BandwidthMonitor"); if (BandwidthMonitor.Count() > 1) { } else { try { csvFileWiter = new CsvFileWriter(); CsvRow row = CheckBandwidthUsage(System.DateTime.Now); Dictionary<String, object> objArgument = new Dictionary<string, object>(); objArgument.Add("DefragArguements", row); networkUsage.WorkerSupportsCancellation = true; networkUsage.DoWork += new DoWorkEventHandler(networkUsage_DoWork); networkUsage.RunWorkerCompleted += new RunWorkerCompletedEventHandler(networkUsage_RunWorkerCompleted); networkUsage.RunWorkerAsync((object)objArgument); Console.ReadLine(); } catch (Exception Ex) { WriteLog("Log Path :: " + Ex); } } }
public static void WriteToCsvFile(this DataTable dataTable, string filePath) { CsvFileWriter writer = new CsvFileWriter(filePath); StringBuilder fileContent = new StringBuilder(); CsvRow row = new CsvRow(); foreach (var col in dataTable.Columns) row.Add(col.ToString()); writer.WriteRow(row); foreach (DataRow dr in dataTable.Rows) { row = new CsvRow(); foreach (var column in dr.ItemArray) { row.Add(column.ToString()); } writer.WriteRow(row); } writer.Close(); dataTable = null; System.Console.WriteLine(string.Format("Done writing to {0}.", filePath)); }
private void saveButton_Click(object sender, EventArgs e) { FileStream aStreamForReading = new FileStream(fileLocation, FileMode.Open); CsvFileReader aReader = new CsvFileReader(aStreamForReading); List<string> aRecord = new List<string>(); while (aReader.ReadRow(aRecord)) { string regNo = aRecord[0]; if (regNoTextBox.Text == regNo) { MessageBox.Show(@"Reg no already exists"); aStreamForReading.Close(); return; } } aStreamForReading.Close(); FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List<string> aStudentRecord = new List<string>(); aStudentRecord.Add(regNoTextBox.Text); aStudentRecord.Add(nameTextBox.Text); aWriter.WriteRow(aStudentRecord); aStream.Close(); }
void WriteHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("Date"); row.Add("KospiRate"); row.Add("KtbRate"); row.Add("DollarRate"); writer.WriteRow(row); }
void WriteHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("DateTime"); row.Add("EventPoint"); foreach (String key in _indicators.GetKeys()) { row.Add(key); } writer.WriteRow(row); }
void WriteHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("LongCode"); row.Add("ShortCode"); row.Add("From"); row.Add("To"); row.Add("RangeMax"); row.Add("RangeMin"); writer.WriteRow(row); }
public void WriteTo(String fileOutPath, PeriodicMarketDataCollection spot, PeriodicMarketDataCollection future, TradingDirection spotDirection) { EventPointsFinder target = new EventPointsFinder(); List<EventPoint> eventPoints = target.GetEventPoints(spot, future, spotDirection); CsvFileWriter writer = new CsvFileWriter(fileOutPath); WriteHeader(writer); WriteBody(writer, eventPoints); logger.Info("Write {0} complete...", fileOutPath); writer.Close(); }
public void WriteToFile(String path) { CsvFileWriter writer = new CsvFileWriter(path); try { WriteHeader(writer); WriteBody(writer); } catch (System.Exception ex) { logger.Error(ex.ToString()); } writer.Close(); }
private void saveButton_Click(object sender, EventArgs e) { FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List<string> aEmployeeRecord = new List<string>(); aEmployeeRecord.Add(employeeNameTextBox.Text); aEmployeeRecord.Add(idTextBox.Text); aEmployeeRecord.Add(salaryAmountTextBox.Text); aWriter.WriteRow(aEmployeeRecord); aStream.Close(); }
private void btnSave_Click(object sender, EventArgs e) { FileStream aFileStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aCsvFileWriter = new CsvFileWriter(aFileStream); List<string> aRecordList = new List<string>(); GetValue(aRecordList); MessageBox.Show("Saved"); aCsvFileWriter.WriteRow(aRecordList); aFileStream.Close(); }
private void button1_Click(object sender, EventArgs e) { FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List<string> aStudentRecord = new List<string>(); aStudentRecord.Add(regNoTextBox.Text); aStudentRecord.Add(nameTextBox.Text); aWriter.WriteRow(aStudentRecord); aStream.Close(); }
public void ToCsv() { const String kHeader = "CreditPolicyWithMA"; String fileName = String.Format("{0}_{1}.csv", kHeader, DateTime.Now.ToString("yyyy_MM_dd HHmmssfff")); CsvFileWriter writer = new CsvFileWriter(fileName); WriteHeader(writer); foreach (LogRow log in _logs) { CsvRow row = new CsvRow(); row.Add(log.CurDate.ToString("yyyy-MM-dd")); row.Add(log.KospiWeight.ToString()); writer.WriteRow(row); } writer.Close(); }
void WriteBody(CsvFileWriter writer, List<EventPoint> eventPoints) { foreach (EventPoint ep in eventPoints) { CsvRow row = new CsvRow(); row.Add(ep.LongCode); row.Add(ep.ShortCode); row.Add(ep.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss.fff")); row.Add(ep.DateTimeTo.ToString("yyyy-MM-dd HH:mm:ss.fff")); row.Add(ep.RangeMax.ToString("n1")); row.Add(ep.RangeMin.ToString("n1")); writer.WriteRow(row); } }
private void saveButton_Click(object sender, EventArgs e) { FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List<string> addressBook = new List<string>(); addressBook.Add(nameTextBox.Text); addressBook.Add(emailTextBox.Text); addressBook.Add(personalContactTextBox.Text); addressBook.Add(homeContactTextBox.Text); addressBook.Add(homeAddressTextBox.Text); aWriter.WriteRow(addressBook); aStream.Close(); }
private void saveButton_Click(object sender, EventArgs e) { FileStream aStream = new FileStream(fileLocation, FileMode.OpenOrCreate); CsvFileReader aReader = new CsvFileReader(aStream); List<string> aPeronRecord = new List<string>(); //personListView.Items.Clear(); while (aReader.ReadRow(aPeronRecord)) { if (aPeronRecord[2] == personalCnTextBox.Text) { MessageBox.Show("conflict"); aStream.Close(); return; } } aStream.Close(); FileStream aStream2 = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream2); List<string> aPersonRecod = new List<string>(); aPersonRecod.Add(nameTextBox.Text); aPersonRecod.Add(emailTextBox.Text); aPersonRecod.Add(personalCnTextBox.Text); aPersonRecod.Add(homeCnTextBox.Text); aPersonRecod.Add(homeAddressTextBox.Text); aWriter.WriteRow(aPersonRecod); aStream2.Close(); }
public void writePlayers(List<Player> listPlayers) { using (CsvFileWriter writer = new CsvFileWriter(file)) { foreach (var item in listPlayers) { CsvRow row = new CsvRow(); row.Add(item.Name); for (int i = 0; i < Constants.RaceNumber; i++) { row.Add(item.Races[i].ToString()); row.Add(item.Victory[i].ToString()); row.Add(item.Defeat[i].ToString()); row.Add(item.Elo[i].ToString()); } writer.WriteRow(row); } } }
void WriteBody(CsvFileWriter writer) { List<EventPoint> eps = _eventPoints.EventPoints; Dictionary<String, List<DateTimeDoublePair>> indicators = _indicators.GetIndicators(_targetDate); for (int i = 0; i < eps.Count; i = i + 2) { EventPoint ep = eps[i]; CsvRow row = new CsvRow(); row.Add(ep.DateTimeFrom.ToString("yyyy-MM-dd HH:mm:ss.fff")); row.Add(ep.RangeMax.ToString("n")); foreach (List<DateTimeDoublePair> pair in indicators.Values.ToList()) { row.Add(pair[i].DoubleValue.ToString("n")); Trace.Assert(pair[i].DateTimeValue == ep.DateTimeFrom); } writer.WriteRow(row); } }
/// <inheritdoc /> protected override void Write(CsvFileWriter writer, NewsMessage data, IMarketDataMetaInfo metaInfo) { writer.WriteRow(new[] { data.ServerTime.WriteTimeMls(), data.ServerTime.ToString("zzz"), data.Headline, data.Source, data.Url, data.Id, data.BoardCode, data.SecurityId?.SecurityCode, data.Priority?.To <string>(), data.Language, data.SecurityId?.BoardCode, data.ExpiryDate?.ToString(_expiryFormat), data.SeqNum.DefaultAsNull().ToString(), }); metaInfo.LastTime = data.ServerTime.UtcDateTime; }
/// <summary> /// This method will help to create the Csv file /// </summary> /// <param name="fileParameter"></param> /// <returns></returns> public async Task <bool> CreateCsvFile(FileParameterModel fileParameter) { //Check and create Directory If It Not Exist var filePath = await Task.Run(() => $"{FileHelper.CreateDirectory(fileParameter.FolderUrl)}//{fileParameter.FileName}"); using (var writer = new CsvFileWriter(filePath)) { //Config to get 100000 from App Setting for (int i = 0; i < fileParameter.TotalRows; i++) { var row = new CsvRowModel { $"{ Guid.NewGuid()}{fileParameter.Delimiter}{RandomString(fileParameter.MinContentLength , fileParameter.MaxContentLength, fileParameter.Pattern)}" }; await Task.Run(() => writer.WriteRow(row)); } } return(await Task.FromResult(true)); }
//Save the data to the csv database public void SaveToCSV(string fileName) { // Write sample data to CSV file using (CsvFileWriter writer = new CsvFileWriter(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "MarvelDB", fileName))) //CHECK IF THIS IS MEANT TO BE THE FULL PATH!!!! { foreach (SuperHero heroValue in heroesByName) { CsvRow row = new CsvRow(); row.Add(heroValue.HeroName); row.Add(heroValue.RealName); row.Add(heroValue.Weight.ToString()); row.Add(heroValue.Height.ToString()); row.Add(heroValue.Race.ToString()); row.Add(heroValue.InMovie.ToString()); writer.WriteRow(row); } } }
/// <inheritdoc /> protected override void Write(CsvFileWriter writer, TCandleMessage data, IMarketDataMetaInfo metaInfo) { if (data.State == CandleStates.Active) { throw new ArgumentException(LocalizedStrings.CandleActiveNotSupport.Put(data), nameof(data)); } writer.WriteRow(new[] { data.OpenTime.WriteTimeMls(), data.OpenTime.ToString("zzz"), data.OpenPrice.ToString(), data.HighPrice.ToString(), data.LowPrice.ToString(), data.ClosePrice.ToString(), data.TotalVolume.ToString() }.Concat(data.BuildFrom.ToCsv()).Concat(new[] { data.SeqNum.DefaultAsNull().ToString(), })); }
/// <summary> /// Report all parameters on the given <see cref="Iteration" />. /// </summary> public void ParametersToCsv() { var engineeringModelShortName = (this.sessionService.Iteration.Container as EngineeringModel)?.EngineeringModelSetup.ShortName; var csvPath = engineeringModelShortName + "_parameters_report.csv"; try { Console.WriteLine($"Report on parameter ({csvPath}) building in progress"); using var csvFileWriter = new CsvFileWriter(csvPath); csvFileWriter.WriteRow(this.headers); foreach (var elementDefinition in this.sessionService.Iteration.Element.OrderBy(x => x.ShortName)) { this.WriteElementDefinition(csvFileWriter, engineeringModelShortName, elementDefinition); foreach (var parameter in elementDefinition.Parameter.OrderBy(x => x.ParameterType.ShortName)) { foreach (var parameterValueSet in parameter.ValueSet) { this.WriteParameterRow(csvFileWriter, engineeringModelShortName, parameterValueSet); foreach (var parameterSubscription in parameter.ParameterSubscription.OrderBy(x => x.Owner.ShortName)) { foreach (var parameterSubscriptionValueSet in parameterSubscription.ValueSet) { this.WriteParameterRow(csvFileWriter, engineeringModelShortName, parameterSubscriptionValueSet); } } } } } Console.WriteLine($"Done building the report located at: {Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)}"); } catch (IOException ex) { Console.WriteLine(ex.Message); } }
private void MakeSpectrumFile() { Ground.I.Logger.Info("MakeSpectrumFile.1"); WaveData wavDat = new WaveData(this.MasterWavFile); Ground.I.Logger.Info("MakeSpectrumFile.2"); using (CsvFileWriter writer = new CsvFileWriter(this.SpectrumFile)) //using (CsvFileWriter writer_L = new CsvFileWriter(this.SpectrumFile_L)) // 不使用 //using (CsvFileWriter writer_R = new CsvFileWriter(this.SpectrumFile_R)) // 不使用 { for (int frame = 0; ; frame++) { int wavPartPos = (int)((frame * 1.0 / Consts.FPS + Consts.AUDIO_DELAY_SEC) * wavDat.WavHz); if (wavDat.Length <= wavPartPos) { break; } if (frame % 200 == 0) { Ground.I.Logger.Info("MSF_frame: " + frame); this.CheckCancel(); } wavDat.SetWavPart(wavPartPos); SpectrumGraph graph = new SpectrumGraph(hz => wavDat.GetSpectrum(hz)); //SpectrumGraph graph_L = new SpectrumGraph(hz => wavDat.GetSpectrum_L(hz)); // 不使用 //SpectrumGraph graph_R = new SpectrumGraph(hz => wavDat.GetSpectrum_R(hz)); // 不使用 CsvUtils.WriteRow(writer, graph); //CsvUtils.WriteRow(writer_L, graph_L); // 不使用 //CsvUtils.WriteRow(writer_R, graph_R); // 不使用 } } Ground.I.Logger.Info("MakeSpectrumFile.3"); }
//For test speed private int runAlgorithms() { controller.mAlgorithm = Algorithm.MidPoint_Line; CsvFileReader reader = new CsvFileReader("Testcase_Line.csv"); CsvFileWriter writer = new CsvFileWriter("Midpoint_Line_Runtime.csv"); CsvRow row = new CsvRow(); Random rnd = new Random(); int count = 0; while (reader.ReadRow(row)) { if (row.Count == 4) { int x1 = Int32.Parse(row[0]); int y1 = Int32.Parse(row[1]); int x2 = Int32.Parse(row[2]); int y2 = Int32.Parse(row[3]); controller.mShape = new Line(new Point(x1, y1), new Point(x2, y2)); Color color = Color.FromArgb(rnd.Next(256), rnd.Next(256), rnd.Next(256)); try { Int64 runtime = this.DrawShape(); row.Add(String.Format(runtime.ToString())); writer.WriteRow(row); count++; } catch (Exception e) { Debug.WriteLine("failed at " + count.ToString()); } } else { break; } } reader.Close(); writer.Close(); return(count); }
private void saveButton_Click(object sender, EventArgs e) { int validFile = 1; if (File.Exists(fileLocation)) { FileStream aStream = new FileStream(fileLocation, FileMode.Open); CsvFileReader aReader = new CsvFileReader(aStream); List <string> aList = new List <string>(); while (aReader.ReadRow(aList)) { string contactNumber = aList[2]; if (contactNumber == contactNumberTextBox.Text) { validFile = 0; break; } } aStream.Close(); } if (validFile == 0) { MessageBox.Show("Same Contact Number"); } else if (validFile == 1) { FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List <string> aList = new List <string>(); aList.Add(nameInputTextBox.Text); aList.Add(emailInputTextBox.Text); aList.Add(contactNumberTextBox.Text); aList.Add(homeContactTextBox.Text); aList.Add(addressTextBox.Text); aWriter.WriteRow(aList); aStream.Close(); MessageBox.Show("Saved in file"); } }
private void saveButton_Click(object sender, EventArgs e) { FileStream aStream = new FileStream(fileLocation, FileMode.OpenOrCreate); CsvFileReader aReader = new CsvFileReader(aStream); List <string> aPeronRecord = new List <string>(); //personListView.Items.Clear(); while (aReader.ReadRow(aPeronRecord)) { if (aPeronRecord[2] == personalCnTextBox.Text) { MessageBox.Show("conflict"); aStream.Close(); return; } } aStream.Close(); FileStream aStream2 = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream2); List <string> aPersonRecod = new List <string>(); aPersonRecod.Add(nameTextBox.Text); aPersonRecod.Add(emailTextBox.Text); aPersonRecod.Add(personalCnTextBox.Text); aPersonRecod.Add(homeCnTextBox.Text); aPersonRecod.Add(homeAddressTextBox.Text); aWriter.WriteRow(aPersonRecod); aStream2.Close(); }
public bool GET() { var request = new RestRequest("sync_data", Method.POST); JsonObject json = new JsonObject(); request.RequestFormat = DataFormat.Json; json.Add("pclient_id", pclient_id.ToString()); request.AddBody(json); IRestResponse <GetObject> response = client.Execute <GetObject>(request); GetObject data = response.Data; if (!requestError(response.StatusCode.ToString())) { return(false); } Directory.CreateDirectory(pathFolderName); using (CsvFileWriter writer = new CsvFileWriter(pathFolderName + "products.csv")) { foreach (SyncProduct item in data.products) { CsvRow row = new CsvRow(); row.Add(item.upc); row.Add(item.name); try { row.Add(item.warehouse_id.ToString()); } catch (Exception exc) { } writer.WriteRow(row); } } using (CsvFileWriter writer = new CsvFileWriter(pathFolderName + "warehouses.csv")) { foreach (SyncWarehouse item in data.warehouses) { CsvRow row = new CsvRow(); row.Add(item.id.ToString()); row.Add(item.name); writer.WriteRow(row); } } return(true); }
private void saveButton_Click(object sender, EventArgs e) { int isvalid = 1; if (File.Exists(filelocation)) { FileStream aStream = new FileStream(filelocation, FileMode.Open); CsvFileReader aReader = new CsvFileReader(aStream); List <string> aStudentRec = new List <string>(); while (aReader.ReadRow(aStudentRec)) { string regNo = aStudentRec[0]; if (regNo == regTextBox1.Text) { isvalid = 0; break; } } aStream.Close(); } if (isvalid == 0) { MessageBox.Show("Warning,Duplicate reg.no"); } else if (isvalid == 1) { FileStream aFileStream = new FileStream(filelocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aFileStream); List <string> aStudentrec = new List <string>(); aStudentrec.Add(regTextBox1.Text); aStudentrec.Add(nameTextBox2.Text); aWriter.WriteRow(aStudentrec); MessageBox.Show("A student has been added"); aFileStream.Close(); } }
private void UIWindow_KeyDown(object sender, KeyEventArgs e) { if (e.Key == Key.F5) { ProcessStartInfo startInfo = new ProcessStartInfo(Application.ResourceAssembly.Location); startInfo.Arguments = string.Format("-u {0} -mode {1}", App.User.Hash, (int)this.Mode); System.Diagnostics.Process.Start(startInfo); Application.Current.Shutdown(); } else if (e.Key == Key.F12) { using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_CSV_COMMAND, FileMode.Append), Encoding.UTF8)) { foreach (CsvRow r in App.Rows) { LogCSV.WriteRow(r); } App.Rows.Clear(); } using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_Send_COMMAND, FileMode.Append), Encoding.UTF8)) { foreach (CsvRow r in App.RowsSend) { LogCSV.WriteRow(r); } App.RowsSend.Clear(); } } if (Keyboard.Modifiers == ModifierKeys.Control) { if (e.Key == Key.L) { this.LockAllAlarm(null, null); } else if (e.Key == Key.U) { this.UnLockAllAlarm(null, null); } } }
/// <summary> /// Write data to the specified writer. /// </summary> /// <param name="writer">CSV writer.</param> /// <param name="data">Data.</param> /// <param name="metaInfo">Meta-information on data for one day.</param> protected override void Write(CsvFileWriter writer, ExecutionMessage data, IMarketDataMetaInfo metaInfo) { writer.WriteRow(new[] { data.ServerTime.WriteTimeMls(), data.ServerTime.ToString("zzz"), data.TransactionId.ToString(), data.OrderId.ToString(), data.OrderPrice.ToString(), data.OrderVolume.ToString(), data.Side.ToString(), data.OrderState.ToString(), data.TimeInForce.ToString(), data.TradeId.ToString(), data.TradePrice.ToString(), data.PortfolioName, data.IsSystem.ToString() }); metaInfo.LastTime = data.ServerTime.UtcDateTime; metaInfo.LastId = data.TransactionId; }
public void SetArticlePlacedRow(CsvFileWriter csvError) { articleRow = new CsvRow(); articleRow.Add(_reference.Article_Key); articleRow.Add(_reference.Article_Hinge); articleRow.Add(_reference.Article_Width.ToString()); articleRow.Add(_reference.Article_Depth.ToString()); articleRow.Add(_reference.Article_Height.ToString()); if (_sceneInfo.GenerateSceneInformations()) { articleRow.AddRange(_sceneInfo.ArticleRow()); } else { this.SetErrorRow(csvError, _reference.Article_Key); csvError.Flush(); } _csvFile.WriteRow(articleRow); }
public void Dump(string dumpFilename) { using (CsvFileWriter writer = new CsvFileWriter(dumpFilename)) { for (int i = 0; i < _recordCnt; i++) { CsvRow row = new CsvRow(); for (int j = 0; j < _inputNum + _labelNum; j++) { if (j < _inputNum) { row.Add(_input[i, j].ToString()); } else { row.Add(_label[i, j - _inputNum].ToString()); } } writer.WriteRow(row); } } }
public async Task WriteDataTableHandleIssuesAsync() { using (var dataTable = new DataTable { TableName = "DataTable", Locale = CultureInfo.InvariantCulture }) { dataTable.Columns.Add("ID", typeof(int)); dataTable.Columns.Add("Text", typeof(string)); for (var i = 0; i < 100; i++) { var row = dataTable.NewRow(); row["ID"] = i; row["Text"] = "Text" + i.ToString(CultureInfo.CurrentCulture); dataTable.Rows.Add(row); } var writeFile = new CsvFile { ID = "Test.txt", FileName = UnitTestInitializeCsv.GetTestPath("Test.txt"), SqlStatement = "Hello" }; writeFile.ColumnCollection.Add(new Column("Text", DataType.Integer)); writeFile.Header = "##This is a header for {FileName}"; writeFile.Footer = "##This is a Footer\r\n{Records} in file"; var count = 0; using (var processDisplay = new CustomProcessDisplay(UnitTestInitializeCsv.Token)) { var writer = new CsvFileWriter(writeFile, processDisplay); writer.Warning += (sender, e) => { count++; }; using (var reader = new DataTableWrapper(dataTable)) { // await reader.OpenAsync(processDisplay.CancellationToken); Assert.AreEqual(100, await writer.WriteAsync(reader, processDisplay.CancellationToken), "Records"); } Assert.AreEqual(100, count, "Warnings"); } Assert.IsTrue(File.Exists(writeFile.FileName)); } }
public void StopsWriter() { { // Write sample data to CSV file using (CsvFileWriter writer = new CsvFileWriter("stops.txt")) { /* * //----------------------------------------------- WORKING EXAMPLE * CsvRow AgencyRow = new CsvRow(); * * foreach (string s in AgencyDataList) * { * AgencyRow.Add(s); * } * * * writer.WriteRow(AgencyRow); * //---------------------------------------------- WORKING EXAMPLE */ CsvRow StopsRowValues = new CsvRow(); for (int i = 0; i < 12; i++) { StopsRowValues.Add(StopsDataList[i]); } writer.WriteRow(StopsRowValues); CsvRow StopsRowData = new CsvRow(); for (int i = 12; i < StopsDataList.Count; i++) { StopsRowData.Add(StopsDataList[i]); } writer.WriteRow(StopsRowData); } } }
public void WriteCsvFile() { var cacheData = new[] { new ProcessedCacheData( new CacheData("GC7WP8Y", new LatLng(43.550767, 16.51405), -23.896, 905.656), new LatLng(43.558220, 16.509510) ) }; var csvWriter = new CsvFileWriter(); using (var writer = new StringWriter()) { csvWriter.Write(cacheData, writer); var csvString = writer.ToString(); var expected = "GC7WP8Y,43.55822,16.50951" + Environment.NewLine; csvString.Should().Be(expected); } }
private void saveButton_Click(object sender, EventArgs e) { double amount = Convert.ToDouble(amountTextBox.Text); string category = categoryLeftComboBox.Text; string particular = particularTextBox.Text; FileStream aFileStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aCsvFileWriter = new CsvFileWriter(aFileStream); List <string> expenseinfo = new List <string>(); expenseinfo.Add(amount.ToString()); expenseinfo.Add(category); expenseinfo.Add(particular); aCsvFileWriter.WriteRow(expenseinfo); MessageBox.Show("Information Saved Successfully"); amountTextBox.Text = ""; categoryLeftComboBox.Text = ""; particularTextBox.Text = ""; aFileStream.Close(); }
public void DataSave() /* * 현재 List에 저장된 데이터들을 .csv 파일에 저장 * columns에 각 행의 내용들을 add하고 writer.WriteRow()를 사용해 행을 저장 */ { var writer = new CsvFileWriter(Application.dataPath + "/Resources/abilities.csv"); List <string> columns = new List <string>(); // 첫 행은 data_header foreach (dataHeader h in System.Enum.GetValues(typeof(dataHeader))) { string temp = h.ToString(); columns.Add(temp); } writer.WriteRow(columns); columns.Clear(); // 이후 행들은 실제 데이터 삽입 for (int i = 0; i < abilities.Count; i++) { columns.Clear(); foreach (dataHeader h in System.Enum.GetValues(typeof(dataHeader))) { string header = h.ToString(); string temp = abilities[i][header].ToString(); columns.Add(temp); } writer.WriteRow(columns); columns.Clear(); } writer.Dispose(); Debug.Log("data saved"); }
public void WriteFileLocked() { var dataTable = new DataTable { TableName = "DataTable", Locale = CultureInfo.InvariantCulture }; dataTable.Columns.Add("ID", typeof(int)); dataTable.Columns.Add("Text", typeof(string)); for (int i = 0; i < 5; i++) { var row = dataTable.NewRow(); row["ID"] = i; row["Text"] = i.ToString(CultureInfo.InvariantCulture); dataTable.Rows.Add(row); } var writeFile = new CsvFile { ID = "Test.txt", FileName = Path.Combine(m_ApplicationDirectory, "WriteFileLocked.txt"), InOverview = false }; FileSystemUtils.FileDelete(writeFile.FileName); using (System.IO.StreamWriter file = new System.IO.StreamWriter(writeFile.FileName)) { file.WriteLine("Hello"); var writer = new CsvFileWriter(writeFile, CancellationToken.None); writer.WriteDataTable(dataTable); Assert.IsTrue(!string.IsNullOrEmpty(writer.ErrorMessage)); file.WriteLine("World"); } FileSystemUtils.FileDelete(writeFile.FileName); }
private void btnExport_Click(object sender, EventArgs e) { int iTerm = cbTerm.SelectedIndex; if (iTerm != -1 && svdSave.ShowDialog() == DialogResult.OK) { //1 = excel file if (svdSave.FilterIndex == 1) { //balance sheet export if (tcMain.SelectedIndex == 0) writeFinancialStatement(lvBalance, svdSave.FileName); //income statement export else if (tcMain.SelectedIndex == 1) writeFinancialStatement(lvIncome, svdSave.FileName); //cash flow statement export else writeFinancialStatement(lvCash, svdSave.FileName); } //2 = csv file else if (svdSave.FilterIndex == 2) { using (CsvFileWriter writer = new CsvFileWriter(svdSave.FileName)) { //balance sheet export if (tcMain.SelectedIndex == 0) writeFinancialStatement(lvBalance, writer); //income statement export else if (tcMain.SelectedIndex == 1) writeFinancialStatement(lvIncome, writer); //cash flow statement export else writeFinancialStatement(lvCash, writer); if (Properties.Settings.Default.playSounds) Sound.Success.Play(); } } } }
public void ShearWallCalculatesPMMDiagramMaxIteration() { double f_c_prime = 6; double f_c_prime_psi = f_c_prime * 1000; IRebarMaterial LongitudinalRebarMaterial = new RebarMaterialGeneral(60000); double l_w = 20 * 12; double h = 12; FlexuralCompressionFiberPosition p = FlexuralCompressionFiberPosition.Top; ConcreteMaterial Concrete = new ConcreteMaterial(f_c_prime_psi, ConcreteTypeByWeight.Normalweight, null); ConfinementReinforcementType ConfinementReinforcementType = KodestructAci.ConfinementReinforcementType.Ties; CrossSectionRectangularShape shape = new CrossSectionRectangularShape(Concrete, null, h, l_w); List <RebarPoint> LongitudinalBars = GetLongitudinalBarsFromCoordinates(LongitudinalRebarMaterial); KodestructAci.IConcreteFlexuralMember fs = new KodestructAci14.ConcreteSectionFlexure(shape, LongitudinalBars, null, ConfinementReinforcementType); IConcreteSectionWithLongitudinalRebar Section = fs as IConcreteSectionWithLongitudinalRebar; ConcreteSectionCompression column = new ConcreteSectionCompression(Section, ConfinementReinforcementType, null); //Convert axial force to pounds List <PMPair> Pairs = column.GetPMPairs(p, 50, true); var PairsAdjusted = Pairs.Select(pair => new PMPair(pair.P / 1000.0, pair.M / 1000.0 / 12.0)); string Filename = Path.Combine(Path.GetTempPath(), "PMInteractionShearWallMaxIteration.csv"); using (CsvFileWriter writer = new CsvFileWriter(Filename)) { foreach (var pair in PairsAdjusted) { CsvRow row = new CsvRow(); row.Add(pair.M.ToString()); row.Add(pair.P.ToString()); writer.WriteRow(row); } } }
public void AgencyWriter()//(CsvRow row) { // Write sample data to CSV file using (CsvFileWriter writer = new CsvFileWriter("agency.txt")) { /* * //----------------------------------------------- WORKING * CsvRow AgencyRow = new CsvRow(); * * foreach (string s in AgencyDataList) * { * AgencyRow.Add(s); * } * * * writer.WriteRow(AgencyRow); * //---------------------------------------------- WORKING */ CsvRow AgencyRowValues = new CsvRow(); for (int i = 0; i < 8; i++) { AgencyRowValues.Add(AgencyDataList[i]); } writer.WriteRow(AgencyRowValues); CsvRow AgencyRowData = new CsvRow(); for (int i = 8; i < AgencyDataList.Count; i++) { AgencyRowData.Add(AgencyDataList[i]); } writer.WriteRow(AgencyRowData); } }
private void saveButton_Click(object sender, EventArgs e) { int valid = 1; if (File.Exists(fileLocation)) { FileStream aStream = new FileStream(fileLocation, FileMode.Open); CsvFileReader aReader = new CsvFileReader(aStream); List <string> studentRecord = new List <string>(); while (aReader.ReadRow(studentRecord)) { string regNo = studentRecord[0]; if (regNo == regNoTextBox.Text) { valid = 0; break; } } aStream.Close(); } if (valid == 0) { MessageBox.Show("Same Reg No"); } else if (valid == 1) { FileStream fileStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(fileStream); List <string> record = new List <string>(); record.Add(regNoTextBox.Text); record.Add(nameInputTextBox.Text); aWriter.WriteRow(record); fileStream.Close(); MessageBox.Show("Saved."); } }
public static void Main(string[] args) { // Everything starts with initializing Host, which manages connection to the // Tobii Engine and provides all the Tobii Core SDK functionality. // NOTE: Make sure that Tobii.EyeX.exe is running var host = new Host(); // 2. Create stream. var gazePointDataStream = host.Streams.CreateGazePointDataStream(); gazePointDataStream.GazePoint((gazePointX, gazePointY, _) => Console.WriteLine("X: {0} Y:{1}", gazePointX, gazePointY)); // Console.ReadKey(); // 3. Get the gaze data! using (CsvFileWriter writer = new CsvFileWriter("TobiiData.csv")) { //gazePointDataStream.GazePoint((x, y, ts) => //{ // CsvRow row = new CsvRow(); // row.Add(String.Format("{0},{1},{2}", ts, x, y)); // writer.WriteRow(row); // Console.WriteLine("inside the writer function"); //}); Console.WriteLine("Before picking up gaze"); Console.WriteLine(gazePointDataStream.GazePoint((gazePointX, gazePointY, _) => Console.WriteLine("X: {0} Y:{1}", gazePointX, gazePointY))); Console.WriteLine("Writing Tobii data to CSV..."); Console.WriteLine("press any key when this window is focused to end"); Console.Read(); // we will close the coonection to the Tobii Engine before exit. host.DisableConnection(); } }
private void Application_Exit(object sender, ExitEventArgs e) { if (Timethread != null) { Timethread.Abort(); } if (checkFile != null) { this.checkFile.Abort(); } Alarms.Write(_FILE_Alarm_Data, DataAlarm); Users.write(_FILE_User_Data, DataUser); Cameras.Write(_FILE_Camera_Data, DataCamera); // Map.Write(_FILE_Map_Data, Map); Presets.Write(_FILE_PRESET_DATA, DataPreset); // Config.Write(_FILE_Config, setting); if (m_bInitSDK == true) { CHCNetSDK.NET_DVR_Cleanup(); } using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_CSV_COMMAND, FileMode.Append), Encoding.UTF8)) { for (int i = 0; i < Rows.Count; i++) { LogCSV.WriteRow(Rows[i]); } } using (CsvFileWriter LogCSV = new CsvFileWriter(File.Open(App._FILE_Send_COMMAND, FileMode.Append), Encoding.UTF8)) { for (int i = 0; i < RowsSend.Count; i++) { LogCSV.WriteRow(RowsSend[i]); } } //VlcContext.CloseAll(); }
private void saveButton_Click(object sender, EventArgs e) { string amount = amountTextBox.Text; string particular = particularTextBox.Text; string categoryEntry = categoryForEntryComboBox.Text; FileStream aFileStream = new FileStream(path, FileMode.Append); CsvFileWriter aStreamWriter = new CsvFileWriter(aFileStream); List <string> dailyExpense = new List <string>(); dailyExpense.Add(amount); dailyExpense.Add(categoryEntry); dailyExpense.Add(particular); aStreamWriter.WriteRow(dailyExpense); aFileStream.Close(); //aStreamWriter.Write(amount + "," + categoryEntry + "," + particular); //aStreamWriter.WriteLine(); //aStreamWriter.Close(); //aFileStream.Close(); MessageBox.Show("Saved"); particularTextBox.Text = ""; amountTextBox.Text = ""; categoryForEntryComboBox.Text = ""; }
/// <summary> /// Save data into stream. /// </summary> /// <param name="stream">Data stream.</param> /// <param name="data">Data.</param> /// <param name="metaInfo">Meta-information on data for one day.</param> public override void Serialize(Stream stream, IEnumerable <TCandleMessage> data, IMarketDataMetaInfo metaInfo) { var candleMetaInfo = (CandleCsvMetaInfo)metaInfo; var toWrite = candleMetaInfo.Process(data); CultureInfo.InvariantCulture.DoInCulture(() => { var writer = new CsvFileWriter(stream, Encoding); try { foreach (var item in toWrite) { Write(writer, item, candleMetaInfo); } } finally { writer.Writer.Flush(); } }); }
private void Write(IEnumerable <T> items, bool append, bool clear) { using (var stream = new FileStream(_fileName, FileMode.OpenOrCreate)) { if (clear) { stream.SetLength(0); } if (append) { stream.Position = stream.Length; } using (var writer = new CsvFileWriter(stream, _encoding)) { foreach (var item in items) { Write(writer, item); } } } }
public void WriteValues() { using (var writer = new CsvFileWriter("D://2.csv")) { writer.WriteRow(new List <string> { "Id", "Age", "啦啦啦" }); // Write each row of data for (int row = 0; row < 100; row++) { // TODO: Populate column values for this row List <string> columns = new List <string>() { row.ToString(), (20 + row).ToString(), "啦啦啦" + row }; writer.WriteRow(columns); } } }
private void btnSave_Click(object sender, EventArgs e) { FileStream aFileStream = new FileStream(fileLocation, FileMode.Open); CsvFileReader aReader = new CsvFileReader(aFileStream); List<string> aRecordList = new List<string>(); while (aReader.ReadRow(aRecordList)) { string number = aRecordList[0]; if(number == txtPhoneNumber.Text) { MessageBox.Show("Wrong Entry"); aFileStream.Close(); return; } } aFileStream.Close(); FileStream aStream = new FileStream(fileLocation, FileMode.Append); CsvFileWriter aWriter = new CsvFileWriter(aStream); List<string> addressRecord = new List<string>(); addressRecord.Add(txtPhoneNumber.Text); addressRecord.Add(txtName.Text); addressRecord.Add(txtEmail.Text); addressRecord.Add(txtAddress.Text); addressRecord.Add(txtHomePhone.Text); aWriter.WriteRow(addressRecord); aStream.Close(); }
void WriteDoneFileOutHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("LongShort"); row.Add("Count"); row.Add("Rate"); row.Add("Price"); row.Add("Notional"); row.Add("LongDate"); row.Add("LongPrice"); writer.WriteRow(row); }
//Add a stater to the stater list. private void addStaterToStaterListToolStripMenuItem_Click(object sender, EventArgs e) { createStaterObjects(); Form3 form3 = new Form3(); if (form3.ShowDialog() == DialogResult.OK) { staters.Add(new Stater(form3.firstName, form3.lastName)); staters[staters.Count - 1].Barcode = form3.pin; staters[staters.Count - 1].City = form3.city; staters[staters.Count - 1].County = form3.county; string filePath = loadStaterList(); using (CsvFileWriter writer = new CsvFileWriter(filePath)) { foreach (Stater s in staters) { CsvRow row = new CsvRow() { s.Barcode.ToString(), s.FirstName, s.LastName, s.City, s.County }; writer.WriteRow(row); } } createStaterObjects(); if (programRunning != "") { Picture.Text += form3.pin + "\n"; Picture.Focus(); Picture.SelectionStart = Picture.Text.Length + 1; SendKeys.Send("{ENTER}"); } } }
void WriteHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("CurDate"); row.Add("KospiWeight"); writer.WriteRow(row); }
void Write_PbTLog_FileOut_Header(CsvFileWriter writer) { CsvRow row = new CsvRow(); //row.Add("Date"); //row.Add("Count"); //row.Add("Rate"); //row.Add("Price"); //row.Add("Notional"); //TODO writer.WriteRow(row); }
void WriteRemainLongFileOutHeader(CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("Date"); row.Add("Count"); row.Add("Rate"); row.Add("Price"); row.Add("Notional"); writer.WriteRow(row); }
void WriteRemainLongBody(KtbSpotPosition longPos, CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add(longPos.TradingDate.ToString("yyyy-MM-dd")); row.Add("" + longPos.Count); row.Add(longPos.Rate.ToString("n5")); row.Add("" + longPos.Price); row.Add("" + longPos.Notional); writer.WriteRow(row); }
void WriteDoneBody(KtbSpotDonePosition done, CsvFileWriter writer) { CsvRow row = new CsvRow(); row.Add("" + done.ShortPosition.Long_2_Short_1); row.Add("" + done.ShortPosition.Count); row.Add(done.ShortPosition.Rate.ToString("n5")); row.Add("" + done.ShortPosition.Price); row.Add("" + done.ShortPosition.Notional); row.Add("" + done.LongPosition.TradingDate.ToString("yyyyMMdd")); row.Add("" + done.LongPosition.Price); writer.WriteRow(row); }
void RemainLong_FileOut() { const string kSubFolder = @"remains\"; string fileName = String.Format("{0}_remains.csv", _today.ToString("yyyy_MM_dd")); string remains_path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName); CsvFileWriter writer = new CsvFileWriter(remains_path); WriteRemainLongFileOutHeader(writer); foreach (KtbSpotPosition longPos in this.RemainLongs) { WriteRemainLongBody(longPos, writer); } writer.Flush(); writer.Close(); }
void PbTLog_FileOut() { const string kSubFolder = @"pb_tlog\"; string fileName = String.Format("{0}_pb_tlog.csv", _today.ToString("yyyy_MM_dd")); string path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName); CsvFileWriter writer = new CsvFileWriter(path); //TODO writer.Flush(); writer.Close(); }
void Done_FileOut() { const string kSubFolder = @"dones\"; string fileName = String.Format("{0}_dones.csv", _today.ToString("yyyy_MM_dd")); string path = String.Format("{0}{1}{2}", kFolder, kSubFolder, fileName); CsvFileWriter writer = new CsvFileWriter(path); WriteDoneFileOutHeader(writer); foreach (KtbSpotDonePosition done in this.Dones) { WriteDoneBody(done, writer); } writer.Flush(); writer.Close(); }