Data Validation in Microsoft Excel with Aspose.Cells Cloud 19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn

We’re pleased to announce monthly release Aspose.Cells Cloud 19.10. It is already published and available on the aspose.cloud production server. It includes new exciting features including delete data validation from Excel worksheets and support to add HTML string in a cell along with the issue fixes reported in the previous versions of Aspose.Cells Cloud. We’ve also updated the SDKs of all the supporting platforms for new release. You can download the latest SDKs of Aspose.Cells Cloud from the download section now, and start exploring the new features. Please spare some time and check the release notes of this version for a complete list of enhancements and improvements.

In the following sections, I’ll give you a quick walk through of the data validation feature in Microsoft Excel using Aspose.Cells Cloud API.

Data Validation in Microsoft Excel

Aspose.Cells Cloud is an easy to use spreadsheet creation, manipulation and conversion REST API that provides all the features that Microsoft Excel provides without depending on Microsoft Excel. When setting up a workbook for your users, cell validation is one of the features that you can use data validation to restrict the type of data or the values that users enter into a cell, to make sure all data entries are accurate and consistent.

Here, I will explain how to do Data Validation in Excel using Aspose.Cells Cloud: add data validation, update data validation rule and remove all data validations from a worksheet. I am using cURL in the sample code, but you can use the SDK of your favorite programming language in your specific project. Currently, it supports SDKs for .NET, Java, PHP, Python, Ruby, Node.js, Android, Swift and Perl.

Add a data validation to a cell

Add a validation at index(A1) in a worksheet Sheet1.

Add/Update data validation rule

Add a custom data validation rule, YES or NO. Aspose.Cells Cloud API supports all types of data validation rules.

Data validation rule settings

Data validation rule test

Delete all data validations

Delete all data validations from the worksheet.

Feel free to drop us a comment below, or share your thoughts about the new version of Aspose.Cells Cloud API on our support forum.

Resources

If you are new to Aspose.Cells Cloud and have not already had a chance to try it, simply start a free trial today. All you need is to sign up with the aspose.cloud. Once you have signed up, you are ready to try the powerful file processing features offered by aspose.cloud. Following are some useful resources of Aspose.Cells Cloud you may need to accomplish your tasks.

Posted in Aspose.Cells Cloud Product Family | Tagged , , , , , | Leave a comment

Insert Checkbox and Radio Button in PDF with Aspose.PDF Cloud 19.10

Share on FacebookTweet about this on TwitterShare on LinkedIn

We’re happy to announce that Aspose.PDF Cloud 19.10 has been just released and available on production server. We’re continuously evolving the Aspose.PDF Cloud based on your feedback and requests. We’ve added support of Radio Box and Check Box fields in this release. These new exciting features will help you to create more interactive fillable PDF forms for data collection with simple HTTP requests. Spare some time and check release notes of this version for a complete list of enhancements and improvements.

Let me give you a quick walk through of some of these features, carried in this new release. We’ll be using Aspose.PDF Cloud SDK for .NET to exhibit new feature. However, you can use the SDK of your preferred programming language available at GitHub in your application directly.

How to Add Checkbox Field in PDF?

While working with PDF forms, you need to create checkboxes for data collection when there are lists of options and the user may select any number of choices, including zero, one, or several. In other words, each checkbox is independent of all other checkboxes in the list, so checking one box doesn’t uncheck the others. In this release, Aspose.PDF Cloud introduced support of checkbox field. Now you can add, update and get checkbox from PDF document or specific page or by checkbox field name.

Follow these steps to add a pre-selected checkbox field in a PDF document:

Step 1: Signup with aspose.cloud to get App SID and App key

Step 2: Create a new project in Visual Studio

Step 3: Install Aspose.PDF Cloud SDK for .NET NuGet Package

Step 4: Create a new method with following code to add a checkbox field in a PDF document

A cURL example to update the presentation slide size:

How to Add Radio Button Field in PDF?

