Jython Code Examples to Deal with Microsoft Excel and OpenOffice Spreadsheets using Aspose.Cells for Java

Facebook

Twitter

Linkedin

We are pleased to announce “Aspose.Cells Java for Jython”, a new project for Jython developers. The project is aimed to provide useful examples for Jython developers who want to utilize Aspose.Cells for Java API in their Jython applications to deal with Microsoft Word and OpenOffice documents.

Download, Installation and Usage

Please check the links below to find instructions on downloading, installing and using Aspose.Words Java for Jython.

• Downloads and Installation

OR

You can download the latest version from:

• Pypi
• CodePlex
• GitHub

Quick Start Tutorial

The following example demonstrates how you can create a HelloWorld Excel document.

from asposecells import Settings
from com.aspose.cells import Workbook
from com.aspose.cells import FileFormatType

class HelloWorld:

    def __init__(self):
        dataDir = Settings.dataDir + 'quickstart/'

        workbook = Workbook()

        sheet = workbook.getWorksheets().get(0)

        cell = sheet.getCells().get("A1")

        cell.setValue("Hello World!")

        file_format_type = FileFormatType

        workbook.save(dataDir + "HelloWorld.xls" , file_format_type.EXCEL_97_TO_2003 )

        print "Document has been saved, please check the output file.";

if __name__ == '__main__':        
    HelloWorld()

Aspose.Cells Java for Jython Examples:

Quick Start

• Hello World

Working With Excel Files Jython

• File Handling Features
  • Opening Files
  • Saving Files
• Utility Features
  • Converting Excel to PDF Files
  • Converting Chart to Image
  • Converting Worksheet to Image
  • Managing Document Properties
  • Converting Worksheet to SVG
  • Converting to MHTML Files
  • Converting Excel Files to HTML

Working With Worksheets

• Management Features
  • Managing Worksheets
• Display Features
  • Hide or Unhide a Worksheet
  • Display or Hide Tabs
  • Display or Hide Scroll Bars
  • Display or Hide Gridlines
  • Page Break Preview
  • Freeze Panes
  • Split Panes
• Security Features
  • Protecting Worksheets
  • Unprotect a Worksheet
• Page Setup Features
  • Setting Page Options
• Value Features
  • Managing Page Breaks
  • Copying and Moving Worksheets

Working With Rows And Columns

• Inserting and Deleting Rows and Columns
• Hiding and Showing Rows and Columns
• Grouping and Ungrouping Rows and Columns
• Adjusting Row Height and Column Width
• Auto fit Rows and Columns
• Copying Rows and Columns

Aspose.Cells Java for Jython Documentation

Aspose.Cells Java for Jython Documentation is available to guide developers to get familiar with the specific resources and operations within the Aspose.Cells Java for Jython.

Start a Free Trial Today

Start a free trial today – all you need is to sign up with Aspose. Once you have signed up, you are ready to try powerful file processing features offered by Aspose file format APIs.

Customer Feedback

Your feedback is very important to us. Please feel free to provide feedback and raise feature requirements. We are keen to implement customer driven features since we are a 100% customer driven company.