I am reading from an excel that have merged cells
when i try to write the excel in my sheet all merged cells get mixed up .
I cannot control the merged cell range since the data is not fixed and fetched from other application
I am reading from an excel that have merged cells
when i try to write the excel in my sheet all merged cells get mixed up .
I cannot control the merged cell range since the data is not fixed and fetched from other application
@FMK
we would assume that in F we do find Tasks and in j Completeted Tasks
in the next row in F we do find Task 1 …
Within a column name adjuststement run the control on column names can be get back and also can be dynamic
Hi ppr
i couldn’t understand what do you mean
FileToReadRangFrom.xlsx (12.1 KB)
The final file when i try to write into it
FileToWriteRangeTo.xlsx (11.4 KB)
I also notice that column E,I , T , W changes the format and adds a year to it !
Do you need the columnnames while processing the input data or is it column access only done via column index?
Yes i can process it without the column names
@FMK
while readin and header detetection (add headers Flag) the row is used for header names. As it has merged cells it will split and:
As far as I do understand your question is how to handle this for the writing back to excel
Here we can think about following
As an alternate the readin column names can be flatten and renamed (Task_Task5) and the second row will be deleted. Another technique is to rename same as in Excel to the collumn letters A,B,C…)
Let us know your feedback
this worked for me thank you very much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.