FileHelpers.ExcelNPOIStorage.ExcelNPOIStorage.InsertRecords C# (CSharp) Method

InsertRecords() public method

Insert all the records in the specified Excel File.
public InsertRecords ( object records ) : void
records object The records to insert.
return void
        public override void InsertRecords(object[] records)
        {
            if (records == null ||
                records.Length == 0)
                return;

            CultureInfo oldCulture = Thread.CurrentThread.CurrentCulture;
            Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
            try {
                int recordNumber = 0;
                OnProgress(new ProgressEventArgs(0, records.Length));

                InitExcel();

                if (OverrideFile && File.Exists(FileName))
                    File.Delete(FileName);

                if (!String.IsNullOrEmpty(TemplateFile)) {
                    if (File.Exists(TemplateFile) == false)
                        throw new ExcelBadUsageException(string.Concat("Template file not found: '", TemplateFile, "'"));

                    if (String.Compare(TemplateFile, FileName, StringComparison.OrdinalIgnoreCase) != 0)
                        File.Copy(TemplateFile, FileName, true);
                }

                OpenOrCreateWorkbook(FileName);

                AddHeaderColumns(StartColumn, StartRow);

                for (int i = 0; i < records.Length; i++) {
                    recordNumber++;
                    OnProgress(new ProgressEventArgs(recordNumber, records.Length));

                    WriteRowValues(RecordToValues(records[i]), StartRow + i, StartColumn);
                }

                SaveWorkbook(FileName);
            }
            catch {
                throw;
            }
            finally {
                CloseAndCleanUp();
                Thread.CurrentThread.CurrentCulture = oldCulture;
            }
        }

Usage Example

Example #1
0
        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();
        }
All Usage Examples Of FileHelpers.ExcelNPOIStorage.ExcelNPOIStorage::InsertRecords