Update Excel Spreadsheet

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)

 

 


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.

 

 


All Replies
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.

 

 

Moderator

Re: Update Excel Spreadsheet

Hello,

Great this issue has been fixed. Thanks for sharing your solution with us.

best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.