Skip to content

Instantly share code, notes, and snippets.

@hadoan
Last active May 26, 2016 06:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hadoan/c756e31d2d1a25563c80214e103eee17 to your computer and use it in GitHub Desktop.
Save hadoan/c756e31d2d1a25563c80214e103eee17 to your computer and use it in GitHub Desktop.
public static void PopulateDataTypesRandom()
{
using (var package = SpreadsheetDocumentWrapper.Open("MyWorkbook.xlsx"))
{
var table = package.WorkbookPart.GetTablePart("DataTypes").Table;
var data = new List<object[]>();
for (var i = 0; i < 10; i++)
{
data.Add(new
object[]
{
Utility.GetRandomString(),
Utility.GetRandomUri(),
Utility.GetRandomDateTime(),
Utility.GetRandomTimeSpan(),
Utility.GetRandomInteger(),
Utility.GetRandomDouble(),
Utility.GetRandomDecimal(),
Utility.GetRandomBoolean()
}
);
}
table.Fill(data.ToArray());
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment