topic Re: How to read/write the excel having fixed format in Talend Studio

How to read/write the excel having fixed format

psujini — Tue, 10 Jul 2018 07:21:44 GMT

Hi,

I have a use case that I need to generate the same excel sheet with the proper data to the different user.

ie,.

Name		EMP_ID
DOB		Current DATE

Product code	Product Type	Total Products	Eligible Products
P001	xxx		1500
yyy		155
uuu
nnn		200
mmm		500
P002	aaa		12332
bbb		----
ccc		----
ddd		----
fff		-----
ggg		-----
jjj		-----
yyy		-----

This is my excel sheet I should update this sheet according to the user transaction in the total products column and send this sheet to user .i am confused ..how to read such kind of excel sheet and update that sheet.

Any suggestions! please help.

Thanks in Advance.

Re: How to read/write the excel having fixed format

psujini — Tue, 10 Jul 2018 07:25:46 GMT

please find this excel sheet above one is showing incorrect

Book2.xlsx

Re: How to read/write the excel having fixed format

Jesperrekuh — Tue, 10 Jul 2018 14:54:03 GMT

I dont have a real solution, but some thoughts on how to get the results you want.
In Excel you create a worksheet with a pivot table which points to the worksheet which contains the actual data. This file is your template, append the data... the user simply refreshes.
No idea of this could work or is possible...

From a process point of view why aren't they connecting to a data(view) / source to do it by themselves in Excel in stead of this "planning for failure" option?!

Re: How to read/write the excel having fixed format

psujini — Wed, 11 Jul 2018 06:16:51 GMT

Hi Dijke,

Thanks for your reply ...but a not getting the idea u told..if possible can u please elaborate.

Thanks ...

Re: How to read/write the excel having fixed format

Jesperrekuh — Wed, 11 Jul 2018 12:44:09 GMT

- Pivot tables in Excel? and writing the table data to a new Excel sheet in an existing template xlsx file?
or
- Users connect to a database(view) via ODBC and import the data in an Excel-file (a template like above)

If you arent familar with ODBC, Excel, pivot tables please google a bit. plenty of info...