Example #1
0
        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);
                }
            }
        }
Example #2
0
 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);
 }