public void Test_Csv_Excel_Csv()
{
using (var csvReader = new CsvAdapter())
using (var excelWriter = new ExcelNativeAdapter())
using (var excelReader = new ExcelNativeAdapter())
using (var csvWriter = new CsvAdapter())
{
csvReader.Enclosure = "\"";
csvReader.FileName = this.testDataPath + @"cd-Daten.txt";
var csvData = csvReader.ReadAllData();
excelWriter.FileName = Path.Combine(this.resultPath, "cd-Daten.xls");
excelWriter.SheetName = "Tabelle1";
excelWriter.CreateNewFile();
excelWriter.Connect();
excelWriter.WriteAllData(csvData);
excelWriter.Disconnect();
excelReader.FileName = excelWriter.FileName;
excelReader.SheetName = excelWriter.SheetName;
excelReader.Connect();
var accessData = excelReader.ReadAllData();
csvWriter.Encoding = csvReader.Encoding;
csvWriter.Enclosure = csvReader.Enclosure;
csvWriter.FileName = this.resultPath + @"cd-Daten_ExcelRoundtrip.csv";
csvWriter.WriteAllData(accessData);
if (!FileUtil.CompareFiles(csvReader.FileName, csvWriter.FileName))
{
throw new Exception("Original and copied file do not match");
}
}
}
public void Test_Csv_Access_Csv()
{
DirectoryUtil.ClearDirectory(this.resultPath);
using (var csvReader = new CsvAdapter())
using (var accessWriter = new AccessAdapter())
using (var accessReader = new AccessAdapter())
using (var csvWriter = new CsvAdapter())
{
csvReader.Enclosure = "";
csvReader.FileName = this.testDataPath + @"StringData.csv";
csvReader.AutoDetectEncoding();
var csvData = csvReader.ReadAllData();
accessWriter.FileName = Path.Combine(this.resultPath, "cd-Daten.mdb");
accessWriter.TableName = "Tabelle1";
accessWriter.CreateNewFile();
accessWriter.Connect();
accessWriter.WriteAllData(csvData);
accessWriter.Disconnect();
accessReader.FileName = accessWriter.FileName;
accessReader.TableName = accessWriter.TableName;
accessReader.Connect();
var accessData = accessReader.ReadAllData();
accessReader.Disconnect();
csvWriter.Encoding = csvReader.Encoding;
csvWriter.Enclosure = csvReader.Enclosure;
csvWriter.FileName = this.resultPath + @"cd-Daten_AccessRoundtrip.csv";
csvWriter.WriteAllData(accessData);
if (!FileUtil.CompareFiles(csvReader.FileName, csvWriter.FileName))
{
throw new Exception("Original and copied file do not match");
}
}
}
