public void PastblReadTest(string binName, string xlsxName)
{
using XlsxWriter xlsx = new XlsxWriter(xlsxName, true);
using FileStream stream = new FileStream(binName, FileMode.Open, FileAccess.Read);
IEnumerable<Record> records = Pastbl.ReadFile(stream);
xlsx.AppendRows("pastbl", records);
}
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));
}
}
}
}
