Skip to main content
Solved

Merged Cells in excel

  • November 9, 2015
  • 8 replies
  • 168 views

jdh
Contributor
Forum|alt.badge.img+28
  • Contributor
Is there any way to write merged cells in excel:

 

Best answer by mark2atsafe

Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

View original
Did this help you find an answer to your question?

8 replies

mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • Best Answer
  • November 9, 2015
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • November 9, 2015
mark2atsafe wrote:
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

btw If you need proper merged cell writing support, please do contact the support team (www.safe.com/support) and ask them to file an enhancement request.


jdh
Contributor
Forum|alt.badge.img+28
  • Author
  • Contributor
  • November 9, 2015
mark2atsafe wrote:
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

How would you go about setting up/writing to that template? I have no idea of the number of features that would result, but I know they would always be paired.


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • November 9, 2015
mark2atsafe wrote:
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

Well, I would do a bit of testing. Create a spreadsheet with Excel where two cells are merged (like in your image). Then try writing a couple of features from FME to that file. If you look in the parameters for the Excel Writer there is one for the Template File to use (i.e. write to this excel file and don't overwrite the structure). I'm not sure whether to expect the first feature to stay in the cell, or the second feature to overwrite it - but I'm confident that it would be consistent.


mark2atsafe
Safer
Forum|alt.badge.img+44
  • Safer
  • November 9, 2015
mark2atsafe wrote:
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

Just tried it. The first feature wins. So if Attr1 has values 1,2,3,4 and Attr2 has values 1,2,3,4, the cells are:

nb: I just set the template to use, but then had to set a feature type parameter to tell FME to start writing at cell A2.


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • January 22, 2019
mark2atsafe wrote:
Sadly, no, FME can only read, not write merged cells. However, if you were to use a template that already had the cells merged in it, I hope they would be preserved as such.

 

I know there have been some significant changes to the excel writer since this post, are merged cells still not possible?


jkr_wrk
Influencer
Forum|alt.badge.img+29
  • January 23, 2019
ebygomm wrote:

I know there have been some significant changes to the excel writer since this post, are merged cells still not possible?

Tested in beta. I see no hints that it is possible now.

Vertical merged reads as missing attribute. Horizontal merged reads both cells as same value.

 

normal

 

normal

 

normal

 

Vertical mergedHorizontal mergednormal

 

normal

 


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • January 23, 2019
jkr_da wrote:

Tested in beta. I see no hints that it is possible now.

Vertical merged reads as missing attribute. Horizontal merged reads both cells as same value.

 

normal

 

normal

 

normal

 

Vertical mergedHorizontal mergednormal

 

normal

 

Thanks for checking


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings