C#

costPS.Clear();

// create CandlePlot.
CandlePlot cp = new CandlePlot();
cp.DataSource = dt;
cp.AbscissaData = "Date";

cp.OpenData = "Open";
cp.LowData = "Low";
cp.HighData = "High";
cp.CloseData = "Close";
cp.BearishColor = Color.Red;
cp.BullishColor = Color.Green;
cp.Style = CandlePlot.Styles.Filled;
costPS.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.AntiAlias;
costPS.Add(new Grid());
costPS.Add(cp);
costPS.Title = symbol;
costPS.YAxis1.Label = "Price [$]";
costPS.YAxis1.LabelOffset = 40;
costPS.YAxis1.LabelOffsetAbsolute = true;
costPS.XAxis1.HideTickText = true;
costPS.Padding = 5;
costPS.AddInteraction(new NPlot.Windows.PlotSurface2D.Interactions.HorizontalDrag());
costPS.AddInteraction(new NPlot.Windows.PlotSurface2D.Interactions.VerticalDrag());
costPS.AddInteraction(new NPlot.Windows.PlotSurface2D.Interactions.AxisDrag(false));
costPS.InteractionOccured += new NPlot.Windows.PlotSurface2D.InteractionHandler(costPS_InteractionOccured);
costPS.AddAxesConstraint(new AxesConstraint.AxisPosition(PlotSurface2D.YAxisPosition.Left, 60));
costPS.Refresh();

private void DisplayText(object sender, EventArgs e)
        {
            RxString = RxString.Remove(0, 3); //This removes the first 4 characters
            //Need to convert RxString to double for formatting            
            double dblRx = double.Parse (RxString);
            //Converting back to a string will result in leading zeros removed
            RxString =  dblRx.ToString();
            textBox1.Text = RxString;
                        
        }// End of DisplayText

        private void serialPort1_DataReceived(object sender, System.IO.Ports.SerialDataReceivedEventArgs e)
        {
            RxString = "";


            try
            {
                RxString = serialPort1.ReadTo("\r");
                serialPort1.WriteLine("*X01\r");
            }
            catch (Exception Exception)
            {
                return;
            }
                     
            this.Invoke(new EventHandler(DisplayText));
        }//End of serialPort1_DataReceived

<code>
    Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass(); 
    try 
    { 
        app.Visible = false; 
        Excel.Workbook wBook = app.Workbooks.Add(true); 
        Excel.Worksheet wSheet = wBook.Worksheets[1] as Excel.Worksheet; 
        if (dt.Rows.Count > 0) 
        { 
            int row = 0; 
            row = dt.Rows.Count; 
            int col = dt.Columns.Count; 
            for (int i = 0; i < row; i++) 
            { 
                for (int j = 0; j < col; j++) 
                { 
                    string str = dt.Rows[i][j].ToString(); 
                    wSheet.Cells[i + 2, j + 1] = str; 
                } 
            } 
        } 
        int size = dt.Columns.Count; 
        for (int i = 0; i < size; i++) 
        { 
            wSheet.Cells[1, 1 + i] = dt.Columns[i].ColumnName; 
        } 
        app.DisplayAlerts = false; 
        app.AlertBeforeOverwriting = false; 
        wBook.Save(); 
        app.Save(filePath); 
        app.SaveWorkspace(filePath); 
        app.Quit(); 
        app = null; 
    } 
    catch (Exception err) 
    {
        return -1;
    } 
    finally 
    { 
    }
   </code>