This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Java Micro Edition and the fly likes Converting large Excel Database to rms Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Mobile » Java Micro Edition
Bookmark "Converting large Excel Database to rms " Watch "Converting large Excel Database to rms " New topic

Converting large Excel Database to rms

deny winarto

Joined: Jan 07, 2009
Posts: 3
I'm fairly new at j2me.. I got a question regarding database handling in j2me..

I'm working on a map application that would display the shortest route between one 'node' to another 'node' in a map..
And this routing procedure works based on Floyd Algorithm, and this algorithm uses a HUGE node matrix database that i've made in Excel
The spreadsheet consists of 1044 x 1044 vertices.. The file size is around 3.9 MB (in .xlsm format)

So my question is, is it possible to fit in such large data into a j2me application?
If it's possible with rms, is there anyway to convert from excel format to rms?
If it's not can anyone suggest me another way to use this database in J2me?
Btw If possible i want to make this application offline..


Ashley Burton

Joined: Jul 15, 2009
Posts: 5

I don't know if this is what you need, but it would be more efficient to convert your excel data to csv.
You can do it automatically with jexcelapi -
Woking with csv stream may be much easier.


deny winarto

Joined: Jan 07, 2009
Posts: 3
I ended up making it in 1044 .txt files, each with 1044 data.. :p
thanks anyway for reply
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Converting large Excel Database to rms
It's not a secret anymore!