A radio button is a very common control used in the forms. These are used when there is a list of two or more options that are mutually exclusive and the user must select exactly one choice. In other words, clicking a non-selected radio button will deselect whatever other button was previously selected in the list. Now you can add, update, and get radio buttons from PDF document or specific page or by radio button field name.

Here we demonstrate how to add a radio button into a PDF document using C#:

Repeat 1-3 steps from above example if required and use following code snippet to add radio button option in PDF document.

Output

To explore more about Aspose.PDF Cloud, please visit following resources.

Posted in Aspose.PDF Cloud Product Family | Tagged , , , | Leave a comment

REST API Solution to Rasterize SVG Images

Share on FacebookTweet about this on TwitterShare on LinkedIn

Hello guys, we are back with another monthly release of Aspose.Imaging Cloud, 19.9. It has been live now and available for consuming it in your application. In this release, we have introduced support of the SVG image format, improved memory usage, along with many other improvements and bug fixes of the issues reported in previous versions of Aspose.Imaging Cloud. For complete details of new features and enhancement, please check the release notes of this version. Read on to see what’s new.

Working with SVG

SVG is a more popular image format is being used because of its advantages over other file formats (like PNG, JPEG and GIF). But even then you came across a number of scenarios where you need to rasterize the SVG images. These SVG snapshots are your fallback images for old browsers, and are often required as thumbnail or preview images, particularly for social media sharing.

We have introduced new APIs for manipulating the SVG image format in current release. Now you can update the properties of an SVG image or convert it to a common raster image. All we can say is Aspose.Imaing Cloud transforms to a complete imaging solution for developers with the new feature.

Let me show you how easily you can manipulate SVG images in your application. I’m using cURL command for the demonstration. However, Aspose.Imaging Cloud also provides SDKs of all popular programming languages via GitHub and external Package Managers, so you can directly use Aspose.Imaging Cloud for image manipulation in your favorite platform directly, without a minimal learning curve.

Aspose.Imaging Cloud provides following two API for working with SVG. If you set the format to svg, API will update the source SVG image properties, otherwise it rasterizes image as per provided image format.

GET ​/imaging​/{name}​/svg – Update parameters of the existing SVG image.

POST ​/imaging​/svg – Update parameters of SVG image. Image data is passed as zero-indexed multipart/form-data content or as raw body stream.

Here we go. We will follow the stated steps for manipulating SVG image.

Update SVG Properties

  • Get JWT Access Token for authentication
  • Upload SVG source Image to Aspose default storage
  • Update SVG image properties

Rasterize SVG Image

  • Get JWT Access Token for authentication
  • Rasterize SVG image from request body and return raster image as response stream

Other Improvements

Here we go, we will follow these steps:

  • Added Svg native support
  • Established detailed logging
  • Improved memory usages in the AI API
  • Fixed bug Tiff inverts black and white after saving or transforming
  • Fixed Jpg to PNG conversion issue
  • Fixed EMF to SVG conversion issue
  • Fixed SVG to PNG incorrect conversion
  • After conversion .emf to .png some characters are not recognized correctly

We Want to Hear from You

Start a free trial today. All you need is to sign up with the aspose.cloud. Once you’ve signed up, you’re ready to try the powerful file processing features offered by aspose.cloud.

Feel free to drop us a comment below or share your thoughts about the new version of Aspose.Imaging Cloud API on our support forum.

Posted in Aspose.Imaging Cloud Product Family | Tagged , | Leave a comment

Convert Word Document to Binary TIFF Image with Aspose.Words Cloud 19.9

Share on FacebookTweet about this on TwitterShare on LinkedIn

We’re pleased to announce new monthly release Aspose.Words Cloud 19.9. It is already available on production server. The release of this month includes a number of improvements and fixes of the issue reported by our users in previous releases. Please check the detailed release notes of Aspose.Words Cloud 19.9 to get an idea of all the new enhancements and bug fixes made in this release. Read on to see what’s new.

Control Threshold for TIFF Binarization

When you are converting a Word document with images to TIFF image, you may have a requirement to control the TIFF image binarization threshold. We have introduced ImageSaveOptions.ThresholdForFloydSteinbergDithering property in this release. It determines the value of the binarization error in the Floyd-Steinberg method. It can be set when ImageBinarizationMethod FloydSteinbergDithering is used for binarization.

The default value of this property is 128. The higher the value, the darker the image. Below code example shows how to use this property while converting a DOCX to TIFF image.

Input Word Document

Output TIFF

Other Improvements

Aspose.Words Cloud provides three options to specify a range in a document

  • Added ScaleWmfFontsToMetafileSize property in MetafileRenderingOption
  • Added new ImageSaveOption “ThresholdForFloydSteinbergDithering”
  • Added ResolveFontNames property in HtmlSaveOption
  • Added text save option “ExportHeadersFootersMode”
  • Fixed an exception with Aspose.Words.FileFormatUtil
  • Fixed a bug when exporting a document to HTML with top heading
  • Fixed issue with the Paragraph API, it was returning incorrect NodeId and Href
  • Fixed issue with the Search API, it was returning Incorrect NodeId and Href of the Text
  • Fixed Error: Invalid URL: The URI scheme is not valid
  • Fixed the list marker detection (bullet symbol was blank for some fonts) issue in PDF to Word conversion
  • Improved text paragraph alignment for documents designed as books in PDF to Word conversion

Try It Out and Share Your Feedback

If you’ve not already tried our REST API, we encourage you to head over to Aspose.Words Cloud with a free trial today. All you need is to sign up with the aspose.cloud. Once you’ve signed up, you may go through the following useful resources of Aspose.Words Cloud.

We would love to hear what you think. If you have any questions and/or comments, please share them at support forum.

Posted in Aspose.Words Cloud Product Family | Tagged , , | Leave a comment

Aspose.3D Cloud is Coming Soon!

Share on FacebookTweet about this on TwitterShare on LinkedIn

We are glad to inform you that we are going to add a new Cloud API, Aspose.3D Cloud, in the products list of aspose.cloud soon. Aspose.3D Cloud is a platform independent REST API solution to manipulate 3D files without any 3D modeling and rendering software dependencies. It will enable developers to use it in their application to create, read, convert, modify and control the substance of 3D document formats easily with minimal learning curve. The REST API will be available very soon to be consumed in your applications.

Here is a brief overview of upcoming API. It will not be limited to the following features, but we will keep adding new useful features and support of new file formats in the API.

Salient features

1. Format convert

·       Convert whole file into different format

·       Convert part of the file into different format

2. Modeling and Data Processing

·       Parametric Modeling

a.    Create entities with specific property

·       Delete object from scene

a.    Delete nodes that has a Camera or Light attached, nodes are addressed by Object Addressing Path

3. Utilities

·       Extract 3D contents from PDF file

a.    Extract raw data (without any modification) from a password protected PDF file

b.    Extract scenes and save in different format

·       Triangulate meshes

a.    Triangulate whole file and save to different file

b.    Triangulate whole file and save to original file

c.     Triangulate part of the scene (Specified by OAP) and save the scene to different file

Supported formats

Aspose.3D Cloud REST API supports following file formats and operations:

Format Description Read Write Remarks
AMF Additive manufacturing file format Yes Yes  
RVM AVEVA Plant Design Management System Model Yes Yes  
DAE Collada Yes Yes  
FBX Autodesk FBX format. Yes Yes From 7.2 to 7.5, both ASCII/Binary.
OBJ Wavefront Obj Yes Yes Including mesh/point cloud support.
PDF 3D PDF Yes Yes Only supports standard U3D embedded 3D content in PDF. PRC and U3D with RH Mesh extension are not supported yet.
PLY Polygon File Format or Stanford Triangle Format Yes Yes Including mesh/point cloud support.
STL Standard Triangle Language Yes Yes  
U3D Universal3D Yes Yes  
GLTF GL Transmission Format Yes Yes  

Security and Authentication

The Aspose.3D Cloud REST API is secured and requires JWT authentication to authenticate your API calls using an app access key ID (App SID) and app secret access key(App KEY).

API Explorer

