aspose file tools*
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
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Converting large Excel Database to rms