Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Mobile » Java Micro Edition
Bookmark "Converting large Excel Database to rms " Watch "Converting large Excel Database to rms " New topic
Author

Converting large Excel Database to rms

deny winarto
Greenhorn

Joined: Jan 07, 2009
Posts: 3
Hi..
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..

thanks.

Ashley Burton
Greenhorn

Joined: Jul 15, 2009
Posts: 5
Hello,

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 - http://jexcelapi.sourceforge.net/.
Woking with csv stream may be much easier.


Ash

deny winarto
Greenhorn

Joined: Jan 07, 2009
Posts: 3
I ended up making it in 1044 .txt files, each with 1044 data.. :p
thanks anyway for reply
 
Don't get me started about those stupid light bulbs.
 
subject: Converting large Excel Database to rms
 
Similar Threads
How to send data from my PC to the phone ?
Creating database, Kanji Font on J2me
How to bundle some file with jar?
size of a string
Life time of RMS