public string Application_GetServiceResponse(string url, ClientResponsePOSTRequest req) { try { // Create a request using a URL that can receive a post. WebRequest request = WebRequest.Create(url); // Set the Method property of the request to POST. request.Method = "POST"; // Create POST data and convert it to a byte array. string postData = req.ToString(); byte[] byteArray = Encoding.UTF8.GetBytes(postData); // Set the ContentType property of the WebRequest. request.ContentType = "application/x-www-form-urlencoded"; // Set the ContentLength property of the WebRequest. request.ContentLength = byteArray.Length; // Get the request stream. Stream dataStream = request.GetRequestStream(); // Write the data to the request stream. dataStream.Write(byteArray, 0, byteArray.Length); // Close the Stream object. dataStream.Close(); // Get the response. WebResponse response = request.GetResponse(); using (Stream a = response.GetResponseStream()) { StreamReader b = new StreamReader(a, Encoding.UTF8); string c = b.ReadToEnd(); return(c); } } catch (Exception ex) { } return("Unable to get response"); }
private void WriteToCell(Excel.Worksheet ws) { Excel.Worksheet activeWorksheet = ws; var servicePath = "http://plot.ly/clientresp"; var username = "******"; var apiKey = "4n5n0qb2hi"; ClientResponsePOSTRequest reqArgs = new ClientResponsePOSTRequest() { un = activeWorksheet.get_Range("L1").Value2, key = activeWorksheet.get_Range("L2").Value2, origin = activeWorksheet.get_Range("L3").Value2, platform = activeWorksheet.get_Range("L4").Value2, kwargs = new Kwargs() { filename = activeWorksheet.get_Range("L5").Value2, fileopt = activeWorksheet.get_Range("L6").Value2 }, args = "[[0, 1, 2], [3, 4, 5], [1, 2, 3], [6, 6, 5]]" }; string result = new PlotlyService().Application_GetServiceResponse(activeWorksheet.get_Range("K1").Value2, reqArgs); Excel.Range firstRow = activeWorksheet.get_Range("A1"); firstRow.Value2 = result; }
private void ButtonSubmit_Click(object sender, EventArgs e) { ClientResponsePOSTRequest reqArgs = new ClientResponsePOSTRequest() { un = textBoxUsername.Text, key = textBoxAPIKey.Text, origin = textBoxOrigin.Text, platform = textBoxPlatform.Text, kwargs = new Kwargs() { filename = textBoxFilename.Text, fileopt = textBoxFileOption.Text }, args = "[[0, 1, 2], [3, 4, 5], [1, 2, 3], [6, 6, 5]]" }; string x = textBoxXColumn.Text; string y = textBoxYColumn.Text; Excel.Range xCols = ws.get_Range(x + "1").EntireColumn; Excel.Range yCols = ws.get_Range(y + "1").EntireColumn; List <string> xList = new List <string>(); List <string> yList = new List <string>(); if (xCols != null && yCols != null && xCols.Count > 0 && yCols.Count > 0) { foreach (Excel.Range c in xCols.Cells) { if (c.Value2 == null || string.IsNullOrEmpty(c.Value2.ToString())) { break; } xList.Add(c.Value2.ToString()); } foreach (Excel.Range c in yCols.Cells) { if (c.Value2 == null || string.IsNullOrEmpty(c.Value2.ToString())) { break; } yList.Add(c.Value2.ToString()); } List <string> coords = new List <string>(); for (int i = 0; i < (xList.Count > yList.Count ? yList.Count : xList.Count); i++) { coords.Add(string.Format("[{0},{1}]", xList[i], yList[i])); } reqArgs.args = string.Format("[{0}]", string.Join(",", coords)); string result = new PlotlyService().Application_GetServiceResponse(textBoxServiceURL.Text, reqArgs); textBox10.Text = result; } }