| public InsertRecords ( object records ) : void | ||
| records | object | The records to insert. |
| return | void | |
private static void Main(string[] args)
{
/*var provider = new ExcelStorage(typeof(RaRecord)) {
StartRow = 2,
StartColumn = 1,
SheetName = "Sheet2",
FileName = "test.xlsx"
};*/
var provider = new ExcelNPOIStorage(typeof (RaRecord)) {
SheetName = "SheetBavo",
FileName = "test.xlsx"
};
provider.StartRow = 1;
provider.StartColumn = 0;
var records = new List<RaRecord>();
records.Add(new RaRecord() {
Level = 123.123m,
Name = "Dickie"
});
records.Add(new RaRecord() {
Level = null,
Name = "Bavo",
Project = "too many",
Startdate = DateTime.Now
});
provider.InsertRecords(records.ToArray());
//var res = (RaRecord[])provider.ExtractRecords();
}
private static void Main(string[] args)
{
/*var provider = new ExcelStorage(typeof(RaRecord)) {
StartRow = 2,
StartColumn = 1,
SheetName = "Sheet2",
FileName = "test.xlsx"
};*/
//Dynamic Records
var cb = new DelimitedClassBuilder("Customer", "|")
{
IgnoreFirstLines = 1,
IgnoreEmptyLines = true
};
cb.AddField("BirthDate", typeof(DateTime));
cb.LastField.TrimMode = TrimMode.Both;
cb.LastField.FieldNullValue = DateTime.Today;
cb.AddField("Name", typeof(string));
cb.LastField.FieldQuoted = true;
cb.LastField.QuoteChar = '"';
cb.AddField("Age", typeof(int));
var providerWithDynamicRecord = new ExcelNPOIStorage(cb.CreateRecordClass())
{
FileName =Directory.GetCurrentDirectory()+@"\testDynamicRecords.xlsx"
};
providerWithDynamicRecord.StartRow = 1;
providerWithDynamicRecord.StartColumn = 1;
dynamic dynamicRecord = Activator.CreateInstance(providerWithDynamicRecord.RecordType);
dynamicRecord.Name = "Jonh";
dynamicRecord.Age = 1;
dynamicRecord.BirthDate = DateTime.Now;
var valuesList = new List<dynamic>
{
dynamicRecord,
dynamicRecord
};
var columnsHeaders = ((System.Reflection.TypeInfo)(dynamicRecord.GetType())).DeclaredFields.Select(x => x.Name).ToList();
providerWithDynamicRecord.ColumnsHeaders = columnsHeaders;
providerWithDynamicRecord.InsertRecords(valuesList.ToArray());
//General export of excel with date time columns
var provider = new ExcelNPOIStorage(typeof (RaRecord))
{
FileName = Directory.GetCurrentDirectory() + @"\test.xlsx"
};
provider.StartRow = 0;
provider.StartColumn = 0;
var records = new List<RaRecord>();
records.Add(new RaRecord()
{
Level = 123.123m,
Name = "Dickie",
Startdate = DateTime.Now
});
var values = new List<int>
{
1,
2,
3
};
records.Add(new RaRecord()
{
Level = null,
Name = "Bavo",
Project = "too many",
Startdate = DateTime.Now,
ListOfIds = string.Join(",", values.Select(n => n.ToString(CultureInfo.InvariantCulture)).ToArray())
});
provider.HeaderRows = 4;
provider.InsertRecords(records.ToArray());
var res = (RaRecord[])provider.ExtractRecords();
}
