You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ofbiz.apache.org by Jacopo Cappellato <ti...@sastau.it> on 2006/08/11 09:39:14 UTC

Need help to test xml import to Excel

Hi all,

I'm testing the upcoming xml export from form widgets... my goal is to 
get a generic simple xml format that can be easily imported into MS Excel.

Unfortunately I don't even have Excel installed right now (I'm using 
OpenOffice)!

Could you please try to open the attached xml file with Excel (>=2003) 
and let me know if it works?

THANKS

Jacopo

Re: Need help to test xml import to Excel

Posted by Jacopo Cappellato <ti...@sastau.it>.

Thanks BJ,

that's interesting.
Now that we have a widget xml export that is readable by Excel, I think 
that setting the content type to "application/excel" in the controller 
will do the trick too (if one wants to auomatically invoke the Excel 
plugin).

Jacopo

BJ Freeman wrote:
> here is a trick I use.
> if you export a csv file but use the xls extension, the excel and 
> openoffice will import it as an excel sheet without the import step.
> 
> 
> Jacopo Cappellato sent the following on 8/11/2006 12:39 AM:
>> Hi all,
>>
>> I'm testing the upcoming xml export from form widgets... my goal is to 
>> get a generic simple xml format that can be easily imported into MS 
>> Excel.
>>
>> Unfortunately I don't even have Excel installed right now (I'm using 
>> OpenOffice)!
>>
>> Could you please try to open the attached xml file with Excel (>=2003) 
>> and let me know if it works?
>>
>> THANKS
>>
>> Jacopo
>>

Re: Need help to test xml import to Excel

Posted by BJ Freeman <bj...@free-man.net>.

here is a trick I use.
if you export a csv file but use the xls extension, the excel and 
openoffice will import it as an excel sheet without the import step.


Jacopo Cappellato sent the following on 8/11/2006 12:39 AM:
> Hi all,
> 
> I'm testing the upcoming xml export from form widgets... my goal is to 
> get a generic simple xml format that can be easily imported into MS Excel.
> 
> Unfortunately I don't even have Excel installed right now (I'm using 
> OpenOffice)!
> 
> Could you please try to open the attached xml file with Excel (>=2003) 
> and let me know if it works?
> 
> THANKS
> 
> Jacopo
>

Re: Need help to test xml import to Excel

Posted by rohit2006 <ro...@yahoo.com>.

the attachment is missing.



Jacopo Cappellato wrote:
> 
> Hi all,
> 
> I'm testing the upcoming xml export from form widgets... my goal is to 
> get a generic simple xml format that can be easily imported into MS Excel.
> 
> Unfortunately I don't even have Excel installed right now (I'm using 
> OpenOffice)!
> 
> Could you please try to open the attached xml file with Excel (>=2003) 
> and let me know if it works?
> 
> THANKS
> 
> Jacopo
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Need-help-to-test-xml-import-to-Excel-tf2089170.html#a5758150
Sent from the OFBiz - Dev forum at Nabble.com.

Re: Need help to test xml import to Excel

Posted by Jacopo Cappellato <ti...@sastau.it>.

That's great,

thanks Scott!!!

Jacopo

Scott Gray wrote:
> Hi Jacopo
> 
> Looks good to me, 8 columns 443 rows including headers
> 
> Regards
> Scott
> 
> Jacopo Cappellato wrote:
>> Hi all,
>>
>> I'm testing the upcoming xml export from form widgets... my goal is to 
>> get a generic simple xml format that can be easily imported into MS 
>> Excel.
>>
>> Unfortunately I don't even have Excel installed right now (I'm using 
>> OpenOffice)!
>>
>> Could you please try to open the attached xml file with Excel (>=2003) 
>> and let me know if it works?
>>
>> THANKS
>>
>> Jacopo
>>

Re: Need help to test xml import to Excel

Posted by Scott Gray <le...@gmail.com>.

Hi Jacopo

Looks good to me, 8 columns 443 rows including headers

Regards
Scott

Jacopo Cappellato wrote:
> Hi all,
>
> I'm testing the upcoming xml export from form widgets... my goal is to 
> get a generic simple xml format that can be easily imported into MS 
> Excel.
>
> Unfortunately I don't even have Excel installed right now (I'm using 
> OpenOffice)!
>
> Could you please try to open the attached xml file with Excel (>=2003) 
> and let me know if it works?
>
> THANKS
>
> Jacopo
>