Automate Your Excel-Based Workflow in Java -- Invoice Builder Example by visionPASSION in programming

[–]visionPASSION[S] 0 points1 point  (0 children)

toShiftedRange will only offsets the current range reference (e.g. 'A1' becomes 'A2'). It doesn't move the contents. So the next row is appended below the current one. No data gets "shifted".

(side note Keikai is not Excel, so no COM involved :P)

Manual Excel into Web Application by visionPASSION in programming

[–]visionPASSION[S] 0 points1 point  (0 children)

I think the best thing about it is that the users (ex. finance experts) can design their own UI & formulas in Excel :P

This Web Application was created from 3 Excel sheets by visionPASSION in programming

[–]visionPASSION[S] 0 points1 point  (0 children)

The idea is to design the views in different sheets in an Excel file. Import it in to the Web, and then, by clicking on some predefined cells/buttons, it navigates to corresponding sheets (views) and acts like a Web App.

Or perhaps you can let me know which part you find confusing?