Compare Proposal

Nothing to compare.

Odoo11 Excel Merging Task

  • Posted at : 1 month ago
  • Post Similar Project
2500

Budget
7
Proposals
164
Views
Awarded
Status
Skills Required

Posted By -

BR

0.0
Projects Posted : 1
Projects Paid : 0
Services Purchased : 0
Total Spent :
141
Feedbacks : 0 %

Project Details show (+) hide (-)

Example:-

Strictly for Odoo11 i need this.Assume that the source excel files are present in some dirctory of localhost and master file shud be created in /tmp (Linux Server)

Explanation

I have 2 excel files 1) (Funk Au in attchement )First Excel File with 2 sheets and every sheet having image with data 2) Second sheet having lets supoose just data  (Ultraseinger filr in attchement )

Result expected:-

A master excel file exist with one sheet (Master Doc in attchemnt)

So this master file should have data of both excel 1 and exccel 2

Expected result=Master file should have 4 sheets in total=(1 sheet of master excel file itself+2 sheets of excel 1+ 1 sheet of excel 2 file)

Attached with this project can be considered as sorce excel1 and excel2 files

Note:
tried so many packages like xlwt,xlrd,pandas,openpyxl but nothing wrks out especially when my src files have images.

Copyfile of shutil works but for loop on src excel files just overwrites the data of last excel file which is not the excpcted result

Your Job Feed