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); } }