public void PastblWriteTest(string binName, string xlsxName, string alfFileName) { using XlsxReader xlsx = new XlsxReader(xlsxName); List<string> strings = xlsx.GetRows("XX", "pastbl") .Where(record => (string)record[0] == alfFileName) .Select(record => (string)record[1]) .ToList(); using FileStream stream = new FileStream(binName, FileMode.Create, FileAccess.Write); Pastbl.WriteFile(stream, strings); }
private void AddPastblFiles(XlsxReader xlsx, IProgress <string> progress) { foreach (string fileName in Pastbl.fileNames) { if (!HasFile(fileName)) { progress?.Report(string.Format("Adding {0}", fileName)); List <string> strings = xlsx.GetRows("XX", "pastbl") .Where(record => (string)record[0] == fileName) .Select(record => (string)record[1]) .ToList(); if (strings.Any()) { ZipArchiveEntry entry = zipArchive.CreateEntry(fileName); using Stream entryStream = entry.Open(); Pastbl.WriteFile(entryStream, strings); _entries.Add(new PatchZipEntry(entry)); } } } }