Esempio n. 1
0
        private dynamic GetSaveOptions(string saveFilePath)
        {
            string extension = Path.GetExtension(saveFilePath).Replace(".", "");

            extension = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(extension);
            if (extension.Equals("Txt"))
            {
                extension = "Text";
            }
            dynamic options = null;

            foreach (var item in Enum.GetNames(typeof(WordProcessingFormats)))
            {
                if (item.Equals("Auto"))
                {
                    continue;
                }
                if (item.Equals(extension))
                {
                    options = new WordProcessingSaveOptions();
                    break;
                }
            }
            if (options == null)
            {
                options = new SpreadsheetSaveOptions();
            }
            return(options);
        }
        public void TestOpenSaveXlsxWithOptions()
        {
            // Load
            var testFile    = TestFiles.FourSheetsProtectedXlsx;
            var loadOptions = new SpreadsheetLoadOptions
            {
                FileInfo   = testFile.ToFileInfo(),
                OutputPath = DefaultOutputPath,
                ExcludeHiddenWorksheets = true
            };

            var loadResult = EditApi.Load(new LoadRequest(loadOptions));

            Assert.IsNotEmpty(loadResult.HtmlPath);
            Assert.IsNotEmpty(loadResult.ResourcesPath);

            // Save
            var saveOptions = new SpreadsheetSaveOptions
            {
                FileInfo           = testFile.ToFileInfo(),
                HtmlPath           = loadResult.HtmlPath,
                ResourcesPath      = loadResult.ResourcesPath,
                OutputPath         = $"{DefaultOutputPath}/{testFile.FileName}",
                Format             = "xlsx",
                Password           = testFile.Password,
                ProtectionPassword = testFile.Password,
                ProtectionType     = SpreadsheetSaveOptions.ProtectionTypeEnum.All
            };

            var saveResult = EditApi.Save(new SaveRequest(saveOptions));

            Assert.AreEqual(saveOptions.OutputPath, saveResult.Path);
        }
Esempio n. 3
0
        /// <summary>
        /// Sign spreadsheet and save it to different output type
        /// </summary>
        public static void Run()
        {
            Console.WriteLine("\n--------------------------------------------------------------------------------------------------------------------");
            Console.WriteLine("[Example Advanced Usage] # SaveSignedSpreadsheetWithDifferentOutputFileType : Sign spreadsheet and save it to different output type\n");

            // The path to the documents directory.
            string filePath       = Constants.SAMPLE_SPREADSHEET;
            string outputFilePath = Path.Combine(Constants.OutputPath, "SaveSignedOutputType", "Sample_XlsxToPdf.pdf");

            using (Signature signature = new Signature(filePath))
            {
                // create QRCode option with predefined QRCode text
                QrCodeSignOptions signOptions = new QrCodeSignOptions("JohnSmith")
                {
                    // setup QRCode encoding type
                    EncodeType = QrCodeTypes.QR,
                    // set signature position
                    Left = 100,
                    Top  = 100
                };

                SpreadsheetSaveOptions saveOptions = new SpreadsheetSaveOptions()
                {
                    FileFormat             = SpreadsheetSaveFileFormat.Pdf,
                    OverwriteExistingFiles = true
                };
                // sign document to file
                SignResult result = signature.Sign(outputFilePath, signOptions, saveOptions);
                Console.WriteLine($"\nSource document signed successfully with {result.Succeeded.Count} signature(s).\nFile saved at {outputFilePath}.");
            }
        }
Esempio n. 4
0
        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 SpreadsheetLoadOptions
                {
                    FileInfo = new FileInfo
                    {
                        FilePath = "Spreadsheet/four-sheets.xlsx"
                    },
                    OutputPath     = "output",
                    WorksheetIndex = 0
                };

                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("This is sample sheet", "This is sample sheep");

                // Upload html back to storage
                fileApi.UploadFile(new UploadFileRequest(loadResult.HtmlPath,
                                                         new MemoryStream(Encoding.UTF8.GetBytes(htmlString))));

                // Save html back to xlsx
                var saveOptions = new SpreadsheetSaveOptions
                {
                    FileInfo      = loadOptions.FileInfo,
                    OutputPath    = "output/edited.xlsx",
                    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);
            }
        }
        private ISaveOptions GetSaveOptions(string guid)
        {
            string       extension = Path.GetExtension(guid).Replace(".", "").ToLowerInvariant();
            ISaveOptions options   = null;

            if (extension.ToLowerInvariant().Equals("txt"))
            {
                options = new TextSaveOptions();
            }
            else
            {
                foreach (var item in typeof(WordProcessingFormats).GetFields())
                {
                    if (item.Name.ToLowerInvariant().Equals("auto"))
                    {
                        continue;
                    }
                    if (item.Name.ToLowerInvariant().Equals(extension))
                    {
                        WordProcessingFormats format = WordProcessingFormats.FromExtension(extension);
                        options = new WordProcessingSaveOptions(format);
                        break;
                    }
                }

                foreach (var item in typeof(PresentationFormats).GetFields())
                {
                    if (item.Name.ToLowerInvariant().Equals("auto"))
                    {
                        continue;
                    }

                    if (item.Name.ToLowerInvariant().Equals(extension))
                    {
                        PresentationFormats format = PresentationFormats.FromExtension(extension);
                        options = new PresentationSaveOptions(format);
                        break;
                    }
                }

                if (options == null)
                {
                    SpreadsheetFormats format = SpreadsheetFormats.FromExtension(extension);
                    options = new SpreadsheetSaveOptions(format);
                }
            }

            return(options);
        }