public InsertRecords ( object records ) : void | ||
records | object | The records to insert. |
Результат | 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(); }