C# (CSharp) RecordExtractorFromExcel示例

示例#1

        public void should_extract_records_from_excel_file()
        {
            RecordExtractorFromExcel recordExtractor = new RecordExtractorFromExcel();

            var results = recordExtractor.ProcessSource(@"E:\IT_PROJECTS_2020\PersonalFinances2020\2020.xlsx");

            Assert.True(results.TotalDiscardedRecord == 0);
        }

示例#2

        public void should_write_bulk_import_file()
        {
            RecordExtractorFromExcel recordExtractor = new RecordExtractorFromExcel();

            var results = recordExtractor.ProcessSource(@"E:\IT_PROJECTS_2020\PersonalFinances2020\2020.xlsx");

            var bulkImportFileCreator = new BulkImportFileCreator();

            bulkImportFileCreator.CreateBulkImportFile(@"E:\IT_PROJECTS_2020\PersonalFinances2020\2020.txt", results.ValidRecords);
        }