Community mailing list archives

community@mail.odoo.com

Re: how to read XLS file in Odoo

by Anders Wallenquist <anders.wallenquist@kreawit.se> - 09/11/2014 12:32:57
Den 2014-09-11 16:14, abhishek jaiswal skrev:
> Hi all,
>
> Can any body please tell how to read and process excel file in Odoo or 
> any example
>

If its OK to export your XLS file from Excel to the CSV-format its 
really easy to import the file.

First go to Settings / general settings and check "Allow users to import 
data from CSV files"

Then you got a new function in all your tree views; "Import" to the 
right of Create.

If you want to know what fields and what the field are called you can 
import in a special view, you can first export a record to
Excel (csv) and use this sheet as a template.

Hops this helps
Anders Wallenquist

> it will be very help full thanks
>
> -- 
> With Warm Regards
> Abhishek Jaiswal,
>
> _______________________________________________Allow users to import 
> data from CSV files
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>