There will be an easy way to try out our API right away in your browser with the Aspose Cloud Web API References Explorer. There will be a collection of Swagger documentation for the Aspose.3D Cloud. You can get information about all the resources in the API. It will also provide testing and interactivity to our API endpoint documentation.

SDKs

Aspose.3D Cloud will come with SDKs for all popular programing languages hosted on our GitHub repository along with working examples, to get you started in no time.

Our first version

We are currently in the process of preparing Examples and Documentation for this new product. We have planned to release the first version of the Aspsoe.3D Cloud REST API soon with features shared above. If you have any questions or suggestions, please feel free to write on aspose.cloud Forum.

Please stay tuned to this blog for further updates.

Posted in Aspose.3D Cloud Product Family | Tagged , , | Leave a comment

How to Create and Read Barcodes with C# .NET REST API

Share on FacebookTweet about this on TwitterShare on LinkedIn

Barcodes are widely used around the world for the necessary data collection. A barcode is an encoded image used to represent data in a visual and machine-readable form. As a developer, you came across a number of scenarios, where you need to create and read barcodes in your application. In this article I will share a RESTful solution, Aspose.BarCode Cloud, for working with the barcode in your application. It eliminates the requirement to install and maintain a separate software to create and read barcodes.  

Aspose.BarCode Cloud is a platform independent barcode generation and recognition solution. It enables developers to create and read 1D (Linear), 2D and postal barcodes of 60+ symbologies that can be integrated universally into any workflow, html page, web application and desktop application. While creating new barcodes you can set barcode configurations, such as, barcode bar height, its dimensions, barcode image format and so on. The API generate and recognize barcode images in a variety of image formats: JPEG, PNG, GIF, BMP, TIFF, EMF, WMF, EXIF and ICON.

I’m using Aspose.BarCode Cloud SDK for .NET in this article. However, Aspose.BarCode Cloud also provides SDKs of all popular programming languages via GitHub and external Package Managers, so you can directly implement Aspose.BarCode Cloud in your favorite platform directly, with ease.

Here we go, we will follow these steps:

How to create the barcode

Step 1

First thing first, sign up with aspose.cloud to get your AppSID and AppKey

Step 2

Create a new project in Visual Studio and install Aspose.BarCode SDK for .NET package from NuGet

PM> Install-Package Aspose.BarCode-Cloud

Step 3

Copy paste the following code in the new project to create a barcode. I have used GetBarGenerate API method in this example, it creates the barcode with specified settings and returns the result in the response stream. I have created 2D barcode(datamatrix) in this example, you can create any barcode from the supported barcode types.

Step 4

Run the code, it will save the barcode image as PNG image format. You can use response stream as per your use case.

How to read the barcode

Repeat the above steps 1-2, if required.

Step 3

Copy paste the following code in the new project to read the barcode image from local drive. It recognizes the barcode image and return the barcode type and value.

Step 4

Run the code, the API reads all the barcode images from provided image and return the details in the response.

And that’s it. You see how easy is it to create a new barcode or read a barcode image with few lines of code.

What’s Next

In case you still haven’t met the API and haven’t worked with it, free trial is right here waiting for you to give it a try and explore the power of the Aspose.BarCode Cloud API. All you need is to sign up with the aspose.cloud and visit our developer resources for a quick start:

Posted in Aspose.Total Cloud Product Family, Aspose.BarCode Cloud Product Family | Tagged , , , , | Leave a comment

Control Chart Plot Area Layout and Set Slide Size with Aspose.Slides Cloud 19.9

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose.Slides Cloud 19.9 has been just released and it is also updated on production server. The latest release introduces some new features along with fixes of the issues reported in previous versions of Aspose.Slides Cloud. In this release, we have introduced LayoutTargetType property to control the layout mode of the chart plot area and support of Widescreen slide size along with many other important improvements. Please spare some time and check release notes of this version for a complete list of enhancements and improvements.

Let me give you a quick walk through some of these improvements, carried in this new release.

Setting Slide Size

