This is the Linux app named POIRE whose latest release can be downloaded as poire-standalone-1.1.0_20150129.jar. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named POIRE with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start the OnWorks Linux online or Windows online emulator or MACOS online emulator from this website.
- 5. From the OnWorks Linux OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application, install it and run it.
SCREENSHOTS
Ad
POIRE
DESCRIPTION
Author: Ssire Kumar PuttaguntaIts a Microsoft Ms-office file handling with Java with the help of the POI classes. This API was develop on the top of the POI library. Its has so many methods for working with the excel files. These methods will work on the both the Excel formats .xls and .xlsx files.
In this i was included so many user friendly methods with the help of POI Library. This API will support all the excel formats like .xls and .xlsx with the help of the NPOIFSFileSystem & OPCPackage classes in the POI. with these classes the reading and writing into excel file would be faster.
These methods are mainly useful for the Automation testing if you want to read the data from the Excel on different sheets.
These methods will helpful while making any automation framework(Data driven & Hybride) with the Test data as Excel.
These Methods will be helpful in development when ever it require to read/write the data from the excel.
Features
- Create a new XLS, XLSX excel sheet.
- Get the data as per the excel format.If the cell having a formula it can be formated while retriving the data.
- Get the Excel Column data as a ArrayList<String> With specified column number/column Header and its sheet number/Name.
- Get the Excel row data as a ArrayList<String> With specified row Number/row header and its number/Name.
- Update random data in the existing Excel row with specified columnPositions values. update data may be random string or number can be possible.
- Update the data with specified arrayList in existing Excel row with columnPositions values.
- Update the data with specified arrayList in existing Excel row data with columnPositions values.
- Create/Update the data with specified arrayList based on sheet number insed in existing Excel.
- Create/Update the row with specified arrayList based on the sheet name in existing Excel.
- Create/Update the row from column position with specified arrayList based on the sheet name/sheet Number Index in existing Excel.
- Create/Update the row with same data from column position with specified rowdata based on the sheet name in existing Excel.
This is an application that can also be fetched from https://sourceforge.net/projects/poire/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.
