private static object[,] ImportCSV(string url, int startLine, bool reverse, object[] formats, bool hasHeaders)
{
CsvParseFormat formatter = new CsvParseFormat();
WebRequest request;
HttpWebResponse response;
List <string[]> sorted = new List <string[]>();
object[,] parsed;
int counter = 0;
foreach (object format in formats)
{
formatter.AddFormat(format.ToString());
}
request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "GET";
response = (HttpWebResponse)request.GetResponse();
try
{
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
string line;
string[] row;
while ((line = reader.ReadLine()) != null)
{
if (counter >= startLine)
{
row = line.Split(',');
sorted.Add(row);
}
counter++;
}
}
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message);
}
if (reverse)
{
sorted.Reverse(hasHeaders ? 1 : 0, sorted.Count - (hasHeaders ? 1 : 0));
}
parsed = new object[sorted.Count, sorted[0].Length];
for (int i = 0; i < sorted.Count; i++)
{
for (int j = 0; j < sorted[i].Length; j++)
{
// Don't bother parsing headers
if (hasHeaders && i == 0)
{
parsed[i, j] = sorted[i][j].ToString();
}
else
{
try
{
parsed[i, j] = formatter.Parse(j, sorted[i][j]);
}
catch (Exception)
{
// parsed[i, j] = "";
}
}
}
}
return(parsed);
}
public static object[,] ImportCSV(
[ExcelArgument("is the URL of the target CSV file.", Name = "url")] string url,
[ExcelArgument("is the first line of the CSV to begin parsing (starting with 0).",
Name = "start_line")] int startLine,
[ExcelArgument("is whether to reverse the results.", Name = "reverse")] bool reverse,
[ExcelArgument("is an array of formats: use \"double\", \"string\" or a date format.",
Name = "formats")] object[] formats,
[ExcelArgument("is whether the CSV file contains headers for each column.")] bool hasHeaders)
{
CsvParseFormat formatter = new CsvParseFormat();
WebRequest request;
HttpWebResponse response;
List <string[]> sorted = new List <string[]>();
object[,] parsed;
int counter = 0;
foreach (object format in formats)
{
formatter.AddFormat(format.ToString());
}
request = (HttpWebRequest)WebRequest.Create(url);
request.Method = "GET";
response = (HttpWebResponse)request.GetResponse();
try
{
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
string line;
string[] row;
while ((line = reader.ReadLine()) != null)
{
if (counter >= startLine)
{
row = line.Split(',');
sorted.Add(row);
}
counter++;
}
}
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message);
}
if (reverse)
{
sorted.Reverse(hasHeaders ? 1 : 0, sorted.Count - (hasHeaders ? 1 : 0));
}
parsed = new object[sorted.Count, sorted[0].Length];
for (int i = 0; i < sorted.Count; i++)
{
for (int j = 0; j < sorted[i].Length; j++)
{
// Don't bother parsing headers
if (hasHeaders && i == 0)
{
parsed[i, j] = sorted[i][j].ToString();
}
else
{
try
{
parsed[i, j] = formatter.Parse(j, sorted[i][j]);
}
catch (Exception)
{
// parsed[i, j] = "";
}
}
}
}
return(parsed);
}