The is a possibility that you have a mismatch between the size of your slides and the size of the medium you are projecting to because of your Microsoft PowerPoint version you have used to create your presentation and the device you are using to deliver the presentation. How you will fix it? Simply you should know the target device size before delivering your presentation to cope with the issue and update the presentation slide size.

Aspose.Slides Cloud has already provided an API PutSlidesSlideSize to update the size of presentations to industry standard presentation sizes. In this release, we have extended the list and added a new size; Widescreen. Following is the complete list of available sizes.

Available values for sizeType parameter:

 Parameter Value   Preset Size Type 
 OnScreen   On screen 4×3 
 LetterPaper   Letter 
 A4Paper   A4 
 Slide35mm   Slide 35mm 
 Overhead   Overhead 
 Banner   Banner 
 Custom   Custom Size 
 Ledger   Ledger 
 A3Paper   A3 
 B4IsoPaper   B4 ISO 
 B5IsoPaper   B5 ISO 
 B4JisPaper   B4 JIS 
 B5JisPaper   B5 JIS 
 HagakiCard   Hagaki Card 
 OnScreen16x9   On screen 16×9 
 OnScreen16x10   On screen 16×10 
 Widescreen   Widescreen 

A cURL example to update the presentation slide size:

Layout Mode of Chart Plot Area

While adding charts in the presentations, setting layout mode for chart plot area is one of the frequently used features. In this release, we have introduced a new property LayoutTargetType to control the layout of the chart plot area. Now you can define the layout of the plot area manually by setting the new property, with two possible values Inner or Outer, This property specifies whether to layout the plot area by its inside (not including axis and axis labels) or outside (including axis and axis labels).

The following cURL example demonstrates how to Set Layout Mode of chart:

Resources

If you are new to Aspose.Slides Cloud and have not already had a chance to try it, simply start a free trial today. All you need is to sign up with the aspose.cloud. Once you have signed up, you are ready to try the powerful file processing features offered by aspose.cloud. Following are some useful resources of Aspose.Slides Cloud you may need to accomplish your tasks.

Posted in Aspose.Slides Cloud Product Family | Tagged , | Leave a comment

A REST API Solution to Convert PDF to XML with Python

Share on FacebookTweet about this on TwitterShare on LinkedIn

XML is most widely used language for data sharing between humans and computers in this digital era. It provides portable and well-structured information, that makes it easier for applications and devices of all kinds to use, store, transmit, and display data. And in your daily routine, you came across the needs to convert different file formats to XML for data sharing or processing. As you know, PDF is most reliable file format used to exchange and distribute documents. So in this post, I will give you a walk through how to convert PDF to XML with Python using Aspose.PDF Cloud.

Aspose.PDF Cloud is a complete PDF file processing REST API solution, the choice of many Fortune 100 companies across 114 countries. It enables you to create, convert, split, merge, annotate, sign, stamp, watermark & protect PDF files on any platform without installation of any third-party plugin or software. It converts PDF documents to various industry standard file formats. However, in this post we will focus on PDF to XML conversion with Aspose.PDF Cloud SDK for Python. The API is not limited to Python SDK, but SDKs for other popular programming languages are available as well.

Let’s get started…

Step 1

First thing first, install Aspose.PDF SDK for Python package from PyPI.

pip install asposepdfcloud

Step 2

Free sign up with aspose.cloud to get your AppSID and AppKey.

Step 3

Create a Python module and copy paste following code in it. We have uploaded the source PDF document to Aspose default storage and converted PDF to XML in this code.

Step 4

Run the code in your favorite IDE, the output file is saved to Aspose default storage.

Looking forward to your feedback. Feel free to drop us a comment sharing your thoughts about Aspose.PDF Cloud API. Or let us know if you have any suggestions or if you need any particular features which you expect our REST API to have.

Posted in Aspose.PDF Cloud Product Family | Tagged , , , | Leave a comment

Introducing Aspose.Cells Cloud API Version V3

Share on FacebookTweet about this on TwitterShare on LinkedIn

