public void TestOpenSaveTsvWithOptions()
{
// Load
var testFile = TestFiles.Tsv;
var loadOptions = new DelimitedTextLoadOptions
{
FileInfo = testFile.ToFileInfo(),
OutputPath = DefaultOutputPath,
Separator = "\t",
ConvertNumericData = true,
TreatConsecutiveDelimitersAsOne = true
};
var loadResult = EditApi.Load(new LoadRequest(loadOptions));
Assert.IsNotEmpty(loadResult.HtmlPath);
Assert.IsNotEmpty(loadResult.ResourcesPath);
// Save
var saveOptions = new DelimitedTextSaveOptions
{
FileInfo = testFile.ToFileInfo(),
HtmlPath = loadResult.HtmlPath,
ResourcesPath = loadResult.ResourcesPath,
OutputPath = $"{DefaultOutputPath}/{testFile.FileName}",
Encoding = "UTF-8",
Format = "tsv",
KeepSeparatorsForBlankRow = true
};
var saveResult = EditApi.Save(new SaveRequest(saveOptions));
Assert.AreEqual(saveOptions.OutputPath, saveResult.Path);
}
public static void Run()
{
try
{
// Create necessary API instances
var editApi = new EditApi(Common.GetConfig());
var fileApi = new FileApi(Common.GetConfig());
// The document already uploaded into the storage.
// Load it into editable state
var loadOptions = new DelimitedTextLoadOptions
{
FileInfo = new FileInfo
{
FilePath = "Spreadsheet/sample.tsv"
},
OutputPath = "output"
};
var loadResult = editApi.Load(new LoadRequest(loadOptions));
// Download html document
var stream = fileApi.DownloadFile(new DownloadFileRequest(loadResult.HtmlPath));
var htmlString = new StreamReader(stream, Encoding.UTF8).ReadToEnd();
// Edit something...
htmlString = htmlString.Replace("32", "66");
// Upload html back to storage
fileApi.UploadFile(new UploadFileRequest(loadResult.HtmlPath,
new MemoryStream(Encoding.UTF8.GetBytes(htmlString))));
// Save html back to tsv
var saveOptions = new DelimitedTextSaveOptions
{
FileInfo = loadOptions.FileInfo,
OutputPath = "output/edited.tsv",
HtmlPath = loadResult.HtmlPath,
ResourcesPath = loadResult.ResourcesPath
};
var saveResult = editApi.Save(new SaveRequest(saveOptions));
// Done.
Console.WriteLine("Document edited: " + saveResult.Path);
}
catch (Exception e)
{
Console.WriteLine("Exception: " + e.Message);
}
}
