Perl Cloud SDK for Spreadsheet Processing

Perl Cloud SDK wraps Aspose.Cells Cloud API. The SDK enhances your Android apps to process & manipulate Microsoft Excel spreadsheets in the cloud, without requiring Microsoft Office®.

Excel File Manipulation in the Cloud

• Create Excel files from scratch via API or Smart Markers.
• Load, process & convert Excel files via Cloud SDK.
• Add, update or delete worksheet, charts, pictures, shapes, hyperlinks & validations.
• Add or remove cells area for conditional formatting from Excel worksheets.
• Insert or delete, horizontal or vertical page breaks.
• Add ListObject or convert ListObjects to a range of cells.
• Summarize data with Pivot Tables & Excel charts.
• Apply custom criteria to list filters of various types.
• Get, update, show or hide chart legend & titles.
• Manipulate page setup, header & footer.
• Create, update, fetch or delete document properties.
• Fetch the required shape from worksheet.
• Leverage the power of named ranges.

Feature & Enhancements in Version 22.2

• Update return value for the DeleteUnprotectWorksheet API on Aspose.Cells Cloud.
• Update return value for the PutProtectWorksheet API on Aspose.Cells Cloud.
• Update return value for the PostSetCellHtmlString API on Aspose.Cells Cloud.
• Update return value for the PostUpdateWorksheetProperty API on Aspose.Cells Cloud.

Read & Write Spreadsheet Formats

Microsoft Excel: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML

Save Spreadsheets As

Microsoft Excel: XLS, XLSX, XLSB OpenOffice: ODS SpreadsheetML: XML Text: CSV, TSV, TXT (TabDelimited) Web: HTML, MHTML Fixed Layout: PDF, XPS Images: PNG, JPG, TIFF, SVG Markdown: MD Other: DIF

Read Other Formats

SXC, FODS

Get Started with Aspose.Cells Cloud SDK for Perl

Please create an account at Aspose for Cloud and get your application information. The complete source code is available in this repository folder. You can either directly use it in your projector get CPAN distribution (recommended).

Convert an Excel File via Perl

    @api = AsposeCellsCloud::CellsApi.new("appsid","appkey")
    my $format = 'pdf'; # replace NULL with a proper value
    my $password = undef; # replace NULL with a proper value
    my $out_path = undef; # replace NULL with a proper value
    my $Book1_data =undef;
    my @fileinfos = stat("D:\\Projects\\Aspose\\Aspose.Cloud\\Aspose.Cells.Cloud.SDK\\src\\TestData\\Book1.xlsx");
    my $filelength = @fileinfos[7];
    open(DATA, "<D:\\Projects\\Aspose\\Aspose.Cloud\\Aspose.Cells.Cloud.SDK\\src\\TestData\\Book1.xlsx") or die "file.txt can not open, $!";
    binmode(DATA);
    # while( read (DATA, $Book1_data, 8)) {};
    read (DATA, $Book1_data, $filelength);
    close (DATA);    
    my $folder = $TEMPFOLDER; # replace NULL with a proper value
    # ready_file('api'=> $api, 'file'=>$name ,'folder' =>$folder) ;  
    $result = $api->cells_workbook_put_convert_workbook( workbook => $Book1_data, format => $format, password => $password, out_path => $out_path,folder =>$folder);conver

Aspose.Cells Cloud SDKs in Popular Languages

| .NET | Java | PHP | Python | Ruby | Node.js | Android | Swift | GO | |---|---|---|---|---|---|---|---|---| | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | | NuGet | Maven | Composer | PIP | GEM | NPM | Maven | POD | GO |

Product Page | Documentation | Live Demo | API Reference | Code Samples | Blog | Free Support | Free Trial