List Info

Thread: Excel to XML




Excel to XML
user name
2007-03-29 17:41:00
Hello everyone,
 
I need your advice on this scenario.
 
I have a Excel spreadsheet which I want to convert into XML using perl. Then from which ;it can populated to the html pages automatically.  Does anyone has done this before,if so please help me out?
 
Thanks in advance for all ur help.
 
Mun
Re: Excel to XML
country flaguser name
Chile
2007-03-29 17:48:44
Hi ...

I dont know about XML, but you can use
the Spreadsheet-WriteExcel module to read
the Excel file and then make your html page.

rgmd

----- Original Message ----- 
From: "munni a" <munni05gmail.com>
To: <activeperllistserv.ActiveState.com>
Sent: Thursday, March 29, 2007 6:41 PM
Subject: Excel to XML


> Hello everyone,
>
> I need your advice on this scenario.
>
> I have a Excel spreadsheet which I want to convert into
XML using perl.
> Then from which it can populated to the html pages
automatically.  Does
> anyone has done this before,if so please help me out?
>
> Thanks in advance for all ur help.
>
> Mun
>


------------------------------------------------------------
----------------
----


> _______________________________________________
> ActivePerl mailing list
> ActivePerllistserv.ActiveState.com
> To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs

_______________________________________________
ActivePerl mailing list
ActivePerllistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs

Re: Excel to XML
country flaguser name
United States
2007-03-29 17:51:52
munni a wrote:
> Hello everyone,
>  
> I need your advice on this scenario.
>  
> I have a Excel spreadsheet which I want to convert into
XML using perl. 
> Then from which it can populated to the html pages
automatically.  Does 
> anyone has done this before,if so please help me out?
>  
> Thanks in advance for all ur help.

If you're on Win32 and you don't have the option to save in
XML format
or you want specific data from the sheet, I would think
Win32::OLE would
handle it for you.  You could pick and choose which data you
want and
format it any way you like.  Win32::ODBC would be another
possible choice
and Spreadsheet::ParseExcel if not on Windoze.

_______________________________________________
ActivePerl mailing list
ActivePerllistserv.ActiveState.com
To unsubscribe: http:/
/listserv.ActiveState.com/mailman/mysubs

[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )