converting xls to xml---slow process...

I have a need to convert an excel database to an xml document that I can publish on the intranet.
I have a xls with macro that I believe is close to doing this conversion but it is not working properly.

Any thoughts on it?

I have zipped it and a sample excel database up along with the xsl that is to publish the xml on the web.

Hi All,

Thought I should clarify the attachment. Never mind the strange names, I have torn apart a more robust upload tool and just streamlined it to do xls to xml conversion, but I'm getting errors.

First download and save files to your hard drive. Then, you need to open the "erqWizard.xls" first and click on the large button. This will open a browser where you find and open the "Template.xls" . This is where the error is coming up. Clicking debug will take you straight to the code. If someone could offer coding changes that do not add more errors, it sure would be appreciated!!

Thanks in advance!!!

There is an example around, made with jsp, that uses Jakarta POI to convert from Excel to Html.
Works well enough and is platform independent.

Thanks so much.

I did download the JavaExcelApi and Ant, but just as did Charkus some months ago, along came the solution.


It wasn't without some struggling but I completed the code to the erqWizard tool with the help of a friend.

I basically had code in the wrong place. After I cleaned that up and changed my processing instructions to be in line with xml and the correct no. of VBA arguments I was fine.

Thank you so very much!!

If you solved your problem, then cool

However what I use for such coversion is a little product called Open Office which can automate via a Java API. I then call the java classes with PHP (ain't PHP cool like that). OOo converts Excel, Word and Powerpoint to XML, and Excel to MathML (including formulas). Don't tell anyone I told you, its our "competitive advantage" ... lol

Good luck,
Z.

I am doing my thesis which requires conversion of xls to xml. I have no clue to do that by OOo even i have read the development guide and others. Do u need to have OOo installed in server? Can u just pull out the library class and implement in ur own program?
Thank you very much

wyen,

Hopefully Zitan will reply you, as I don't have any experience with open office.


Zitan,

I plan on building myself a server here shortly. I want to put Gnu/Linux on one hard drive and Windows 2000 server on the other. Any specific recommendations as to type of RAM (the amount I'm thinking will probably have to be 512M) and/ or type of processor? Also what about the brand or type of motherboard and power supply, or doesn't that matter as long as it is compatible?

Thanks in advance!

Cathy S.