public static CsvDataSheet Download(AbsoluteUri location)
{
if (null == location)
{
throw new ArgumentNullException("location");
}
CsvDataSheet csv = null;
var request = WebRequest.Create((Uri)location);
using (var response = request.GetResponse())
{
using (var stream = response.GetResponseStream())
{
if (null != stream)
{
using (var reader = new StreamReader(stream))
{
#if NET20
var file = new FileInfo(StringExtensionMethods.FormatWith("{0}.csv", AlphaDecimal.Random()));
FileInfoExtensionMethods.Create(file, reader.ReadToEnd());
#else
var file = new FileInfo("{0}.csv".FormatWith(AlphaDecimal.Random()));
file.Create(reader.ReadToEnd());
#endif
csv = new CsvDataSheet(file);
}
}
}
}
return csv;
}
private static void Process(CsvDataSheet sheet)
{
Console.WriteLine(Resources.CsvFileInfo, sheet.Info.FullName);
var count = 0;
foreach (var entry in sheet)
{
if (0 == count)
{
var columns = new StringBuilder();
foreach (var key in entry.Keys)
{
var format = 0 == columns.Length
? "Columns: "
: "{0} ".FormatWith(Environment.NewLine);
columns.Append(format + key);
}
Console.WriteLine(columns);
}
count++;
}
Console.WriteLine(Resources.CsvEntryCount, count);
}
private static void Process(CsvDataSheet sheet)
{
Console.WriteLine(Resources.CsvFileInfo, sheet.Info.FullName);
var count = 0;
foreach (var entry in sheet)
{
if (0 == count)
{
var columns = new StringBuilder();
foreach (var key in entry.Keys)
{
var format = 0 == columns.Length
? "Columns: "
: "{0} ".FormatWith(Environment.NewLine);
columns.Append(format + key);
}
Console.WriteLine(columns);
}
count++;
}
Console.WriteLine(Resources.CsvEntryCount, count);
}
public void op_IEnumerable_GetEnumerator()
{
using (var file = new TempFile())
{
file.Info.AppendLine("name");
file.Info.AppendLine("Example");
IEnumerable enumerable = new CsvDataSheet(file.Info);
foreach (var entry in enumerable.Cast<KeyStringDictionary>())
{
Assert.Equal("Example", entry["name"]);
}
}
}
public void usage(CsvDataSheet csv)
{
Assert.Equal("A1", csv.First()["A"]);
Assert.Equal("B2", csv.Last()["B"]);
}
public void usage_whenMultipleParameters(CsvDataSheet one,
CsvDataSheet two)
{
Assert.Equal("one", one.First()["COLUMN"]);
Assert.Equal("two", two.First()["COLUMN"]);
}
public void usage(CsvDataSheet sheet)
{
Assert.Equal("A1", sheet.First()["A"]);
Assert.Equal("B2", sheet.Last()["B"]);
}
