excel

Treecell 1.2 Released with Graph and Heat Map

Screenshot of Treecell

Treecell helps you visualize data from Excel files

Heat Map

Version 1.2 adds heat map:

  • Color gradient of the background of the cell based on the value of the number
  • From dark red (low) to dark green (high)
  • Based on zero, minimum, mean or medium
  • Based on other values in the same column or in numbers in all columns
Treecell Heat Map

Graph

Version 1.2 adds multiple graph possibilities

Different sort of graphs in Treecell 1.2

Show graph of a column value

  • Vertical bars
  • Horizontal bars
  • Disc
  • Navigate sub sections by click on the chart color (and up)
  • Switch column with dropdown
  • Take a screenshot of graph
  • Based on selected section or section + sub-sections

And more

  • Breadcrumbs and navigate table in ‘Next Column Stats’
  • Drop Excel files in the interface to open them
  • More than 50 changes in the application framework

Download for free and more info at Treecell | View Excel files as tree view (japplis.com)

🆕Sheet Viewer 1.0ß

Excel sheet on top of other windows

Sheet Viewer, a software to view Excel sheets above your other windows has been released.

You need to select:

  • The file to open (xslx, xls, csv)
  • The sheet to view
  • The top left and bottom right cells to view
  • Whether you want the file to be reloaded on changed and being notified or not
  • If the sheet should be on top of other windows
  • The transparency/translucency of the sheet

Download for Windows, Mac OS or Linux at https://www.japplis.com/sheet-viewer/

Eclipse Plugin Applet Runner 2.0.0 Released

Applet Runner 2 plugin running in Eclipse IDE

I’m pleased to announce the release of Applet Runner 2.0.0 Eclipse IDE plugin.

What’s new:

  • Office
    • PDF Viewer
    • Microsoft Word Viewer (docx)
    • Excel & CSV Viewer (xlsx, xls, cvs)
    • Powerpoint Viewer (pptx)
    • MP3 Player (mp3, ogg)
    • Video Player (mp4, mkv, mp3, avi, …)
  • Text Utilities
    • Clipboard History
    • JSON Viewer
    • XML Viewer
    • YAML Viewer
  • Tetris game
  • Terminal (JediTerm)
  • HTML Browser (Browser FX) for Windows
  • Ant Commander Pro file manager as trial
  • Bug fixed and small improvements (See changes.txt)
Web Browser running in Applet Runner plugin in Eclipse IDE

Please share this post or video

Applet Runner 2.0 NetBeans Plugin Released

Stackoverflow website inside NetBeans

I’m pleased to announce the release of Applet Runner 2.0 NetBeans plugin.

This can hopefully bring using NetBeans to a new level of tooling. I’ve added many utility applets so that more type of files could be opened in NetBeans and more things can be done without leaving your favorite IDE.

What’s new:

  • Office
    • PDF Viewer
    • Microsoft Word Viewer (docx)
    • Excel & CSV Viewer (xlsx, xls, cvs)
    • Powerpoint Viewer (pptx)
    • MP3 Player (mp3, ogg)
    • Video Player (mp4, mkv, mp3, avi, …)
  • Text Utilities
    • Clipboard History
    • JSON Viewer
    • XML Viewer
    • YAML Viewer
  • Tetris game
  • Terminal (JediTerm)
  • HTML Browser (Browser FX) for Windows
  • Ant Commander Pro file manager as trial
  • Bug fixed and small improvements (See changes.txt)
Demo of new applets in Applet Runner 2.0 NetBeans plugin

If you liked what you’ve read / saw, share with friends and colleagues on social media.

An Excel Viewer for IntelliJ IDEA

Excel Viewer running in IntelliJ IDEA with the Applet Runner free plugin

I’ve just released a Microsoft Excel Viewer that runs in IntelliJ IDEA and other JetBrains IDE’s such as Android Studio or PyCharm.

It can open xlsx, xls and csv files, copy text from the spreadsheet or open the spreadsheet in an office suite.

To run it, download the free Applet Runner plugin from JetBrains marketplace and execute the free Excel Viewer applet located at https://www.japplis.com/applet-runner/office/excel-viewer.html.

Excel Viewer running in Applet Runner plugin in JetBrains IntelliJ IDEA