public void FillData(DataTable destinationTable) { var validFileNames = _asciiFiles.Select(x => x.GetResolvedFileNameOrNull()).Where(x => !string.IsNullOrEmpty(x)).ToArray(); if (validFileNames.Length == 0) { return; } if (_asciiFiles.Count == 1) { using (var stream = new System.IO.FileStream(validFileNames[0], System.IO.FileMode.Open, System.IO.FileAccess.Read, System.IO.FileShare.ReadWrite)) { AsciiImporter.ImportFromAsciiStream(destinationTable, stream, AsciiImporter.FileUrlStart + validFileNames[0], _asciiImportOptions); } } else { if (_asciiImportOptions.ImportMultipleStreamsVertically) { AsciiImporter.ImportFromMultipleAsciiFilesVertically(destinationTable, validFileNames, false, _asciiImportOptions); } else { AsciiImporter.ImportFromMultipleAsciiFilesHorizontally(destinationTable, validFileNames, false, _asciiImportOptions); } } }
public static void ImportAscii(IWorksheetController ctrl, System.IO.Stream myStream) { AsciiImporter importer = new AsciiImporter(myStream); AsciiImportOptions recognizedOptions = importer.Analyze(30, new AsciiImportOptions()); importer.ImportAscii(recognizedOptions,ctrl.Doc); }