Four Stars

Update Excel Spreadsheet

I want to take data from one file (6800 records) and break them down into another file that

has formulas in the rows but are used when the data is populated into the file. Basically,

I am trying to prevent just copying and pasting the data (In Excel) from one file to another

and speed up the process. I have tried creating a job that would do this but get Java Heap error.

Probably due to the fact there are formulas in the cells that are to the right of where the data is.

(simple math calculations)

 

 

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: Update Excel Spreadsheet

I solved the issue by having Talend update a Template rather than an .xls file.

It was able to populate the fields and leave the cells with formulas in place.

 

 

1 REPLY
Four Stars

Re: Update Excel Spreadsheet

I solved the issue by having Talend update a Template rather than an .xls file.

It was able to populate the fields and leave the cells with formulas in place.