Aspose is pleased to announce a new version of Aspose.Cells Cloud. Aspose.Cells Cloud 19.9 includes new API Version V3, built-in storage APIs along with many other improvements those make it more reliable and stable spreadsheet REST API solution. For complete details of new features and enhancement, please check the release notes of this version. Read on to see what’s new.

V3 API Version

The major change in this release is introduction of API version V3. We’ve implemented Aspose.Cells Cloud as a microservice with new API Version V3. It has more optimized and refined internal architecture. The new base URI will be as follows. Please note legacy v1.1 API version will remain available with older releases, but all new changes and updations will be made in latest API Version(V3) in the future.

https://api.aspose.cloud/v3.0/cells/

For improved security, we have introduced JWT(JSON Web Token) authentication in this release. The OAuth2 and URL signing authentication methods are not supported anymore in API Version V3. Let us show you how to get JWT Access Token.

Get Authentication Token

Storage APIs

This version made easy to work with cloud storage. Now you do not need to use a separate storage API for the purpose. The API includes methods for performing different storage related operations for a better user experience and unification

  • File API – Methods for upload, download, copy, move, delete files: input documents and rendering results, in the cloud storage
  • Folder API – Methods for create, copy, move, delete folders in the cloud storage
  • Storage API – Methods for getting storage information

How it Works

Let me give you a quick overview that how new API Version V3 works and difference between V3 and V1.1 by converting XLSX document to PDF. I’m using cURL for consuming REST APIs. However, Aspose.Cells Cloud also provides SDKs of all popular programming languages via GitHub and external Package Managers, so you can directly implement Aspose.Cells Cloud in your favorite platform with ease.

Here we go, we will follow these steps:

  • Get Access token for authentication
  • Upload source XLSX document to Storage
  • Convert XLSX to PDF
  • Download PDF document to local drive

Aspose.Cells Cloud V1.1

Aspose.Cells Cloud V3

We Want to Hear from You

Feel free to drop us a comment sharing your thoughts about the new version of Aspose.Cells Cloud API. Or let us know if you have any suggestions or if you need any particular features which you expect our REST API to have. And if you’ve not already had a chance to try our REST API, simply start a free trial today. All you need is to sign up with the aspose.cloud. Once you’ve signed up, you’re ready to try the powerful file processing features offered by aspose.cloud.

Posted in Aspose.Cells Cloud Product Family | Tagged , , | Leave a comment

Add Text Box Field in PDF Document with Aspose.PDF Cloud

Share on FacebookTweet about this on TwitterShare on LinkedIn

We’re happy to announce Aspose.PDF Cloud 19.9. With new release, the functionality of the API with PDF form fields is improved. Now you can add a Text Box field to PDF document, read all the Text Box fields from the PDF document, page or by name and update Text Box field in a PDF document with simple HTTP requests. In subsequent sections, I’ll give you and overview of these exciting features. You can check the release notes for the new version to get a complete list of new features and fixes.

Working with Text Box Field

The Text Box field allows the user to input variable information on PDF document. For example, information that is not constant or that cannot be predetermined with radio button choices, such as a name, department, or phone number. You can also create a text area where users can add multiline comments by setting Multiline property true.

Aspose.PDF Cloud API supports following operations with Text Box fields.

Now, let me show you how easily you can add a Text Box field in a PDF document and how to read the Text Box field from PDF documents? I am using Aspose.PDF Cloud SDK for .NET in this post. If you’re using some other programming language, then you can check SDK of your choice from our GitHub repository. It contains the SDKs of all popular programming language with complete source code of the SDK along with the working examples.

To use Aspose.PDF Cloud SDK for .NET, we just need to install it from the NuGet Package Manager in our project and here we go.

Add Text Box field

Get Text Box fields from PDF document

Get Text Box fields from PDF page

Get Text Box field by name

To learn more about Aspose.PDF Cloud using a free trial, all you need is to sign up with the aspose.cloud. Once you’ve signed up, you may go through the following useful resources of Aspose.PDF Cloud.

We are looking forward to your comments below or post a question or suggestion in the support forum. It helps us to continually improve and refine our API.

Posted in Aspose.PDF Cloud Product Family | Tagged , , , | Leave a comment